Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ptuck
  • Order by date
  1. ptuck

    Read text file

    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...
  2. ptuck

    Open form in datasheet view

    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).
  3. ptuck

    Open form in datasheet view

    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.
  4. ptuck

    How to keep focus in control after message???

    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.
  5. ptuck

    Change order of existing items

    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...
  6. ptuck

    Change order of existing items

    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...
  7. ptuck

    Change order of existing items

    Access 2002...about to try the new updates
  8. ptuck

    Change order of existing items

    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...
  9. ptuck

    Change order of existing items

    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...
  10. ptuck

    Change order of existing items

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

    Change order of existing items

    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?
  12. ptuck

    Change order of existing items

    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...
  13. ptuck

    Change order of existing items

    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...
  14. ptuck

    Change order of existing items

    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...
  15. ptuck

    Change order of existing items

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

    Change order of existing items

    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...
  17. ptuck

    Change order of existing items

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

    Change order of existing items

    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...
  19. ptuck

    Change order of existing items

    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...
  20. ptuck

    Change order of existing items

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

Part and Inventory Search

Back
Top