Forum Discussion
Access Query Update Question between two tables
you will need vba (imo) to accomplish that.
see the two tables in this demo first.
next see and run the function in Module1 to update [FILERENTRYNBR] of [All Holds] table.
Thanks very much. Sorry for the late response. Yes, your Module 1 does what it supposed to do in my access database when I run the module all by itself. The module assigns each similar SHPMT ID's its unique FILERENTRYNBR what I wanted. I renamed it to DRN in my access database. There is one question though. I am having a problem running the code in macro once I am downloading data into all holds table. Maybe you have a suggestion.
Here is the photo of my macro download form named "go to download form 1"
The macro closes one form and then opens another once the data is transferred. But I get an error trying to do it. Don't know why. Here are the photos.
Not sure what is going on. All the data is transferred into All Holds table before running the DRN Code. Then the final two updates go into play which are Update Pest ID and Update Quarantine Status. Thanks.
- I did place fncUpdateOnHold() in the runcode Function Name instaed of DRN for the macro I am downloading. It's basically the same error.
- if you are willing to upload your db, i will look into it.
is it possible to rename all your macro, without space in them, and much shorter name?- Hello. I figure it out. I had to move the CloseWindow download form 2 function all the way down on the list right before CLoseWindow download form 1 and it worked like a charm. Don't know why. Maybe because I am using "download form 2" as a window of what I am about to download which is data from the "Current" table. This really helps. Now to test it out on larger scale and everyday use. You don't know how grateful I am. Thank you!