C
CDConnelly
Hello
I'm sure this is simple, but I have limited experience with Access and queries. I have a table of several thousand 3-character codes. The table has only one column containing those codes plus a primary key (ID). Here is what I am trying to do
Prompt user to enter a number of codes to selec
Retrieve specified number of codes and display the
Move retrieved codes from Column A (AVAIL) to Column B (USED
Save change
Re-display input box and prompt for input agai
Clicking 'X' to close macro/module (?
My research tells me this is probably a combination of modules, macros and/or queries, but I'm unable to come up with a workable solution so far. Any help would be greatly appreciated.
Thanks
CDConnelly
I'm sure this is simple, but I have limited experience with Access and queries. I have a table of several thousand 3-character codes. The table has only one column containing those codes plus a primary key (ID). Here is what I am trying to do
Prompt user to enter a number of codes to selec
Retrieve specified number of codes and display the
Move retrieved codes from Column A (AVAIL) to Column B (USED
Save change
Re-display input box and prompt for input agai
Clicking 'X' to close macro/module (?
My research tells me this is probably a combination of modules, macros and/or queries, but I'm unable to come up with a workable solution so far. Any help would be greatly appreciated.
Thanks
CDConnelly