S
Sprinks
I would like to do the following import process via VBA, attached to a
command button on a form:
- Establish a connection to another Access database (the source).
- Check that a "PeriodStartDate" in a table in the source file matchess the
same field in the corresponding table in the target file (the latter will be
open when a command button is pressed). If it does not match, display a
warning and abort.
- Check if any Projects in a table in the source file do not exist in the
corresponding target table. If they do not exist, append them to the target
table..
- Post any non-zero value records in a source file table to the target table.
- Change the Status of all imported records in the source file from 1 to 2.
Can anyone point me in the right direction?
Thank you.
Sprinks
command button on a form:
- Establish a connection to another Access database (the source).
- Check that a "PeriodStartDate" in a table in the source file matchess the
same field in the corresponding table in the target file (the latter will be
open when a command button is pressed). If it does not match, display a
warning and abort.
- Check if any Projects in a table in the source file do not exist in the
corresponding target table. If they do not exist, append them to the target
table..
- Post any non-zero value records in a source file table to the target table.
- Change the Status of all imported records in the source file from 1 to 2.
Can anyone point me in the right direction?
Thank you.
Sprinks