Search results for query: *

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

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

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

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

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

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

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