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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 123rose

  1. 123rose

    Hi Gary, thanks for the code which works perfect.

    Hi Gary, In the code "INSERT INTO tblNew SELECT tblOld.* FROM tblOld WHERE some criteria.", if I just want to append whatever record has been selected into tblNew, how should I write the "Where..." statement. My whole logic is: I have 2 buttons, one is Search, another is...
  2. 123rose

    Database coversion from Access 97 to 2002

    Access experts, I have a database compiled in Access Version 97. When I converted into Access Version 2002, how can I change the code for such as "DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70". I appreciate it very much. Rose
  3. 123rose

    Thank you very much BSENDBUCKEYE!!!

    Hi Gary, Thank you very much for the code you gave me. It worked perfect. I have just one more question, must I have a primary key field to do that? What should I do if I do not have a primary key in the table. Thank you very much and have a great day. Rose
  4. 123rose

    Would you please let me know what I did wrong?

    Hi Gary, Thank you very much for the code you gave me. It worked perfect. I have just one more question, must I have a primary key field to do that? What should I do if I do not have a primary key in the table. Thank you very much and have a great day. Rose
  5. 123rose

    Would you please let me know what I did wrong?

    Hi Gary, Thank you very much for the quick response. Would you please have a look at the attached file and let me know why it still did not work after inserting the code you give me. In the SQL, I just want to select and delete the record, how can compile the where clause? I very appreciate...
  6. 123rose

    How to delete a record in one form and add it to another form.

    Hi Access Experts, In MS Access, I have 2 forms with identical fields. One form is for record storage, the other is for trash can. Anything deleted from the first one should go to the other one. How can I compile the code in the on click event precedure if I design a botton for delete records...
  7. 123rose

    How to delete a record in one form and add it to another from.

    Hi Access Experts, In MS Access, I have 2 forms with identical fields. One form is for record storage, the other is for trash can. Anything deleted from the first one should go to the other one. How can I compile the code in the on click event precedure if I design a botton for delete records...
See more

Part and Inventory Search

Back
Top