tags:

views:

76

answers:

1
Q: 

MS Access-VBA _ Save a Report to Hard Drive

Hi all, need some help with this code if anyone can answer. Any suggestions are most appreciated.

I have a report that I want to save to my hard drive when clicking a button. When saving the report I want the filename to be created using two pieces of information from the report.

Variables:

  Report = "Contract"
  Save Location = "C:\Folder\"
  File Name = [Customer] &  " _ "  & [Date]
  File Type = PDF

Thank you!

A: 

You could save a macro and read the code in there.

eKek0  2010-05-22 00:03:51

related questions

Dlookup problem null value
Proper Use of a Class Instance
Query regarding dsn string in vba
Query problem
Insert statement with where clause
Problem of input mask in VBA text box ?
How to use a Query in another DB as a Form's RecordSource?
How to be productive in Access VBA + SQL development?
ms-access vba Eval function behavior
How do I change a column's Format to Percent using a SQL in VBA?
DCount vs. SQL SELECT COUNT(*)?
Show code from from thru code (in ms access)
Access VBA save Report as PDF/Binary
Is there a way to execute VBA code when specific tables and fields in a Microsoft Access database are updated?
SQL for parsing multi-line data?
How to use VBA to automate several Office applications?
Queries in ms-access:formatting a field in the middle of an sql UPDATE code.
Access - Data Provider Not Initialised?
Getting Value from MS Access form from Excel VBA.
Inspect Call Stack in VBA
How can I change the view of an MS Access subform at runtime in VBA code?
Version control for VBA file
Openform action was canceled in MS-Access VBA code
Parsing a web form in to a data table
Why does createProcessingInstruction in VBA generate incomplete output?