Access Command Buttons

D

Dawn

I created a database that has a form with a subform; on the form, there is a
command button that opens a report to view the information for only that
specific record. The report itself contains three subreports, and if printed
independently of the form would print all of the records. However, when
printed from the command button from the form, there is code written in it to
show only the information for that record. So far so good.... the problem is
this - I created the database on a semi-public drive; when I copied it over
to my "C" drive, everything worked except the command button. When you click
on it, nothing happens. However, you can copy the database back over to the
other drive and it works fine. Additionally, I tried copying it to another
folder on the same drive (different permissions on that folder) and the same
thing happened). I am confused. The database is fully "self-contained" - it
is not linked to anything.

Please help me!
 
A

Allen Browne

What version of Access is this?

If it's Access 2007, you need to tell it that you trust the folder where the
databases resides, or no code runs. To trust your folder, click:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)
 
D

Dawn

Allen,
Thank you for your help. Shortly after I posted this thread, I figured it
out!

Regards,
Dawn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top