Adding a button to a form

[accessdumb]

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.

 

[SpentGeezer]

Are you still in design view? Click View \ Form View if you are. Also does the report exist yet?

 

[missinglinq]

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

 

[accessdumb]

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.

 

[accessdumb]

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.

 

[missinglinq]

Glad you got it working!

Good luck with your project!

Linq ;0)>

 

[accessdumb]

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.

 

[DCrake]

In short, Yes, But it is not a task for the feinthearted. Do a s search on sending block emails.

 

[AccessMc]

If you have a server, the mass mail task would be much much easier and quicker with PHP and Mysql.