I recently made the switch from Access 2003 to Access 2007. The rest of our office is still operating on 2003, so the database is still a 2003 file. We're having trouble with a few forms that work fine when I open them on the 2003 computers, but not on mine (2007 version).
For example. I have a form that is a simple form linked to a solicitation table. It has a combo box that allows the user to select the solicitation they want to look at. After that selection is made, the other fields on the form are populated, and a linked subform that was empty on opening is now refreshed and populated with the names of all the people who got the solicitation. This works great in 2003. In the 2007 version, I can't open the form without getting prompts for the query fields in the subform that are supposed to retrieve data from the table fields on the main form. Any thoughts?
The other trouble is with a form that allows the user to enter two dates, to retrieve all payments that were made between a certain time period. The user enters the dates, and then clicks a control to run a make-table query that provides names and mailing information to generate thank you letters. Works great in 2003. In the 2007 version, I get an error message that says "the database engine could not find the object '1'" I don't even have an object named '1'. Any suggestions?
Are there a lot of bugs like this that others are encountering?
For example. I have a form that is a simple form linked to a solicitation table. It has a combo box that allows the user to select the solicitation they want to look at. After that selection is made, the other fields on the form are populated, and a linked subform that was empty on opening is now refreshed and populated with the names of all the people who got the solicitation. This works great in 2003. In the 2007 version, I can't open the form without getting prompts for the query fields in the subform that are supposed to retrieve data from the table fields on the main form. Any thoughts?
The other trouble is with a form that allows the user to enter two dates, to retrieve all payments that were made between a certain time period. The user enters the dates, and then clicks a control to run a make-table query that provides names and mailing information to generate thank you letters. Works great in 2003. In the 2007 version, I get an error message that says "the database engine could not find the object '1'" I don't even have an object named '1'. Any suggestions?
Are there a lot of bugs like this that others are encountering?
Comment