Adding a button to a form

accessdumb

New member
Local time
Yesterday, 22:06
Joined
Mar 13, 2011
Messages
4
I am trying to add a button to a form that will bring up a print preview for a report. I used the wisard to put a button on the form but when I go to use the button it does nothing. Is there a better way to do this?
Thanks for any help.
 
Are you still in design view? Click View \ Form View if you are. Also does the report exist yet?
 
What version of Access are you using? Code does not run in 2007/2010 unless your database resides in a folder that has been declared a “trusted” location.

To trust your folder, click:
  1. Office Button (top left)
  2. Access Options (bottom of dialog)
  3. Trust Center (left)
  4. Trust Center Settings (button)
  5. Trusted Locations (left)
  6. Add new location (button)
Here's a visual for it, courtesy of BTAB Development:

http://www.btabdevelopment.com/ts/default.aspx?PageId=13
 
Are you still in design view? Click View \ Form View if you are. Also does the report exist yet?
I am in form view when I try the button. I do have the report made. I also tried it with a search button, also with the same results.
 
What version of Access are you using? Code does not run in 2007/2010 unless your database resides in a folder that has been declared a “trusted” location.



To trust your folder, click:
  1. Office Button (top left)
  2. Access Options (bottom of dialog)
  3. Trust Center (left)
  4. Trust Center Settings (button)
  5. Trusted Locations (left)
  6. Add new location (button)
Here's a visual for it, courtesy of BTAB Development:

That worked. Thank you very much missinglinq, and thank you BTAB. I am now on my way. I had no one else to turn to. The club was trying to run a 700 membership database with Excell that wasn't working as you could imagine. I am learning Access to help them out. Thanks.
 
Glad you got it working!

Good luck with your project!

Linq ;0)>
 
OK guys I got my project going thanks to you and it works perfect according to the people using it. We now have over 700 E-mail addresses to send our monthly newsletter out to. Is there a way or a program to send this out to everyone on the database in a mass E-mail that is a bcc mode? The newsletter is in a word doc. translated to PDF. I am using Office 2007 in Windows 7.
 
In short, Yes, But it is not a task for the feinthearted. Do a s search on sending block emails.
 
If you have a server, the mass mail task would be much much easier and quicker with PHP and Mysql.
 

Users who are viewing this thread

Back
Top Bottom