Forum Discussion

JohnnyO320's avatar
JohnnyO320
Copper Contributor
Jul 28, 2022

Access Query Update Question between two tables

Hello.   I am having a problem with updating from one table to another.   Maybe someone has seen this scenario somewhere.  Help is much appreciated.  Here it goes.  Table 1 is "Current" and is the ...
access
JohnnyO320's avatar
JohnnyO320
Copper Contributor
Jul 30, 2022

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.  

JohnnyO320's avatar
JohnnyO320
Copper Contributor
Jul 31, 2022
I did place fncUpdateOnHold() in the runcode Function Name instaed of DRN for the macro I am downloading. It's basically the same error.
  • arnel_gp's avatar
    arnel_gp
    Iron Contributor
    Jul 31, 2022
    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?
    • JohnnyO320's avatar
      JohnnyO320
      Copper Contributor
      Jul 31, 2022
      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!

Resources