| Thread | Last Post | Replies |
|
| Consistant appearance | 16 Dec 2004 00:45 GMT | 2 |
How do I make a default report and form that when I open my database and go to the report (new) it pulls up a skelton of how I want my report or form to look?
|
| Possible to turn off grouping programatically | 15 Dec 2004 23:54 GMT | 4 |
I am using Access for reporting from SQL Server and would like to know if it is possible to programmatically turn off grouping in Access. The report is generated from a stored procedure and can generate 2 different recordsets. The first report (by 0,1,2) is a good deal of ...
|
| duplicate date entry for report w/ sub reports | 15 Dec 2004 22:05 GMT | 3 |
I have a report that has two subreports. The queries that the reports are based on have the criteria "Enter Date". All the reports work fine by themselves, but on the combined report the Enter Date pop-up reappears 7 times before the report finally opens. Any idea where I am ...
|
| multiple record sources | 15 Dec 2004 21:13 GMT | 1 |
I want to create a report that pulls from 3 different queries. It really doesn't work to pull the queries together to make 1 big query because the data isn't related that way. Do you know how to indicate that you want more than one record source? I tried to follow the help, ...
|
| printing report | 15 Dec 2004 20:01 GMT | 1 |
When I am in design mode, I have created a bar (rectangle with blue fill) that shows in the print preview, but will not print. If I don't use a fill with the rectangle, it will print, but only the border of the rectangle, I need it to be filled.
|
| Finding out what was entered into Stored Procedure form | 15 Dec 2004 19:42 GMT | 1 |
I have a report, which runs off a SQL Server stored procedure. When I run this report, it automatically prompts me to enter the variable (that is defined in the SP). How can I find out what was entered here? It seems like it is automatically taken care of.
|
| IIF range statement | 15 Dec 2004 19:41 GMT | 3 |
I have a field in the detail section of my report called [TotalErrors] In this section I've created multiple IIF statements to help determine the range of Total Errors. For example
|
| Multiple records on one page? | 15 Dec 2004 19:19 GMT | 2 |
How do I setup my query or report so that I dont' wind up with one record on each page? If I'm getting three records, I want to see them one after the other....
|
| Toggling Off the Page Header on First Page | 15 Dec 2004 19:03 GMT | 2 |
I'd like to toggle the page header off on the first page of my report using the Visible property of the section in the Print event procedure. Looking through the VBA functions, I didn't find one that returns the page number. Is there a function or system variable that can give ...
|
| I want to select report sort critria from a from | 15 Dec 2004 18:14 GMT | 2 |
I inherited a project from someone who actually knew what they were doing (unlike myself). While I've been a programmer for a long time, I have generally avoided using Office products, having a preference for 'real' programming languages. Anyway, I have a form containing a list ...
|
| Printing reports | 15 Dec 2004 17:32 GMT | 1 |
I am attempting to print a report. The information that is on that report comes from a from. Unless I go to the next record before I print the report the report will not reflect the information I entered on the form. I have tried to save the record before I print it but it will ...
|
| words 45? | 15 Dec 2004 17:28 GMT | 1 |
Just wondering, is there a way to make access print text on 45? inclination just like you can in excel? Thanks JP
|
| Help needed with Access 2000 Reports | 15 Dec 2004 16:33 GMT | 1 |
I am working w/ an existing database. In this database there are about 300 employees. I created a report to print envelopes based on fields of their personal infomration. However, the report (envelope) prints for all employees, not just the one I am currently on. Is there a way I ...
|
| How do I email a chart? | 15 Dec 2004 16:27 GMT | 1 |
When I email a chart, the tablulated data shows up instead. I realize there must be a feature that freezes the chart, but I am unable to locate it. Can you help? Please advise.
|
| Help with Report - On Open Event Procedure | 15 Dec 2004 16:27 GMT | 1 |
I want to display a message box if there are no records in a report when it is opened. I am not really sure how to code this, here is the code I am using but it doesn't work. Private Sub Report_Open(Cancel As Integer)
|