In Feburary 2016 28,
Open your HTML editor. If you don't have one, launch the Notepad text editor, which you can find in the 'Accessories' folder of your Windows Start menu.
Open the Web page into which you want to insert the anchor tag by clicking on 'File' and selecting 'Open.'
Copy and paste, or type, the following code before the phone number you want to turn into a hyperlink:Replace '5551234567' with the phone number you want your visitors to dial when clicking on the link.
Type or copy and paste the following code after the phone number you want to turn into a hyperlink:As an example, the complete code for the fictional '5551234567' phone number would be:(555) 1234-567
Save the HTML file. Upload it to your Web server by using your Web host's file manager tool or an FTP client.
In Feburary 2016 28,
Showing posts with label Insert. Show all posts
Showing posts with label Insert. Show all posts
Sunday, 28 February 2016
Saturday, 27 February 2016
How to Create an Invitation to a Roast PartyIn Feburary 2016 27,
In Feburary 2016 27,
Open the software program on your computer that will allow you to create your roast invitation. Microsoft Word and Adobe Illustrator are two great programs that you can use to create your invitation. You can also create invitations for your roast on websites such as Evite and VistaPrint.
Select an invitation template from the software program that you are using. Once you have opened the template, insert graphics on your invitation. You can use graphics that are relevant to the roasting party theme such as comedian pictures, or you can use photos of the individual who is being roasted.
Enter text onto your roast invitation to let the invitees know the details of the event. You should include the date of the roast, time, location, theme, dress, etc. Specify whether or not everyone will be able to roast or if the roasting is only limited to a certain few. By letting the individuals know that they have a chance to roast someone, they can start preparing their lines and jokes ahead of time. Also include whether or not individuals attending are being asked to bring party items or dishes to the roast.
Insert the contact information on your roast invitation so that individuals can RSVP if they will be attending. This will help you to get an accurate headcount of those who will be attending your roasting party.
Send out your roast invitations via postal mail or email.
In Feburary 2016 27,
Open the software program on your computer that will allow you to create your roast invitation. Microsoft Word and Adobe Illustrator are two great programs that you can use to create your invitation. You can also create invitations for your roast on websites such as Evite and VistaPrint.
Select an invitation template from the software program that you are using. Once you have opened the template, insert graphics on your invitation. You can use graphics that are relevant to the roasting party theme such as comedian pictures, or you can use photos of the individual who is being roasted.
Enter text onto your roast invitation to let the invitees know the details of the event. You should include the date of the roast, time, location, theme, dress, etc. Specify whether or not everyone will be able to roast or if the roasting is only limited to a certain few. By letting the individuals know that they have a chance to roast someone, they can start preparing their lines and jokes ahead of time. Also include whether or not individuals attending are being asked to bring party items or dishes to the roast.
Insert the contact information on your roast invitation so that individuals can RSVP if they will be attending. This will help you to get an accurate headcount of those who will be attending your roasting party.
Send out your roast invitations via postal mail or email.
In Feburary 2016 27,
Sunday, 21 February 2016
How to Access the Internet Through a Router Hardwired to a Desktop ComputerIn Feburary 2016 21,
In Feburary 2016 21,
Check that your router is connected to your Internet modem using an Ethernet cable. This may be a cable, DSL or satellite Internet modem, depending on the type of Internet service you have.
Connect the router to your computer using an Ethernet cable. Most routers will have four ports to connect computers to. These ports are usually numbered, one through four, in a row in the back. Insert one end of the Ethernet cable into any of those four ports and the other end into the Ethernet port on your computer.
Turn on your modem, router and desktop computer, in that order. Windows will automatically configure your Internet connection.
Run an Internet browser, such as Internet Explorer, Firefox or Google Chrome. You will find a browser in your start menu under “All Programs”. Internet Explorer comes with all copies of Windows.
Type the address of any site into the address bar of the browser. You can now enjoy the Internet.
In Feburary 2016 21,
Check that your router is connected to your Internet modem using an Ethernet cable. This may be a cable, DSL or satellite Internet modem, depending on the type of Internet service you have.
Connect the router to your computer using an Ethernet cable. Most routers will have four ports to connect computers to. These ports are usually numbered, one through four, in a row in the back. Insert one end of the Ethernet cable into any of those four ports and the other end into the Ethernet port on your computer.
Turn on your modem, router and desktop computer, in that order. Windows will automatically configure your Internet connection.
Run an Internet browser, such as Internet Explorer, Firefox or Google Chrome. You will find a browser in your start menu under “All Programs”. Internet Explorer comes with all copies of Windows.
Type the address of any site into the address bar of the browser. You can now enjoy the Internet.
In Feburary 2016 21,
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,
Tuesday, 16 February 2016
How to Insert a Checkbox in Word 2004 for MacIn Feburary 2016 16,
In Feburary 2016 16,
Open Word 2004 and open the file that requires a check box.
Click your mouse cursor at the spot in your document where you want the check box to appear.
Click the 'Insert' option at the top of the computer screen. This opens a drop-down menu. Select 'Symbol.' The 'Symbol' window appears with a chart of possible symbols to choose from.
Select 'AppleGothic' in the 'Font' drop-down menu.
Scroll through the symbols until you arrive at 'AppleGothic character 166 (Unicode character 9634).' The symbol names appear under the chart of symbols as you scroll. This particular one is a check box. Click this symbol; a blue preview window will pop up.
Click the 'Insert' button at the bottom of the 'Symbol' window. You have now added a check box to your document.
In Feburary 2016 16,
Open Word 2004 and open the file that requires a check box.
Click your mouse cursor at the spot in your document where you want the check box to appear.
Click the 'Insert' option at the top of the computer screen. This opens a drop-down menu. Select 'Symbol.' The 'Symbol' window appears with a chart of possible symbols to choose from.
Select 'AppleGothic' in the 'Font' drop-down menu.
Scroll through the symbols until you arrive at 'AppleGothic character 166 (Unicode character 9634).' The symbol names appear under the chart of symbols as you scroll. This particular one is a check box. Click this symbol; a blue preview window will pop up.
Click the 'Insert' button at the bottom of the 'Symbol' window. You have now added a check box to your document.
In Feburary 2016 16,
Monday, 8 February 2016
How to Install PKG Files on a PS3In Feburary 2016 08,
In Feburary 2016 08,
Download the .pkg file you want to install onto the PS3 from one of the many PS3 developer Websites.
Insert a USB flash drive into the computer and copy the downloaded .pkg file directly to the USB flash drive.
Pull the USB flash drive out of the computer and turn on the PS3. Insert the USB flash drive into the PS3.
Select the 'Install Package Files' option from the PS3 main menu. Select the .pkg file that is on the USB flash drive from the menu that comes up. The .pkg file is installed.
Press the 'O' button on the PS3 gamepad to go back to the PS3 main menu when the installation completes. The installed program is now on the PS3 main menu.
In Feburary 2016 08,
Download the .pkg file you want to install onto the PS3 from one of the many PS3 developer Websites.
Insert a USB flash drive into the computer and copy the downloaded .pkg file directly to the USB flash drive.
Pull the USB flash drive out of the computer and turn on the PS3. Insert the USB flash drive into the PS3.
Select the 'Install Package Files' option from the PS3 main menu. Select the .pkg file that is on the USB flash drive from the menu that comes up. The .pkg file is installed.
Press the 'O' button on the PS3 gamepad to go back to the PS3 main menu when the installation completes. The installed program is now on the PS3 main menu.
In Feburary 2016 08,
Free Japanese StepIn Feburary 2016 08,
In Feburary 2016 08,
Cut a 2-foot piece of nylon beading thread. String three seed beads onto the nylon thread. Slide them down to the center of the thread.
String a seed bead onto the left end of the thread and slide it down half way on the thread. Insert the right end of the thread through the same seed bead and pull it through. Pick up both ends of the thread and pull them to make the beads move into a circle. Don't pull the ends all the way; leave the circle loose for now.
String a bead onto the left end of the thread. String a bead onto the right end of the thread. Slide the beads all the way down to the fourth strung bead or the bead at the top of the first beaded circle. Slide on a new bead onto the left end. Slide it halfway down, and then insert the right end through the right side of the bead. The bead should now have the left end hanging down from the right side and the right end hanging down from the left side. Pull the ends to make another loose circle.
Add six more circles by stringing a bead onto both ends, stringing the third bead with both ends of the thread to make a string of eight woven figure-8 circles with the beads.
Insert both the left and right ends of the thread through the bead that is facing the right and pull them through. String one bead onto each thread end, string on the third bead and insert both ends through the bead. Continue weaving the beads, using the top bead of the first row as a part of the circle as you make more circles with the beads and thread.
Close the last circle to make a ring with the woven beads. After you make the last figure 8, insert both ends of the thread through the very first bead on the strand of beaded circles. Pull the ends tight to make a ring with the beads.
Tie the ends together two times with a simple knot. Pass the left end through three adjacent beads. Pull the thread tight to make the knot slide into a bead to hide it. Trim the excess thread.
In Feburary 2016 08,
Cut a 2-foot piece of nylon beading thread. String three seed beads onto the nylon thread. Slide them down to the center of the thread.
String a seed bead onto the left end of the thread and slide it down half way on the thread. Insert the right end of the thread through the same seed bead and pull it through. Pick up both ends of the thread and pull them to make the beads move into a circle. Don't pull the ends all the way; leave the circle loose for now.
String a bead onto the left end of the thread. String a bead onto the right end of the thread. Slide the beads all the way down to the fourth strung bead or the bead at the top of the first beaded circle. Slide on a new bead onto the left end. Slide it halfway down, and then insert the right end through the right side of the bead. The bead should now have the left end hanging down from the right side and the right end hanging down from the left side. Pull the ends to make another loose circle.
Add six more circles by stringing a bead onto both ends, stringing the third bead with both ends of the thread to make a string of eight woven figure-8 circles with the beads.
Insert both the left and right ends of the thread through the bead that is facing the right and pull them through. String one bead onto each thread end, string on the third bead and insert both ends through the bead. Continue weaving the beads, using the top bead of the first row as a part of the circle as you make more circles with the beads and thread.
Close the last circle to make a ring with the woven beads. After you make the last figure 8, insert both ends of the thread through the very first bead on the strand of beaded circles. Pull the ends tight to make a ring with the beads.
Tie the ends together two times with a simple knot. Pass the left end through three adjacent beads. Pull the thread tight to make the knot slide into a bead to hide it. Trim the excess thread.
In Feburary 2016 08,
Friday, 5 February 2016
How to Use FTP From VBAIn Feburary 2016 05,
In Feburary 2016 05,
Open Microsoft Excel.
Click 'Tools,' 'Macro' and then 'Visual Basic.' This will open the VBA programming environment.
Click 'Tools' and 'Reference.' Scroll down and select the 'Microsoft Internet Transfer Control' and click 'OK.'
Click 'Insert' and 'Module.' You are now in a programming code module.Type or copy and paste the following in the code module:Function UploadFile(ByVal HostName As String, _
ByVal UserName As String, _ByVal Password As String, _ByVal LocalFileName As String, _ByVal RemoteFileName As String) As BooleanDim FTP As InetSet FTP = New InetWith FTP.Protocol = icFTP.RemoteHost = HostName.UserName = UserName.Password = Password.Execute .URL, 'Put ' + LocalFileName + ' ' + RemoteFileNameDo While .StillExecutingDoEventsLoopUploadFile = (.ResponseCode = 0)End WithSet FTP = Nothing
End Function
In Feburary 2016 05,
Open Microsoft Excel.
Click 'Tools,' 'Macro' and then 'Visual Basic.' This will open the VBA programming environment.
Click 'Tools' and 'Reference.' Scroll down and select the 'Microsoft Internet Transfer Control' and click 'OK.'
Click 'Insert' and 'Module.' You are now in a programming code module.Type or copy and paste the following in the code module:Function UploadFile(ByVal HostName As String, _
ByVal UserName As String, _ByVal Password As String, _ByVal LocalFileName As String, _ByVal RemoteFileName As String) As BooleanDim FTP As InetSet FTP = New InetWith FTP.Protocol = icFTP.RemoteHost = HostName.UserName = UserName.Password = Password.Execute .URL, 'Put ' + LocalFileName + ' ' + RemoteFileNameDo While .StillExecutingDoEventsLoopUploadFile = (.ResponseCode = 0)End WithSet FTP = Nothing
End Function
In Feburary 2016 05,
Subscribe to:
Comments (Atom)