Search results for query: *

How about if I wanted to select from column C to column BC but only the rows with data in them as the number of rows changes daily? Jeff

How about if I wanted to select from column 6 to column BC but only the rows with data in them as the number of rows changes daily? Jeff

Excellent, thanks for that, works like a charm. Jeff Enjoy the weekend.

I am pasting data from a web page using a macro, after the data is pasted how can I set the print area to only include the pasted information. The information is still active but am having problems getting the macro to only use the active cells for the print area. Thanks Jeff

I have a table with 1800 records I would like to append all of the Null values to be a ZERO rather than null. How would I write the query to update all the fields?? Thanks Jeff

I am experiencing the same issue, It did delete the log files once and then never again. If you have come up with a solution, any help would be appreciated. Jeff

Thanks for all that they worked flawlessly appreciate all the help. Jeff

Thanks, Yes that was my fault as I had not changed the properties of the boxes. Now it is working correctly adding up the values but how do I put that value (R5) into my table with all of the other values?

All that appears to do is take the values on display them in the R5 field R1 = 1 R2 = 2 R3 = 0 R4 = 1 R5 = 1201 In the control field of R5 I have =[R1]+[R2]+[R3]+[R4] Jeff

I have 4 fields R1, R2, R3, and R4 with a value of 0,1,or 2. Is there a way to have access automatically total these 4 fields in a field R5? Thanks in advance Jeff

Thank You Very Much worked Perfectly. Jeff

OK that sounds reasonable but how would I go about doing that. I am very new to Access. I know how to check the properties and see where it says ON CLICK but after that I am kind of Lost. Jeff

I have a form with a checkbox, The box has a label of Documentation Waiver. If the box is checked is there a way to grey out the rest of the form?? If the checkbox is left alone the form appears normal? Thanks in Advance Jeff

I guess I want a forward no answer, then I need to go from x1111 if no answer x2222 x2222 in no answer x1111 voice mail.

I have been asked to set up a hunt group??? Being quite new to meridian I have no idea how to set this up. I need if no one answers xxxx afetr 5 ring it goes to yyyy and if no one answers there it goes back to xxxx's voice mail. Any help would be appreciated. Thanks in advance Jeff

Do you have any shares set up can you attach to \\PCNAME\c$ Jeff

If you set the BIOS of the machine to boot from the CD-ROM and reboot with the win2k full version in the cd-rom it will say press any key to boot from cd .. press any key and then reinstall win2k. Jeff A+, MCP, CCA, CCNA

Hello, I figured it out it is [UserData] FullName=&quot;Full Name&quot; OrgName=&quot;Org Name&quot; ProductID=xxxxx-xxxxx-xxxxx-xxxxx-xxxxx <-- No Quote marks For future reference Thanks Jeff

Hello, Does anyone know the format to use when creating an unattended.txt file I have tried under [UserData] FullName=&quot;Full Name&quot; OrgName=&quot;Org Name&quot; ProductID=&quot;xxxxx-OEM-xxxxxxx-xxxxx&quot; and I have also tried [UserData] FullName=&quot;Full Name&quot...

I am probably in the wrong forum but I hope someone can help. I have no programing experience but I want to create a script or program that can create a dial up networking connection to our remote access server rather than going to everyones laptop i want to create a program to distribute...