Recent content by AccessProgrammer

Hope u cracked this ....

Dylan, thanks a lot, Buddy !!! I'll try this .... :-)

Hi, just add the folder where you store the database into trusted sites. Also, make sure you tick mark on the option to add all the subfolders also. In the same menu, you can also enable all macros to run without any pop ups. It may read that it is not safe. But just override it. All the best !!!

Thanks Dylan ! I forgot to ask for the below clarification ... In case if it is a combination ... eg: A Table has Emp Name, Designation, Location. When I have to append another table in same format ... append should not upload a combination of Designation and Location which is same. i.e if...

For Eg: If Table X has part numbers 1A1, 1A2, 1A4, 1A5 Table Y has part numbers 1A1, 1A2, 1A3, 1A4, 1A6, 1A7 After I append, the part numbers should be 1A1,1A2,1A3,1A4,1A5,1A6,1A7 Please help me with a way out.

I have a clarification to be sorted out. I have a database where-in there exists a table (Table x) with following fields: Part Number Description On hand Qty Now, I have to append a new table (Table y) to old table (Table x) in the same format. But, I have to append only the part numbers which...