R
r. howell
I want to figure out how to make a form that will have a button on it, and a
text box. When the button is clicked, I want to have the field represented
by the information in that field added to every record in a specified table
(with, I think, a Cartesian query). Then I want the resulting new records to
be added to another table.
At this point, I am thinking that I need to access this formB from another
formA, in switchbox fashion, and run a create temporary table SQL statement
when I open this form, which would be based on that temporary table. Then
the button clicked on this formB would be one that could run first the
Cartesian query and then an append query.
Is this generally a sensible approach? Can someone help me with the Create
Temporary Table syntax? My data will be a number (long integer) but this
does not seem to be the right way to refer to that in SQL.
I am hoping that one of the bulging brains who run this place will have
written an article about this, but I have not been successful in figuring out
what to search for.
The general gist of what I am trying to accomplish is this:
I have a Master table which contains a list of all the necessary tasks to be
accomplished on a project. When a new project is begun, I want to be able to
create a new record for each of those tasks (which will then have start
dates, completion dates, employees assigned etc.) associated with the new
project number.
Thanks.
text box. When the button is clicked, I want to have the field represented
by the information in that field added to every record in a specified table
(with, I think, a Cartesian query). Then I want the resulting new records to
be added to another table.
At this point, I am thinking that I need to access this formB from another
formA, in switchbox fashion, and run a create temporary table SQL statement
when I open this form, which would be based on that temporary table. Then
the button clicked on this formB would be one that could run first the
Cartesian query and then an append query.
Is this generally a sensible approach? Can someone help me with the Create
Temporary Table syntax? My data will be a number (long integer) but this
does not seem to be the right way to refer to that in SQL.
I am hoping that one of the bulging brains who run this place will have
written an article about this, but I have not been successful in figuring out
what to search for.
The general gist of what I am trying to accomplish is this:
I have a Master table which contains a list of all the necessary tasks to be
accomplished on a project. When a new project is begun, I want to be able to
create a new record for each of those tasks (which will then have start
dates, completion dates, employees assigned etc.) associated with the new
project number.
Thanks.