B
Brandon P
I am trying to create the queries needed to accomplish appending multiple
records to a table. I am using a form to receive user input.
The purpose of my process is for the user to enter multiple employee
"tickler" records into the system at one time. The form accepts values for
the following:
tickler_owner (combo box)
tickler_code (combo box)
begin_date (text box)
end_date (text box)
added_by (text box = CurrentUser() )
It also allows the user to select all employees or only employees belonging
to specific divisions.
I have a query that idenifies the ID numbers of the people the ticklers will
be for based on the user identifying all or specific divisions. I am not able
to take that query data and the data in the form (listed above) and bring
them together and append them to the Tickler Table.
I've tried to use a make table query to put the listed items in a table and
then join the ID numbers query and the temporary table, but the date fields
do not translate correctly (I suspect having to do with the fields in the
make table being automatically set to binary). I do not know how else to get
the data together. Any help in a successful direction would be greatly
appreciated.
TIA,
:Brandon:
records to a table. I am using a form to receive user input.
The purpose of my process is for the user to enter multiple employee
"tickler" records into the system at one time. The form accepts values for
the following:
tickler_owner (combo box)
tickler_code (combo box)
begin_date (text box)
end_date (text box)
added_by (text box = CurrentUser() )
It also allows the user to select all employees or only employees belonging
to specific divisions.
I have a query that idenifies the ID numbers of the people the ticklers will
be for based on the user identifying all or specific divisions. I am not able
to take that query data and the data in the form (listed above) and bring
them together and append them to the Tickler Table.
I've tried to use a make table query to put the listed items in a table and
then join the ID numbers query and the temporary table, but the date fields
do not translate correctly (I suspect having to do with the fields in the
make table being automatically set to binary). I do not know how else to get
the data together. Any help in a successful direction would be greatly
appreciated.
TIA,
:Brandon: