P
Pete
I am trying to use a database created with Access 2003 in Access 2007 but
have come up with a problem.
The database contains a report which produces invoices for sales between two
dates. When the report is run the user is asked to input sale date From and
To (this is set up in the Invoice Query), Invoice Date and Invoice Start
Number - these two are set up as text boxes on the report. Invoice Date
conrol source has [Enter Invoice Date] and Invoice Start Number has
[Page]+[Invoice Start Number]-1. This works fine in Access 2003 and the
invoices come out correctly but in 2007 invoice date comes up as Error and
Invoice Number comes up as 00:00:00 on each invoice.
I am not sure how to correct this and would appreciate your help.
Pete
have come up with a problem.
The database contains a report which produces invoices for sales between two
dates. When the report is run the user is asked to input sale date From and
To (this is set up in the Invoice Query), Invoice Date and Invoice Start
Number - these two are set up as text boxes on the report. Invoice Date
conrol source has [Enter Invoice Date] and Invoice Start Number has
[Page]+[Invoice Start Number]-1. This works fine in Access 2003 and the
invoices come out correctly but in 2007 invoice date comes up as Error and
Invoice Number comes up as 00:00:00 on each invoice.
I am not sure how to correct this and would appreciate your help.
Pete