Union query to combine datas in 2 tables.

[pedie]

Hi, I need help with procedure to create union query to combine datas in 2 tables.
I'm not doing any projects as such just learning it...
I have googled and found that union query can do it.
So please help.

Thanks

 

[boblarson]

If you link the table from db2 into db1, then db1 can update the data in db2 but the db2 can't update anything in db1.

 

[pedie]

Okay great! will there be a problem because this db1 [the forntend is being used by multiple users...] and cant even create a picture in my mind how it might work...no experience in access...

Can you also please show the code way to open the database and update it in a click?

Thanks
Pedie

 

[boblarson]

It shouldn't be a problem as long as everyone has their own copy of the frontend (which is how it should always be) and it isn't being shared from a central location.

Do you know how to create an append query? You would just create that to append the new record to the db2 table and then just call it with either:

CurrentDb.Execute "QueryNameHere", dbFailOnError

or

DoCmd.OpenQuery "QueryNameHere"

Although the CurrentDb.Execute would probably be better because it doesn't generate the confirmations that the other does. To do the OpenQuery method you would likely want to put DoCmd.SetWarnings False there before the open and set it back to true afterwards. Make sure if you don't have a single exit point that you would put the set warnings true part in the error handler as well.

 

[pedie]

Thanks again Bob! Enjoy Weekends!

 

[boblarson]

Thanks again Bob! Enjoy Weekends!

Thanks, you too.