S
setoFairfax
I have created a program in Excel to generate quarterly reports. The user
fills in a daily worksheet (a template) and adds the entry to a database
record. This worked fine a few days ago. However, I have been working on
the program in the past few days and now it does not work.
When I create an entry with the daily worksheet template and save, it should
ask me how to update the database. Instead, it now says 'The database
structure is different from the database structure support [sic] by the
template'. It will let me save and the update screen does come up after
that, but it will not create an entry in the database.
What do I need to do to get the template to output correctly to the database
again?
The only thing that I can think of that might have screwed things up was
that I manually entered data/formulas into the database to create a sample
data set to generate reports on for testing purposes. However, those have
been deleted and as far as I can tell the database is back in its original
condition.
I have tried to use the template wizard to re-enter the fields to be
outputted but it gives me the same error message and does not output.
I cannot recreate the database sheet. I have tried that, and all my
formulas generate the #REF! error since they reference the database sheet. I
have also tried deleting the original sheet and creating a new one with the
same name, but the #REF! error still appears.
I don't know what I can do to fix the link between the template and
database. If anyone can help me I would very much appreciate it!
-Thanks!
fills in a daily worksheet (a template) and adds the entry to a database
record. This worked fine a few days ago. However, I have been working on
the program in the past few days and now it does not work.
When I create an entry with the daily worksheet template and save, it should
ask me how to update the database. Instead, it now says 'The database
structure is different from the database structure support [sic] by the
template'. It will let me save and the update screen does come up after
that, but it will not create an entry in the database.
What do I need to do to get the template to output correctly to the database
again?
The only thing that I can think of that might have screwed things up was
that I manually entered data/formulas into the database to create a sample
data set to generate reports on for testing purposes. However, those have
been deleted and as far as I can tell the database is back in its original
condition.
I have tried to use the template wizard to re-enter the fields to be
outputted but it gives me the same error message and does not output.
I cannot recreate the database sheet. I have tried that, and all my
formulas generate the #REF! error since they reference the database sheet. I
have also tried deleting the original sheet and creating a new one with the
same name, but the #REF! error still appears.
I don't know what I can do to fix the link between the template and
database. If anyone can help me I would very much appreciate it!
-Thanks!