Login or Sign Up
- Logging in...
  
  Remember me
  
  Or
  
  Sign Up
  
  Forgot password or user name?
- Log in with

Search in titles only Search in posts by Fred Chamberlin only

Advanced Search

Forums
Product Launch
Updates

Today's Posts
Member List
Calendar

Home
Fred Chamberlin

User Profile

Collapse

Profile Sidebar

Collapse

Fred Chamberlin

Last Activity: Mar 8 '12, 09:36 PM

Joined: Aug 26 '11

Location:

Subscriptions3
Subscribers0

Activities
About
Media
Subscribed

Time

All Time Today Last Week Last Month
Show

All Discussions only Photos only Videos only Links only Polls only Events only
Source

All Fred Chamberlin only Visitor Messages Only Advanced

Filtered by:

new posts

Fred Chamberlin started a topic OutputTo: Report to Excel gives "The format in which you are attempting..." error.

in Access

Mar 8 '12, 09:36 PM
OutputTo: Report to Excel gives "The format in which you are attempting..." error.
OS: Windows XP SP3
Office 2007 Enterprise with SP2 (12.0.6557.5000 1) SP2 MSO(12.0.6544.5 001)

When using DoCmd.OutputTo and attempting to output a report to Excel, I get the following error:

The format to which you are attempting to output the current object is not available.

Code:

DoCmd.OutputTo acOutputReport, strSource, acFormatXLSX, , False

where strSource is the name of the report.
...
See more | Go to post
Fred Chamberlin replied to OutputTo: Output the contents of a form or a report without the footer

in Access

Mar 8 '12, 08:25 PM
Thank you! Setting the display property on the report footer to Screen Only accomplishes what I want.

See more | Go to post
Leave a comment:
Fred Chamberlin replied to OutputTo: Output the contents of a form or a report without the footer

in Access

Mar 8 '12, 04:24 PM
The footer of the report has buttons to Print, Export and Close. I want to keep them, but I do not want them to Export (or Print) if possible.

See more | Go to post

Last edited by NeoPa; Mar 8 '12, 04:38 PM.
Leave a comment:
Fred Chamberlin started a topic OutputTo: Output the contents of a form or a report without the footer

in Access

Mar 8 '12, 02:37 PM
OutputTo: Output the contents of a form or a report without the footer

I have set up for users to output various forms and reports to either Excel or to PDF format. In both cases, I would like the footer to not be included in the output. The footer area includes the button to output the form or report. Any suggestions?

See more | Go to post
Fred Chamberlin replied to Have a query prompt for input on different fields based on which button selected on

in Access

Aug 29 '11, 04:25 PM
It works great. Thanks for your help.

See more | Go to post
Leave a comment:
Fred Chamberlin started a topic Have a query prompt for input on different fields based on which button selected on

in Access

Aug 26 '11, 01:09 PM
Have a query prompt for input on different fields based on which button selected on
Using Access 2007, I have a form with 3 buttons. The OnClick event sets a global variable and each of them opens another form whose record source is the following query.

Code:

SELECT <several fields here> FROM ([tblEmployee Information] INNER JOIN [tblEmployee Training] ON [tblEmployee Information].ID=[tblEmployee Training].ID) INNER JOIN qryLawsonQueryByArea ON [tblEmployee Information].ID=qryLawsonQueryByArea.ID

...
See more | Go to post

Last edited by NeoPa; Aug 28 '11, 06:06 PM. Reason: You must use CODE tags when posting code

No activity results to display

Show More

Bytes
Help
Contact Us
Privacy
Terms of Service
Go to top

All times are GMT. This page was generated at 1 minute ago.

Working...

👍

👎

☕