S
StarfishJoe
One Form: Many tables
I have created a form to view a table in an Access97 Database. This
database contains only one table with many colums (more than 20) which makes
it hard to view in Datasheet view. By using a form(or I could have used a
report) and wrapping fields to a second, third and fourth line, I am able to
arrange the data for each record in a much easier to view fashion. Also the
default view is Continuous Form view.
The database table I am viewing is actually a log created every night. The
single table is stored in an ,MDB file that is moved out of the application
that created it to another drive on the company network. The mdb file is
renamed to identify the date such as "LOGFILE02-25-06.mdb" but the single
table is not renamed. These mdb files are stored in the same folder for one
year and then automatically purged.
I want to be able to use a single form in one Access database to link to and
view each one of these tables. I suppose I could just copy the form and
export/import it into each of these mdb files, but that would consume too
much space, to say nothing of it being a lot of trouble for me to go in and
add the form. Is there a way to open the form or a dialog box, select the
mdb file I want to view at that time, and populate my form? Then close that
table clearing the form, and select another mdb file to view? I know that
sometimes an incomplete form or query will pop up a Parameter window before
it opens up. I was wondering if I could use something like that and how do
I code it to allow me to select which database to link to?
Your help will be appreciated.
Starfishjoe
I have created a form to view a table in an Access97 Database. This
database contains only one table with many colums (more than 20) which makes
it hard to view in Datasheet view. By using a form(or I could have used a
report) and wrapping fields to a second, third and fourth line, I am able to
arrange the data for each record in a much easier to view fashion. Also the
default view is Continuous Form view.
The database table I am viewing is actually a log created every night. The
single table is stored in an ,MDB file that is moved out of the application
that created it to another drive on the company network. The mdb file is
renamed to identify the date such as "LOGFILE02-25-06.mdb" but the single
table is not renamed. These mdb files are stored in the same folder for one
year and then automatically purged.
I want to be able to use a single form in one Access database to link to and
view each one of these tables. I suppose I could just copy the form and
export/import it into each of these mdb files, but that would consume too
much space, to say nothing of it being a lot of trouble for me to go in and
add the form. Is there a way to open the form or a dialog box, select the
mdb file I want to view at that time, and populate my form? Then close that
table clearing the form, and select another mdb file to view? I know that
sometimes an incomplete form or query will pop up a Parameter window before
it opens up. I was wondering if I could use something like that and how do
I code it to allow me to select which database to link to?
Your help will be appreciated.
Starfishjoe