Search results

Form B is not bound to any table or dataset

FormA would be a system form which would be defined at setup by the user, but could be altered later. It would be closed at the time that the user accesses FormB. FormB would be a form with buttons, each of which would open another form C, D, E, etc. for data entry on audits 1,2, ....15...

I'll consider any options..... Thanks

I want to create a form with y/n selectors to define which audits I currently wish to run on a set-up form. Then on a second application form, I want to display or hide buttons based on whether the initial audit was checked or not. I am assuming I would need to define a macro on open form to...

what happens if you substitute: acCurrentViewPreview or acCurrentView again, just guessing - not much with code

I'm not much for code, but if you put a button on the form where you select to print the report, you can define the report as a print preview. When you run this you can page through all the pages of the report using the page buttons located on the bottom left of the screen. I've never had a...

I've never tried this, but here is a suggestion. You might want to define a macro to run at the completion of report 1 to run report 2, then another at the end of 2 to run report 3, etc. You would define a macro to open/run report 2, then link that macro in the Event Properties, "on close" for...

Another option is to right-click on the section header. Go to Properties and "force new page". Select before section or after section depending on where you want the break.:)

If you do a sort and define the Manager's name field, the report will add a header for the sort into which you can add the Manager's name field. Then just add the other fields into the details section. When you run the report you should get what you want.. :)

First build a query with all the data fields from the two tables into the one query. Then build a report from the query defining the sort criteria you wish to sort by. In the details you can define a field for the event and number of attendes, and then sum the field in the sort field footer...

One thing that can help is to squeeze the report down as much as possible. I have found that some printers will have a default margin set at 1 inch on each side and others only 0.5 inches. Not exactly sure of your formating concerns, but if it is something of a word wrap issue, take a look at...

I've always heard this was an issue and told not to ever use page x of y for the reason you stated. In order to calculate Y, the report has to build the entire report then go back and add in this calculation to each page BEFORE it can actually print the report. If you only use page X the...

When you build a report, right click on the upper left-hand corner box and select properties. On the data tab, you will see the control source. That source needs to be the name of the query from which you are pulling the data fields. Having said that, all the fields that you need to pull...

Create two separate groups and put a sum for the corresponding field within the specific group. Then create a sum field and put in the report footer.

I have an Access 2007 report that has a Chart in the page header and the data displayed in the details field. Both are pulling from the same query. When I run the report, a Between statement asks for a date range as expected. However, after the date range is entered, the data displays...