G
Guest
Hi there,
I've long been struggling to build a contact management portion into our
current contact and facility database and have finally resorted to trying to
use the Access2003 template provided by office. I can open and view this once
downloaded and all works fine. I then copy the tables,forms,macros,modules,
etc into my current database and the problems begin. I believe this may have
something to do with the current database being 2000 format despite being
built on 2003.
Anyway the problem that occurs first is one of the forms in the template is
called 'Reports'. Now i have no idea how they managed this as as soon as i
try to copy with the same name it tells me that name is reserved. Solved that
problem by changing the name to 'Reports_Form'....no problems there. Next
problem is the macro 'View Reports Macro'. This allows the choice of a report
to preview from a list box containing the report options. I updated this
macro to reflect the change of name of the form above and thats fine. The
problem occurs however when it runs as i get the error message "Microsoft
Access can't find the form 'View Reports' referred to in a macro expression
or visual basic code".
Now i'm positive there form is there and exists and have double checked the
name is still the same (why an office template is using such poor naming
conventions is beyond me). Below is a copy of the Macro coding and i'm hoping
someone can pick up whats wrong. Headings in {} for visual purposes:
View Reports Macros
{Macro Name:} cmdOpenReport : On Click
{Action:} Open Report
{Report Name:} =[Forms]![View Reports]![lstReports]
{View} Print Preview
{Window Mode} Normal
{Macro Name:} lstReports : On Dbl Click
{Action:} Open Report
{Report Name:} =[Forms]![View Reports]![lstReports]
{View} Print Preview
{Window Mode} Normal
{Macro Name:} EditReportList : On Click
{Action:} Open Form
{Form Name:} Reports_Form
{View} Datasheet
{Window Mode} Normal
Any ideas on this problem greatly appreciated.
Cheers,
Frusgtrated Access User
I've long been struggling to build a contact management portion into our
current contact and facility database and have finally resorted to trying to
use the Access2003 template provided by office. I can open and view this once
downloaded and all works fine. I then copy the tables,forms,macros,modules,
etc into my current database and the problems begin. I believe this may have
something to do with the current database being 2000 format despite being
built on 2003.
Anyway the problem that occurs first is one of the forms in the template is
called 'Reports'. Now i have no idea how they managed this as as soon as i
try to copy with the same name it tells me that name is reserved. Solved that
problem by changing the name to 'Reports_Form'....no problems there. Next
problem is the macro 'View Reports Macro'. This allows the choice of a report
to preview from a list box containing the report options. I updated this
macro to reflect the change of name of the form above and thats fine. The
problem occurs however when it runs as i get the error message "Microsoft
Access can't find the form 'View Reports' referred to in a macro expression
or visual basic code".
Now i'm positive there form is there and exists and have double checked the
name is still the same (why an office template is using such poor naming
conventions is beyond me). Below is a copy of the Macro coding and i'm hoping
someone can pick up whats wrong. Headings in {} for visual purposes:
View Reports Macros
{Macro Name:} cmdOpenReport : On Click
{Action:} Open Report
{Report Name:} =[Forms]![View Reports]![lstReports]
{View} Print Preview
{Window Mode} Normal
{Macro Name:} lstReports : On Dbl Click
{Action:} Open Report
{Report Name:} =[Forms]![View Reports]![lstReports]
{View} Print Preview
{Window Mode} Normal
{Macro Name:} EditReportList : On Click
{Action:} Open Form
{Form Name:} Reports_Form
{View} Datasheet
{Window Mode} Normal
Any ideas on this problem greatly appreciated.
Cheers,
Frusgtrated Access User