G
G. Vaught
This may not be the best method so any other ideas are welcome.
I have created a series of queries that alone executed in order work as
written.
What I am trying to do is execute the set of queries via a command button.
All queries work except where I need to temporily stop the delete query from
executing until the user has finshed updating two records that open in two
different temp tables. At the present my two tables open, but so does the
query to delete the records from the master table, which prevents the user
from entering the changes needed to the temp tables.
To make a long story short. The users of the database need a way to swap
personnel against a computer/software inventory database without having to
manual update or delete a personnel record first. For example I am in room
616 and will be moving to 659. There is specific inventory tags assigned to
me and specific tags assigned to 659. The computer/software is moving with
me to 659. In order to reassign me to 659 the data in 659 needs to deleted
and my info entered as duplication of room numbers is prevented.
What I am doing manually is getting the record info from the first room
number 616 and appending to a temp table. Then getting the second room
number and appending to another temp table. I then want to open each temp
table to allow the user to change the room number 616 to 659 and vice versa
659 to 616. This is where I am having the 'brain fart' of getting the code
to halt until the user has entered the appropriate values and then delete
the original records out of the table and append the new data from the
changed temp tables.
Any help will be appreciated. I have ventured through Google to no avail and
two Access books I have.
I have created a series of queries that alone executed in order work as
written.
What I am trying to do is execute the set of queries via a command button.
All queries work except where I need to temporily stop the delete query from
executing until the user has finshed updating two records that open in two
different temp tables. At the present my two tables open, but so does the
query to delete the records from the master table, which prevents the user
from entering the changes needed to the temp tables.
To make a long story short. The users of the database need a way to swap
personnel against a computer/software inventory database without having to
manual update or delete a personnel record first. For example I am in room
616 and will be moving to 659. There is specific inventory tags assigned to
me and specific tags assigned to 659. The computer/software is moving with
me to 659. In order to reassign me to 659 the data in 659 needs to deleted
and my info entered as duplication of room numbers is prevented.
What I am doing manually is getting the record info from the first room
number 616 and appending to a temp table. Then getting the second room
number and appending to another temp table. I then want to open each temp
table to allow the user to change the room number 616 to 659 and vice versa
659 to 616. This is where I am having the 'brain fart' of getting the code
to halt until the user has entered the appropriate values and then delete
the original records out of the table and append the new data from the
changed temp tables.
Any help will be appreciated. I have ventured through Google to no avail and
two Access books I have.
happy to help