In Feburary 2016 30,
Find the FTP address of the remote file, including the file's complete path. (If you are clicking through a link on a Web site, you will not need to know the path, since the Webmaster will have coded this into the link.)
Enter the FTP address in the browser address box, the same way you would enter an HTTP (Web) address. For example, your FTP address might be something like this: ftp://ftp.simtel.net/freeware/myfile.zip.
Press the Enter key.
Enter any ID information or passwords that you may have been assigned, if prompted. Some Web sites may be set up so you are not required to enter passwords or log-in IDs.
Choose the Save File to Disk option if given the choice between that and Open File.
Identify the folder on your hard drive where you want the downloaded file to be stored. Accept the default or choose another folder.
Wait while the file downloads to your hard disk.
In Feburary 2016 30,
Showing posts with label box. Show all posts
Showing posts with label box. Show all posts
Tuesday, 1 March 2016
How to Set Joomla Text SizeIn Feburary 2016 30,
In Feburary 2016 30,
Log into the administrative panel of the website. You will need the user name and password to gain access.
Point your mouse on “Content” located in the main menu. A drop-down menu will appear. Click on “Article Manager.”
Open the article you wish to modify. The Article Manager: Edit Article screen will open. Scroll down to the text box located in the Edit Article box.
Highlight the text you want to change. Click on the arrow located to the right of the Paragraph options box. A list of text styles will appear. These styles include Paragraph, Heading 1, Heading 2 and Heading 3. The font family and size that correlate to these styles are preset in the template’s cascading style sheet (CSS). Choose an option. The text size will change. Preview your changes to make sure they appear as you want.
Click on “HTML” located below the Text Style options box. This gives you another option for making text size changes. Making changes in the article's code allows you to apply customized changes. An HTML box opens. You will need to know HTML in order to apply changes in this box. Type in the code just as you would apply any HTML. A simple HTML code that will change font size is: Your text here
Making Text Size Changes in Modules
Point your mouse on “Extensions” located in the main menu. A drop-down menu will appear. Click on “Module Manager.”
Click on “New” to create a new module. You can also modify an existing module by opening up that module. However, you can only modify the text in “Custom HTML” modules through this method.
Click on “Custom HTML.” This brings up a screen similar to the Edit Article screen. Follow the instructions outlined for customizing an article.
In Feburary 2016 30,
Log into the administrative panel of the website. You will need the user name and password to gain access.
Point your mouse on “Content” located in the main menu. A drop-down menu will appear. Click on “Article Manager.”
Open the article you wish to modify. The Article Manager: Edit Article screen will open. Scroll down to the text box located in the Edit Article box.
Highlight the text you want to change. Click on the arrow located to the right of the Paragraph options box. A list of text styles will appear. These styles include Paragraph, Heading 1, Heading 2 and Heading 3. The font family and size that correlate to these styles are preset in the template’s cascading style sheet (CSS). Choose an option. The text size will change. Preview your changes to make sure they appear as you want.
Click on “HTML” located below the Text Style options box. This gives you another option for making text size changes. Making changes in the article's code allows you to apply customized changes. An HTML box opens. You will need to know HTML in order to apply changes in this box. Type in the code just as you would apply any HTML. A simple HTML code that will change font size is: Your text here
Making Text Size Changes in Modules
Point your mouse on “Extensions” located in the main menu. A drop-down menu will appear. Click on “Module Manager.”
Click on “New” to create a new module. You can also modify an existing module by opening up that module. However, you can only modify the text in “Custom HTML” modules through this method.
Click on “Custom HTML.” This brings up a screen similar to the Edit Article screen. Follow the instructions outlined for customizing an article.
In Feburary 2016 30,
How to Connect to DB2 With SQL DeveloperIn Feburary 2016 30,
In Feburary 2016 30,
Open SQL Developer. Click 'File' in the top toolbar menu and click 'Open connection.'
Click the 'DB2' tab in the Connection dialog box. Enter the name of the DB2 database in the first box. Enter the host and port information, as well as the driver type. You can choose between entering 'IBM DB2 Application Driver' or 'IBM DB2 Network Driver' for the driver type. Enter the user name and password to access the DB2 database.
Click 'Info' at the bottom of the Connection dialog box to test the connection with the settings you entered. Click 'OK' to create the connection to the DB2 database.
In Feburary 2016 30,
Open SQL Developer. Click 'File' in the top toolbar menu and click 'Open connection.'
Click the 'DB2' tab in the Connection dialog box. Enter the name of the DB2 database in the first box. Enter the host and port information, as well as the driver type. You can choose between entering 'IBM DB2 Application Driver' or 'IBM DB2 Network Driver' for the driver type. Enter the user name and password to access the DB2 database.
Click 'Info' at the bottom of the Connection dialog box to test the connection with the settings you entered. Click 'OK' to create the connection to the DB2 database.
In Feburary 2016 30,
Monday, 29 February 2016
How to Upload a Dreamweaver Website Into Go Daddy HostingIn Feburary 2016 29,
In Feburary 2016 29,
Find the Host Name, FTP User Name and FTP Password you created when you opened your Go Daddy hosting account. You would have written this information down when you opened your account.
Open Dreamweaver. Go to 'Site' and then 'Manage Sites.'
Pick your website from the list given in the Manage Sites dialog box or click 'New' if you haven't started your website yet.
Choose 'Add New Server' when the setup window opens. Enter a name for your connection, something like 'Go Daddy' or your domain name would be easy to identify, but any name is OK.
Click 'FTP' from the connection menu and enter the FTP User Name and FTP Password you created with Go Daddy. Check the 'Save' box if you want Dreamweaver to remember your login information.
Type your domain name in the FTP box. Click the 'Test' button to confirm the connection. Leave any other fields blank or default unless you've set up special port or proxy settings in your home network or with Go Daddy.
Check 'Automatically upload files to server on save' if you want Dreamweaver to update your website every time you save a page.
Save the connection by clicking 'Save' and go to 'Edit,' then 'Preferences' in Windows. If you're using a Mac, click 'Dreamweaver' and then 'Preferences.'
Select your website from the list on the left and choose your upload settings. Establish whether the FTP connection will time out or terminate after a specified number of minutes. You can also set Dreamweaver to 'Prompt Before Moving Files on Server' and 'Save Files Before Putting.' Experiment until you find the settings that work for you.
In Feburary 2016 29,
Find the Host Name, FTP User Name and FTP Password you created when you opened your Go Daddy hosting account. You would have written this information down when you opened your account.
Open Dreamweaver. Go to 'Site' and then 'Manage Sites.'
Pick your website from the list given in the Manage Sites dialog box or click 'New' if you haven't started your website yet.
Choose 'Add New Server' when the setup window opens. Enter a name for your connection, something like 'Go Daddy' or your domain name would be easy to identify, but any name is OK.
Click 'FTP' from the connection menu and enter the FTP User Name and FTP Password you created with Go Daddy. Check the 'Save' box if you want Dreamweaver to remember your login information.
Type your domain name in the FTP box. Click the 'Test' button to confirm the connection. Leave any other fields blank or default unless you've set up special port or proxy settings in your home network or with Go Daddy.
Check 'Automatically upload files to server on save' if you want Dreamweaver to update your website every time you save a page.
Save the connection by clicking 'Save' and go to 'Edit,' then 'Preferences' in Windows. If you're using a Mac, click 'Dreamweaver' and then 'Preferences.'
Select your website from the list on the left and choose your upload settings. Establish whether the FTP connection will time out or terminate after a specified number of minutes. You can also set Dreamweaver to 'Prompt Before Moving Files on Server' and 'Save Files Before Putting.' Experiment until you find the settings that work for you.
In Feburary 2016 29,
How to Stop Embed YouTube From RedirectingIn Feburary 2016 29,
In Feburary 2016 29,
Visit the YouTube page that contains the video you wish to embed into your site.
Click 'Share' and select 'Embed.'
Launch Notepad and open the HTML file that contains the source code of the page into which you wish to embed the video. Copy the embed code from YouTube by right-clicking anywhere in the embed box and selecting 'Copy.' Paste the code into Notepad by right-clicking and selecting 'Paste.'
Locate the URL address of the YouTube video in the embed code you just pasted into Notepad. URL addresses of videos on YouTube look like the following: 'http://www.youtube.com/embed/videoID", where 'videoID' is an alphanumerical code that identifies the video.
Type or copy-and-paste '?modestbranding=1' after the videoID. The URL address should now look like the following example:
http://www.youtube.com/embed/VideoID?modestbranding=1
The 'modestbranding' parameter instructs YouTube to remove its logo from the embedded player and to disable redirecting.
Save your HTML file and upload it to the Web server by using your Web host's file manager or an FTP client.
In Feburary 2016 29,
Visit the YouTube page that contains the video you wish to embed into your site.
Click 'Share' and select 'Embed.'
Launch Notepad and open the HTML file that contains the source code of the page into which you wish to embed the video. Copy the embed code from YouTube by right-clicking anywhere in the embed box and selecting 'Copy.' Paste the code into Notepad by right-clicking and selecting 'Paste.'
Locate the URL address of the YouTube video in the embed code you just pasted into Notepad. URL addresses of videos on YouTube look like the following: 'http://www.youtube.com/embed/videoID", where 'videoID' is an alphanumerical code that identifies the video.
Type or copy-and-paste '?modestbranding=1' after the videoID. The URL address should now look like the following example:
http://www.youtube.com/embed/VideoID?modestbranding=1
The 'modestbranding' parameter instructs YouTube to remove its logo from the embedded player and to disable redirecting.
Save your HTML file and upload it to the Web server by using your Web host's file manager or an FTP client.
In Feburary 2016 29,
How to Specify a Port on the FTP Command LineIn Feburary 2016 29,
In Feburary 2016 29,
Click 'Start.'
Type 'cmd' into the search box.
Press 'Enter' to open the command prompt.
Type 'ftp example.com xx' into the Command Prompt, with 'xx' being the port that you need to specify.
Press 'Enter' to connect to the remote server.
In Feburary 2016 29,
Click 'Start.'
Type 'cmd' into the search box.
Press 'Enter' to open the command prompt.
Type 'ftp example.com xx' into the Command Prompt, with 'xx' being the port that you need to specify.
Press 'Enter' to connect to the remote server.
In Feburary 2016 29,
How to Import a MySQL DatabaseIn Feburary 2016 29,
In Feburary 2016 29,
Install phpMyAdmin software on your computer if it is not already installed. You can find phpMyAdmin software online at the phpMyAdmin homepage (see Resources below).
Log onto the phpMyAdmin page from your Web space. You will need the username and password assigned to you by your Web-hosting provider.
Select the database you wish to import the old data into from the drop-down Database Selection box on the left of the page.
Click the SQL tab toward the top of the interface.
Click the Browse button located toward the bottom of the page.
Find the .SQL file where it is saved on your hard drive, select it and click 'Open.'
Click the Go button. The data in your SQL file has now been imported into your database.
Using the SSH Command Line
Contact your hosting provider to gain SSH access.
Log into your Web space using an FTP client. You will need to know your username and password.
Find your existing .SQL database and upload it to your Web space using your FTP client. It doesn't matter where in your Web space you upload it to, as long as you execute the SSH command when you're in this folder.
Close your FTP program.
Log into your Web space using the appropriate SSH client. You will need the username and password assigned to you by your Web-hosting provider.
Enter the following into the command line, using your own database name, file name, username and password instead of the words in capitals.mysql -uUSERNAME -pPASSWORD DATABASENAME
In Feburary 2016 29,
Install phpMyAdmin software on your computer if it is not already installed. You can find phpMyAdmin software online at the phpMyAdmin homepage (see Resources below).
Log onto the phpMyAdmin page from your Web space. You will need the username and password assigned to you by your Web-hosting provider.
Select the database you wish to import the old data into from the drop-down Database Selection box on the left of the page.
Click the SQL tab toward the top of the interface.
Click the Browse button located toward the bottom of the page.
Find the .SQL file where it is saved on your hard drive, select it and click 'Open.'
Click the Go button. The data in your SQL file has now been imported into your database.
Using the SSH Command Line
Contact your hosting provider to gain SSH access.
Log into your Web space using an FTP client. You will need to know your username and password.
Find your existing .SQL database and upload it to your Web space using your FTP client. It doesn't matter where in your Web space you upload it to, as long as you execute the SSH command when you're in this folder.
Close your FTP program.
Log into your Web space using the appropriate SSH client. You will need the username and password assigned to you by your Web-hosting provider.
Enter the following into the command line, using your own database name, file name, username and password instead of the words in capitals.mysql -uUSERNAME -pPASSWORD DATABASENAME
In Feburary 2016 29,
Friday, 26 February 2016
Progress Bar TutorialIn Feburary 2016 26,
In Feburary 2016 26,
As an operation proceeds, the code continuously reads how much is completed and calculates the status. If the Minimum value is set to one and the Maximum to 100, the bar will fill half the bar display when 50 percent of the operation is completed. To perform this calculation, the programmer must know how long the operation will take. As an example, if the user is downloading a five MB file, by the time 2.5 MB have downloaded, the bar will have moved halfway across.
Create a Progress Bar
Start by creating a new project after opening Visual Basic. Click on 'File,' 'New Project' and select the 'Standard EXE' format. Add the ProgressBar control by clicking on 'Project,' 'Components.' Find the Microsoft Windows Common Controls in the list. Choose the Microsoft Visual Basic Common Controls (SP6) by placing a checkmark in the box next to the control. Click on 'Apply' and 'OK.' You should see the control in the list in the left panel. Double click on this to add it to the form.
Set the Properties
If working with an operation where the percentage of completion is easy to calculate like a file download, set the Minimum property in the Properties panel to '1' and the maximum to '100.' Another way to set the maximum is to have the code count the number of iterations of some operation, compare this to the total number, and calculate where the bar should be. Height and Left properties control the height of the bar itself and where it appears from the left of the screen. Only two other properties matter: Whether the bar runs across the screen vertically or horizontally and whether incremental chunks appear or the bar is smoother. Choose these from the 'Orientation' and 'Scrolling Properties.' If the maximum cannot be predetermined, it is possible to use an Animation control to keep the bar moving until the operation completes. This enhancement goes beyond the level of this tutorial. Since the bar should not appear until an operation commences, set the Visible property to 'False.' For this example, set the Maximum property to '10000' and leave the Minimum at '0.' Finally, add a Command Button control from the Tools list to the form to initiate action. Change the (Name) property to 'btnStart' and the Caption to 'Start.'
Write the Code
Click on 'View,' 'Code' to open the programming window. Type the lines below exactly as shown. The first three lines load the form and make the Progress Bar visible. The rest of the code runs through a repetitive sequence to demonstrate the bar. The end number in this code is set very high to slow the Progress Bar down for visibility. Replace the steps in the second section beginning with 'Private Sub btnStart_Click() and ending 'End Sub' with whatever event you are timing to get a new ProgressBar1.Value. Always add a command to change the visibility of the bar to 'False' when the routine finishes.Private Sub Form_Load()
ProgressBar1.Visible = True
End SubPrivate Sub btnStart_Click()
Dim n As Integer
For n = 1 To 10000
ProgressBar1.Value = n
Next n
End SubTest the code by pressing the 'F5' key.
Visual Basic 2008 Express Edition Version
In the Visual Basic 2008, substitute the following lines for the lines beginning Private Sub:Private Sub Form1_Load(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase.Load
Private Sub btnStart_Click(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles btnStart.Click
In Feburary 2016 26,
As an operation proceeds, the code continuously reads how much is completed and calculates the status. If the Minimum value is set to one and the Maximum to 100, the bar will fill half the bar display when 50 percent of the operation is completed. To perform this calculation, the programmer must know how long the operation will take. As an example, if the user is downloading a five MB file, by the time 2.5 MB have downloaded, the bar will have moved halfway across.
Create a Progress Bar
Start by creating a new project after opening Visual Basic. Click on 'File,' 'New Project' and select the 'Standard EXE' format. Add the ProgressBar control by clicking on 'Project,' 'Components.' Find the Microsoft Windows Common Controls in the list. Choose the Microsoft Visual Basic Common Controls (SP6) by placing a checkmark in the box next to the control. Click on 'Apply' and 'OK.' You should see the control in the list in the left panel. Double click on this to add it to the form.
Set the Properties
If working with an operation where the percentage of completion is easy to calculate like a file download, set the Minimum property in the Properties panel to '1' and the maximum to '100.' Another way to set the maximum is to have the code count the number of iterations of some operation, compare this to the total number, and calculate where the bar should be. Height and Left properties control the height of the bar itself and where it appears from the left of the screen. Only two other properties matter: Whether the bar runs across the screen vertically or horizontally and whether incremental chunks appear or the bar is smoother. Choose these from the 'Orientation' and 'Scrolling Properties.' If the maximum cannot be predetermined, it is possible to use an Animation control to keep the bar moving until the operation completes. This enhancement goes beyond the level of this tutorial. Since the bar should not appear until an operation commences, set the Visible property to 'False.' For this example, set the Maximum property to '10000' and leave the Minimum at '0.' Finally, add a Command Button control from the Tools list to the form to initiate action. Change the (Name) property to 'btnStart' and the Caption to 'Start.'
Write the Code
Click on 'View,' 'Code' to open the programming window. Type the lines below exactly as shown. The first three lines load the form and make the Progress Bar visible. The rest of the code runs through a repetitive sequence to demonstrate the bar. The end number in this code is set very high to slow the Progress Bar down for visibility. Replace the steps in the second section beginning with 'Private Sub btnStart_Click() and ending 'End Sub' with whatever event you are timing to get a new ProgressBar1.Value. Always add a command to change the visibility of the bar to 'False' when the routine finishes.Private Sub Form_Load()
ProgressBar1.Visible = True
End SubPrivate Sub btnStart_Click()
Dim n As Integer
For n = 1 To 10000
ProgressBar1.Value = n
Next n
End SubTest the code by pressing the 'F5' key.
Visual Basic 2008 Express Edition Version
In the Visual Basic 2008, substitute the following lines for the lines beginning Private Sub:Private Sub Form1_Load(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase.Load
Private Sub btnStart_Click(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles btnStart.Click
In Feburary 2016 26,
Wednesday, 24 February 2016
How to Change the FTP Password IISIn Feburary 2016 24,
In Feburary 2016 24,
Click 'Start' and type 'inetmgr' without quotes in the Search box.
Press 'Enter.'
Click 'FTP' and then click the 'User Accounts' tab at the bottom of the panel.
Click the '->' button next to the name of the user you would like to modify.
Type the new password twice under the 'Password' and 'Confirm Password' dialog boxes and click 'OK.' Your FTP password has now been changed.
In Feburary 2016 24,
Click 'Start' and type 'inetmgr' without quotes in the Search box.
Press 'Enter.'
Click 'FTP' and then click the 'User Accounts' tab at the bottom of the panel.
Click the '->' button next to the name of the user you would like to modify.
Type the new password twice under the 'Password' and 'Confirm Password' dialog boxes and click 'OK.' Your FTP password has now been changed.
In Feburary 2016 24,
How to Upload Files Using FileZillaIn Feburary 2016 24,
In Feburary 2016 24,
Download and install FileZilla.
Open FileZilla and click on the file drop-down menu. Click on 'Site Manager.' A new window should open.
Choose 'New Site.' A new icon will appear in the Select Entry pane.Type the name of your website in the text box provided.
Click the 'General' tab in the pane available on the right side of the Select Entry pane. Enter the host name in the format of 'ftp.your-domain-name.com.' Select your FTP Server Type. Select the type of login you have access to, which is generally normal.
Enter your username and password and click 'Connect.' This should close your Site Manager automatically, and the commands required to log in will appear in the top pane of the main window.
Access the directory that you wish to upload your files to. To do so, simply double-click the file's name in the folder portion of the Remote Site pane.
Navigate to the file that is to be uploaded using the Local Site pane.
Double-click on the file to begin uploading it to your website. Alternately, drag and drop the file from the left to the right window pane. The upload progress can be monitored at the window pane given at the bottom in Filezilla.
Disconnect from your website once the file has been uploaded by accessing the 'Server' menu and then 'Disconnect.'
In Feburary 2016 24,
Download and install FileZilla.
Open FileZilla and click on the file drop-down menu. Click on 'Site Manager.' A new window should open.
Choose 'New Site.' A new icon will appear in the Select Entry pane.Type the name of your website in the text box provided.
Click the 'General' tab in the pane available on the right side of the Select Entry pane. Enter the host name in the format of 'ftp.your-domain-name.com.' Select your FTP Server Type. Select the type of login you have access to, which is generally normal.
Enter your username and password and click 'Connect.' This should close your Site Manager automatically, and the commands required to log in will appear in the top pane of the main window.
Access the directory that you wish to upload your files to. To do so, simply double-click the file's name in the folder portion of the Remote Site pane.
Navigate to the file that is to be uploaded using the Local Site pane.
Double-click on the file to begin uploading it to your website. Alternately, drag and drop the file from the left to the right window pane. The upload progress can be monitored at the window pane given at the bottom in Filezilla.
Disconnect from your website once the file has been uploaded by accessing the 'Server' menu and then 'Disconnect.'
In Feburary 2016 24,
Tuesday, 23 February 2016
How to Host a Server on 'GMod' With HamachiIn Feburary 2016 23,
In Feburary 2016 23,
Download Hamachi to your desktop. Double-click the downloaded file to install it. Upon completion, the program automatically opens.
Click 'Power On,' and wait several minutes for first-time setup to complete.
Click 'Network,' followed by 'Create a new network.' A dialog box appears, asking you to select a network name and password. Fill in these fields, and press 'OK.'
Load 'Garry's Mod' to the main menu, and select 'Multiplayer.' Check the 'LAN' box as you set your desired options onscreen.
Press the grave/tilde key (` / ~) and type 'sv_lan 0' without the quotes. Press 'Enter.'
Have your friend open Hamachi and join your network. Have him click 'Network,' followed by 'Join an existing network' on the program. Using your network name and password, he joins your network.
Have your friend open 'Garry's Mod,' and select 'Join' under 'Multiplayer.' Give him your LAN IP address, found on the Hamachi program under the power button. Have him type this in the 'Server Address' box, and he can join your game.
In Feburary 2016 23,
Download Hamachi to your desktop. Double-click the downloaded file to install it. Upon completion, the program automatically opens.
Click 'Power On,' and wait several minutes for first-time setup to complete.
Click 'Network,' followed by 'Create a new network.' A dialog box appears, asking you to select a network name and password. Fill in these fields, and press 'OK.'
Load 'Garry's Mod' to the main menu, and select 'Multiplayer.' Check the 'LAN' box as you set your desired options onscreen.
Press the grave/tilde key (` / ~) and type 'sv_lan 0' without the quotes. Press 'Enter.'
Have your friend open Hamachi and join your network. Have him click 'Network,' followed by 'Join an existing network' on the program. Using your network name and password, he joins your network.
Have your friend open 'Garry's Mod,' and select 'Join' under 'Multiplayer.' Give him your LAN IP address, found on the Hamachi program under the power button. Have him type this in the 'Server Address' box, and he can join your game.
In Feburary 2016 23,
How to Read Event Viewer in VB.NETIn Feburary 2016 23,
In Feburary 2016 23,
Start Microsoft Visual Basic Express and click 'New Project...' on the left pane of your screen. Double-click 'Windows Forms Application' to start your new project.
Double-click 'Button' on the 'Tools' pane to create a new button. Double-click 'ListBox' on the 'Tools' pane to create a new list box control. Double-click 'Button1' to open the 'Form1.vb' module.
Press 'Ctrl+A' and press 'Delete' to delete all code.
Copy and paste the following code to your 'Form1.vb' module.Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.ClickDim eventLogApp As New System.Diagnostics.EventLog('Application')Dim eventLogEntry As System.Diagnostics.EventLogEntryDim eventCntr As Integer = 1For Each eventLogEntry In eventLogApp.EntriesMe.ListBox1.Items.Add('Event Number:' & eventCntr)Me.ListBox1.Items.Add(eventLogEntry.EntryType.ToString)Me.ListBox1.Items.Add(eventLogEntry.TimeGenerated.ToString)Me.ListBox1.Items.Add(eventLogEntry.Source.ToString)Me.ListBox1.Items.Add(eventLogEntry.Category.ToString)Me.ListBox1.Items.Add(eventLogEntry.EventID.ToString)Me.ListBox1.Items.Add(eventLogEntry.MachineName.ToString)Me.ListBox1.Items.Add(eventLogEntry.Message.ToString)Me.ListBox1.Items.Add('-----------------------------------------------')eventCntr = eventCntr + 1Me.ListBox1.Refresh()NextEnd Sub
End Class
Start your program by pressing 'F5' and then clicking 'Button1' to display event log entries through a list box.
In Feburary 2016 23,
Start Microsoft Visual Basic Express and click 'New Project...' on the left pane of your screen. Double-click 'Windows Forms Application' to start your new project.
Double-click 'Button' on the 'Tools' pane to create a new button. Double-click 'ListBox' on the 'Tools' pane to create a new list box control. Double-click 'Button1' to open the 'Form1.vb' module.
Press 'Ctrl+A' and press 'Delete' to delete all code.
Copy and paste the following code to your 'Form1.vb' module.Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.ClickDim eventLogApp As New System.Diagnostics.EventLog('Application')Dim eventLogEntry As System.Diagnostics.EventLogEntryDim eventCntr As Integer = 1For Each eventLogEntry In eventLogApp.EntriesMe.ListBox1.Items.Add('Event Number:' & eventCntr)Me.ListBox1.Items.Add(eventLogEntry.EntryType.ToString)Me.ListBox1.Items.Add(eventLogEntry.TimeGenerated.ToString)Me.ListBox1.Items.Add(eventLogEntry.Source.ToString)Me.ListBox1.Items.Add(eventLogEntry.Category.ToString)Me.ListBox1.Items.Add(eventLogEntry.EventID.ToString)Me.ListBox1.Items.Add(eventLogEntry.MachineName.ToString)Me.ListBox1.Items.Add(eventLogEntry.Message.ToString)Me.ListBox1.Items.Add('-----------------------------------------------')eventCntr = eventCntr + 1Me.ListBox1.Refresh()NextEnd Sub
End Class
Start your program by pressing 'F5' and then clicking 'Button1' to display event log entries through a list box.
In Feburary 2016 23,
Saturday, 20 February 2016
How to Access GoDaddy EmailIn Feburary 2016 20,
In Feburary 2016 20,
To check your GoDaddy email account from a desktop computer, use a standard Web browser. Type the desktop version of the Workspace Webmail URL (link in Resources) into the browser address bar, and then press 'Enter' to open the Web-based email tool. Type the email address for the account you want to access into the Username field, and then type the password associated with the account in the Password box. Click the 'Log In' icon to open your email account.
Mobile Browser Access
Use the browser on your mobile device to check your GoDaddy email. Launch the browser, and then type the mobile mail URL (see Resources). Tap 'Go' or press the 'Return' key to open the Workspace Webmail tool. Log in with your email address and password.
Mobile App
GoDaddy provides a free secure email app for Android and iOS devices. Download and install the GoDaddy mobile app from iTunes or Google Play. Launch the mail app on your mobile device, and then tap the 'Email Management' tab to open the email dashboard. Type the email address of the account you want to check in the “Email” field, and then type the password for the account in the Password box. Tap 'Go' or press the “Enter” keyboard key to access the specified account.
Configuring Your Email Client
To set up your email client for POP access to your GoDaddy email accounts, configure your email application with the incoming server settings of “pop.secureserver.net” and the port number of “110.” For IMAP incoming server settings, use “imap.secureserver.net” and the port number “143.” For the outgoing server settings, use “smtpout.secureserver.net” and the port number “80.“
GoDaddy Dashboard
You can also access Workspace Webmail by logging in to your GoDaddy account dashboard in a Web browser, and then clicking the “Email Management” tab. Click the “Webmail” option next to the email address for the account you want to access to open the account in the Webmail tool.
In Feburary 2016 20,
To check your GoDaddy email account from a desktop computer, use a standard Web browser. Type the desktop version of the Workspace Webmail URL (link in Resources) into the browser address bar, and then press 'Enter' to open the Web-based email tool. Type the email address for the account you want to access into the Username field, and then type the password associated with the account in the Password box. Click the 'Log In' icon to open your email account.
Mobile Browser Access
Use the browser on your mobile device to check your GoDaddy email. Launch the browser, and then type the mobile mail URL (see Resources). Tap 'Go' or press the 'Return' key to open the Workspace Webmail tool. Log in with your email address and password.
Mobile App
GoDaddy provides a free secure email app for Android and iOS devices. Download and install the GoDaddy mobile app from iTunes or Google Play. Launch the mail app on your mobile device, and then tap the 'Email Management' tab to open the email dashboard. Type the email address of the account you want to check in the “Email” field, and then type the password for the account in the Password box. Tap 'Go' or press the “Enter” keyboard key to access the specified account.
Configuring Your Email Client
To set up your email client for POP access to your GoDaddy email accounts, configure your email application with the incoming server settings of “pop.secureserver.net” and the port number of “110.” For IMAP incoming server settings, use “imap.secureserver.net” and the port number “143.” For the outgoing server settings, use “smtpout.secureserver.net” and the port number “80.“
GoDaddy Dashboard
You can also access Workspace Webmail by logging in to your GoDaddy account dashboard in a Web browser, and then clicking the “Email Management” tab. Click the “Webmail” option next to the email address for the account you want to access to open the account in the Webmail tool.
In Feburary 2016 20,
Friday, 19 February 2016
How to Use VBA to Import Data From Excel Into AccessIn Feburary 2016 19,
In Feburary 2016 19,
Launch Microsoft Office Excel and type 'data1' in A2, and 'data2' in B2. Press 'Ctrl' and 'S' to open the 'Save As' dialog Window and save the workbook in 'C:\Temp\' as 'dataToImport.xlsx.' Click 'Save' and close Excel.
Launch Microsoft Office Access, click 'Blank Database' and click the 'Create' button. Click 'Database Tools,' and click 'Visual Basic' to open the VB Editor Window. Click the 'Insert' menu and then click 'Module' to insert a new code module. Click the 'Tools' menu, click 'References,' and check the box next to 'Microsoft Excel
Object Library.'
Start by typing the following VBA code to create new sub procedure:Private Sub importExcelData()
Type the following to create variables you will use to read Excel: Dim xlApp As Excel.ApplicationDim xlBk As Excel.WorkbookDim xlSht As Excel.Worksheet
Type the following to create variables you will use in Access:Dim dbRst As RecordsetDim dbs As DatabaseDim SQLStr As String
Type the following to define database objects and also define the Excel workbook to use:Set dbs = CurrentDbSet xlApp = Excel.ApplicationSet xlBk = xlApp.Workbooks.Open('C:\Temp\dataToImport.xlsx')Set xlSht = xlBk.Sheets(1)
Create a new table with two columns in Access to import data from Excel. Type the following VBA code to create the table using the 'DoCmd' object:SQLStr = 'CREATE TABLE excelData(columnOne TEXT, columnTwo TEXT)'DoCmd.SetWarnings FalseDoCmd.RunSQL (SQLStr)
Open the table you just created by using a the Recordset object. Type the following to open the table and add a new row:Set dbRst = dbs.OpenRecordset('excelData')dbRst.AddNew
Type the following to get values from the Excel workbook, save them to your table and update the record:xlSht.Range('A2').SelectdbRst.Fields(0).Value = xlSht.Range('A2').ValuexlSht.Range('B2').SelectdbRst.Fields(1).Value = xlSht.Range('B2').ValuedbRst.Update
End your procedure by typing the following VBA code:dbRst.Closedbs.ClosexlBk.CloseEnd Sub
Press 'F5' to run the procedure. The data in your Excel workbook has just been imported into your Access table.
In Feburary 2016 19,
Launch Microsoft Office Excel and type 'data1' in A2, and 'data2' in B2. Press 'Ctrl' and 'S' to open the 'Save As' dialog Window and save the workbook in 'C:\Temp\' as 'dataToImport.xlsx.' Click 'Save' and close Excel.
Launch Microsoft Office Access, click 'Blank Database' and click the 'Create' button. Click 'Database Tools,' and click 'Visual Basic' to open the VB Editor Window. Click the 'Insert' menu and then click 'Module' to insert a new code module. Click the 'Tools' menu, click 'References,' and check the box next to 'Microsoft Excel
Object Library.'
Start by typing the following VBA code to create new sub procedure:Private Sub importExcelData()
Type the following to create variables you will use to read Excel: Dim xlApp As Excel.ApplicationDim xlBk As Excel.WorkbookDim xlSht As Excel.Worksheet
Type the following to create variables you will use in Access:Dim dbRst As RecordsetDim dbs As DatabaseDim SQLStr As String
Type the following to define database objects and also define the Excel workbook to use:Set dbs = CurrentDbSet xlApp = Excel.ApplicationSet xlBk = xlApp.Workbooks.Open('C:\Temp\dataToImport.xlsx')Set xlSht = xlBk.Sheets(1)
Create a new table with two columns in Access to import data from Excel. Type the following VBA code to create the table using the 'DoCmd' object:SQLStr = 'CREATE TABLE excelData(columnOne TEXT, columnTwo TEXT)'DoCmd.SetWarnings FalseDoCmd.RunSQL (SQLStr)
Open the table you just created by using a the Recordset object. Type the following to open the table and add a new row:Set dbRst = dbs.OpenRecordset('excelData')dbRst.AddNew
Type the following to get values from the Excel workbook, save them to your table and update the record:xlSht.Range('A2').SelectdbRst.Fields(0).Value = xlSht.Range('A2').ValuexlSht.Range('B2').SelectdbRst.Fields(1).Value = xlSht.Range('B2').ValuedbRst.Update
End your procedure by typing the following VBA code:dbRst.Closedbs.ClosexlBk.CloseEnd Sub
Press 'F5' to run the procedure. The data in your Excel workbook has just been imported into your Access table.
In Feburary 2016 19,
How to Use CyberduckIn Feburary 2016 19,
In Feburary 2016 19,
Open Cyberduck on your computer and click 'Open Connection.'
Enter your server name and URL in the space provided. Enter your username and password for the specific server below the server box. Click 'Connect.'
Right-click or 'Ctrl' and click for single button mouse users in the program window to create a new folder if none exist or you wish to create a new folder. Enter a name for it and click 'Create.' Double-click the folder file to view.
Drag files from your computer into a folder you created or have on Cyberduck or directly into the main window to upload. Right-click to select 'Delete' to delete a file or folder. You may also rename a file or folder the same way.
Click the 'Bookmarks' button to save your information so you do not need to reenter it every time in Cyberduck. Click the '+' under 'Bookmarks' to save Cyberduck FTP to your computer.
In Feburary 2016 19,
Open Cyberduck on your computer and click 'Open Connection.'
Enter your server name and URL in the space provided. Enter your username and password for the specific server below the server box. Click 'Connect.'
Right-click or 'Ctrl' and click for single button mouse users in the program window to create a new folder if none exist or you wish to create a new folder. Enter a name for it and click 'Create.' Double-click the folder file to view.
Drag files from your computer into a folder you created or have on Cyberduck or directly into the main window to upload. Right-click to select 'Delete' to delete a file or folder. You may also rename a file or folder the same way.
Click the 'Bookmarks' button to save your information so you do not need to reenter it every time in Cyberduck. Click the '+' under 'Bookmarks' to save Cyberduck FTP to your computer.
In Feburary 2016 19,
How to Access Mobile Sites on a PCIn Feburary 2016 19,
In Feburary 2016 19,
Navigate to the DotMobi site (see Resources). Select whether you want to simulate the Sony K750 or the NokiaN770 as your phone. Enter the mobile site address in the text box on the right and click 'Submit.' The site will appear inside the phone graphic; click the buttons on the phone to navigate.
Download and install the WML Browser for the Firefox Web browser (see Resources). Click 'View' from the Firefox menu, select 'Toolbars' and then 'Customize.' Click on the WML option to add it to your toolbar. Click 'WML ON' in the toolbar to toggle it for navigating to mobile sites.
Go to the TapTag website (see Resources). Enter the mobile address in the bottom-left corner of the site, under the 'Home' label. Click the 'Go' button and the box on the left will load just like it would for a mobile phone.
In Feburary 2016 19,
Navigate to the DotMobi site (see Resources). Select whether you want to simulate the Sony K750 or the NokiaN770 as your phone. Enter the mobile site address in the text box on the right and click 'Submit.' The site will appear inside the phone graphic; click the buttons on the phone to navigate.
Download and install the WML Browser for the Firefox Web browser (see Resources). Click 'View' from the Firefox menu, select 'Toolbars' and then 'Customize.' Click on the WML option to add it to your toolbar. Click 'WML ON' in the toolbar to toggle it for navigating to mobile sites.
Go to the TapTag website (see Resources). Enter the mobile address in the bottom-left corner of the site, under the 'Home' label. Click the 'Go' button and the box on the left will load just like it would for a mobile phone.
In Feburary 2016 19,
Wednesday, 17 February 2016
How to Configure a Router for FTPIn Feburary 2016 17,
In Feburary 2016 17,
Go to the configuration page for your router, which is often online and available via the router manufacturer's website.
Access the page for the router's port range forwarding. The link or tab for applications is usually the place to go.
Input 'FTP' in the first available box under the 'Application' column. In the row for this new application, put '21' underneath both 'Start' and 'End.'
Select 'TCP' in the drop-down box under 'Protocol' for the same row with your inputted FTP application. Under 'IP Adress,' input the address for the machine with your FTP server.
Create a second application row under the FTP row, inputting 'PSAV' in the Application box. Input the port range for your FTP server in the Start and End boxes. Input 'TCP' and the same IP address for the FTP server.
In Feburary 2016 17,
Go to the configuration page for your router, which is often online and available via the router manufacturer's website.
Access the page for the router's port range forwarding. The link or tab for applications is usually the place to go.
Input 'FTP' in the first available box under the 'Application' column. In the row for this new application, put '21' underneath both 'Start' and 'End.'
Select 'TCP' in the drop-down box under 'Protocol' for the same row with your inputted FTP application. Under 'IP Adress,' input the address for the machine with your FTP server.
Create a second application row under the FTP row, inputting 'PSAV' in the Application box. Input the port range for your FTP server in the Start and End boxes. Input 'TCP' and the same IP address for the FTP server.
In Feburary 2016 17,
How to Reinstall MySQL for UbuntuIn Feburary 2016 17,
In Feburary 2016 17,
Click the 'System' menu.
Highlight the 'Administration' category.
Click the 'Synaptic Package Manager' menu option to open the Synaptic Package Manager. Type your password when prompted.
Type 'mysql' in the 'Search' text box at the top of the screen.
Click the check box next to the 'mysql-server' package.
Choose the 'Mark for re-installation' option in the menu that appears.
Click 'Apply' at the top of the screen.
Click 'Yes' in the confirmation dialog that appears. The MySQL server package will be reinstalled.
Command Line
Right-click anywhere on the desktop.
Choose the 'Terminal' option in the menu that appears to open a terminal window.
Type the command 'sudo apt-get install --reinstall mysql-server' to reinstall the MySQL software package.
Type your password when prompted.
Type 'Y' when prompted for confirmation.
In Feburary 2016 17,
Click the 'System' menu.
Highlight the 'Administration' category.
Click the 'Synaptic Package Manager' menu option to open the Synaptic Package Manager. Type your password when prompted.
Type 'mysql' in the 'Search' text box at the top of the screen.
Click the check box next to the 'mysql-server' package.
Choose the 'Mark for re-installation' option in the menu that appears.
Click 'Apply' at the top of the screen.
Click 'Yes' in the confirmation dialog that appears. The MySQL server package will be reinstalled.
Command Line
Right-click anywhere on the desktop.
Choose the 'Terminal' option in the menu that appears to open a terminal window.
Type the command 'sudo apt-get install --reinstall mysql-server' to reinstall the MySQL software package.
Type your password when prompted.
Type 'Y' when prompted for confirmation.
In Feburary 2016 17,
How to FTP Via Command LineIn Feburary 2016 17,
In Feburary 2016 17,
Click on the 'Start' button. Type 'Run' in the 'Search programs and files' text dialog. Click on the 'Run' icon that displays in the search results.
Type 'cmd' in the 'Run' dialog box and click 'OK.'
Type 'ftp yourdomain.com' in the command line when the Windows Command Prompt opens. Replace 'yourdomain.com' with the name of your domain.
Press 'Enter' on your keyboard and type your FTP username and password when prompted. The username will appear as you type it, but the password will not.
In Feburary 2016 17,
Click on the 'Start' button. Type 'Run' in the 'Search programs and files' text dialog. Click on the 'Run' icon that displays in the search results.
Type 'cmd' in the 'Run' dialog box and click 'OK.'
Type 'ftp yourdomain.com' in the command line when the Windows Command Prompt opens. Replace 'yourdomain.com' with the name of your domain.
Press 'Enter' on your keyboard and type your FTP username and password when prompted. The username will appear as you type it, but the password will not.
In Feburary 2016 17,
How to Connect to Zymic With FilezillaIn Feburary 2016 17,
In Feburary 2016 17,
Launch FileZilla.
Enter your website address, such as 'websitename.zxq.net' in the 'Host' box at the top of the screen.
Enter your website subdomain and main domain, separated by an underscore, in the 'Username' box. For example, if your website address is 'websitename.zxq.net,' your username is 'websitename_zxq.'
Enter your password in the 'Password' box.
Enter '21' in the 'Port' box.
Click 'Quick Connect' to connect to your Zymic account.
Drag files from the left side of the screen into the right side to upload them to your Zymic account.
In Feburary 2016 17,
Launch FileZilla.
Enter your website address, such as 'websitename.zxq.net' in the 'Host' box at the top of the screen.
Enter your website subdomain and main domain, separated by an underscore, in the 'Username' box. For example, if your website address is 'websitename.zxq.net,' your username is 'websitename_zxq.'
Enter your password in the 'Password' box.
Enter '21' in the 'Port' box.
Click 'Quick Connect' to connect to your Zymic account.
Drag files from the left side of the screen into the right side to upload them to your Zymic account.
In Feburary 2016 17,
Subscribe to:
Posts (Atom)