Search results for query: *

I have a text file (computername.txt) that has 50 computer names. I want to read each computer name from the text file one at a time and perform an action on each machine. The computer names were originally in an excel spreadsheet and I just copies and pasted them to notepad. Not sure if I...

that worked perfect. I am not familiar with this command. I had tried them all, but this one. What does DS stand for (please don't tell me datasheet).

Why will my form not open in datasheet view when I use the openform command? The default view of the form is datasheet, but it always opens in single form. Please help.

PHV...wanted to say thanks for this reminder.. making the transition to C# and my brain has been fuzzy. This is the correct way to keep the cursor on the right field... Thanks again.

It does work...I had commented out this part of the code becuase I did not have the function before and it was causing an error. However, it pops up a write conflict message (options are: "save record" "copy to clipboard" or "drop changes"). This is not a problem because it will allow the user...

KenReay, Your example worked perfect and I have given you a star...Thanks for all your help. TheAceMan1, Your code is working great as well. I am goint to add some error handling to it and all shoule be perfect. I am still afraid the autokeys is not working. I am not sure how to test the...

Access 2002...about to try the new updates

I can't thank you guys enough. TheAceMan1, (how do you post in the nifty little text box??)you asked/stated this about the program locking up when error occurs in the move routine... "This is indicating you got it working. Hve you tried the right HoKeys: Ctrl + Shift + E?" I did get the macro...

It did not take the three stars. I have ran into a little problem. What if we need to delete a step? I tried this, but it did not renumber. Also, if there is ever an error it locks up access and the autokeys macro does not unfreeze it. You have done enough, but if you have some suggestion I...

Fogot to mention..I gave you three well deserved stars...

You are absolutely my hero.... This worked like a champ.. I still would like to convert it to ADO, but I may be able to do this. Do you have a suggestion about the sorting problem?

I did have the function in a module by itself. However, the problem was that when I copied the name of the function to use as the name of the module, I forgot to delete the HG off. The module and function had the same name, which will not work. Thanks for your help and I will wait to see the...

The macro still does not work. I have enter everything you have above for the macro with one exception. I was not sure what you meant by this below. Macro Name ---------- ^+e I have the RunCode set to the correct Function and the Maro named AutoKeys. It is telling me now that it...

I am getting the following error message. user-defined type not defined and it is highlighting rst AS DAO.Recordset Don't understand this, but I would prefer to use ADO if possible. I changed the recordset to ADO and then I get other error messages. Any thoughts?? Also, the autohotkeys macro...

You are the best...I am about to give it a shot now. Will let you know how it works.

Thanks AceMan...I will give this a shot tomorrow morning, but I will probably have a few questions. One that jumps out at me, is the user will still need to manually change the StepID (which is the exact number of the step 1,2,3). However, they can use hot keys to place them in the correct...

One more note...the main table is the main form and the steps table is the subform. Thanks again for the help.

TaskNo is the field that holds the 1.xxx. This is a unique number for each classification. In other words, TaskNo will never be duplicated for the Programmer classification. However, the same TaskNo could be used for the Technician classification. That is why it takes the TaskNo and...

The primary key for the sub form is as follows: All three fields make up the primary key TaskNo - text/string (this is a hidden field) StepID - number Classification - text/string (this is a hidden field) 1.xxx and 10.xxx... the x's are numbers and there are a few occassions where there are...

That sounds great...I will be on the look out for more information from you... Thanks for all your help...