| Thread | Last Post | Replies |
|
| How get global variable into report textbox ? | 31 Jan 2008 22:56 GMT | 1 |
I've been trying to do this for 2 hours and am completely stuck. I can display the variable with Msgbox but as soon as I try to set the text box to the variable, I get an error (can't assign to this object)? It also failed when I try to do it via the 'controlsource' Why is this ...
|
| Export to Word loosing bmp | 31 Jan 2008 21:36 GMT | 1 |
On a report I bring in a Bitmap picture for a doctors signature. The report and signature work fine but when I export to word the signature is lost. On the report format the Picture = .....DOCNAME.bpm and the Picture type = Embedded.
|
| Subtracting Months | 31 Jan 2008 21:36 GMT | 2 |
I have a report with column headings that are dates. These are displayed in mm-yy format. The first column is todays date =date(). The next 11 columns need to display the previous 11 months. I had set it up as the second column being =date()-30 and the next column =date()-60, ...
|
| unhide a report | 31 Jan 2008 20:44 GMT | 3 |
I was entering descriptions into the properties of reports and I must have accidentally checked the "hidden" box in "attributes." The report is still in the database, it just does not show up on the list in the report objects. How can I unhide it?
|
| What does the search key not found in any record mean? | 31 Jan 2008 19:37 GMT | 3 |
We are using Microsoft Access 2003 and I inserted a new entry and it would not allow me to save the new information. Everytime I try to delete this particular entry it comes up with an error (Search key not found in any record) Maybe if someone understands my problem and can ...
|
| force display of detail rows | 31 Jan 2008 19:04 GMT | 3 |
I need to force the display of detail rows in a report even if values for these rows are not in the data provided by the query. For example the query data may be as follows: Group Detail Qty
|
| address labels to eliminate a city | 31 Jan 2008 18:02 GMT | 3 |
I am printing address labels from an alumni database. I have the filter set as follows: (((Contacts.[Home Street Address]) Is Not Null)) This will only give me alumni that have addresses (if their home street
|
| Report parameters with Start/End Dates using Date() | 31 Jan 2008 17:57 GMT | 3 |
A recent thread demonstrated how to query a group of Reports with the user having to simply enter the Start and End date. My question is whether a relative date grouping for Starting and Ending can be defined using, for example, the expression Between Date() and
|
| My DSum is killing me! HELP!!!! | 31 Jan 2008 17:56 GMT | 2 |
I have a linked table (dbo_tbl_IVTRequests) with a starting time that is formatted as long date/time (FTStart) and an end time (FTEnd). On my report page, I have a starting range time (txtStartDate) and end range time (txtEndDate). I am trying to use a Dsum function to ...
|
| ACC2000: bloat after saving report via code | 31 Jan 2008 17:30 GMT | 1 |
So I have a routine that makes a PDF for each customer in a loop. It opens a report in design view, changes the recordset to process only 1 customer, save the report, and makes a PDF from the changed report. I use this code inside the loop:
|
| Report header/page header question | 31 Jan 2008 17:21 GMT | 1 |
I need to include the report title at the top of every page. On the first page only I need to include some additional heading information under the title. How do I do this? It seems no combination of report header and page header can achieve it.
|
| How suppress sum of detail in footer when only one detail line | 31 Jan 2008 17:21 GMT | 2 |
I have a detail section and a footer section that prints the sum of the detail lines. I'd like to suppress the footer when there is only one detail line. How?
|
| adding different columns in a cross tab report | 31 Jan 2008 17:11 GMT | 3 |
Good evening and any help will be greatly appreciated!! I have a cross tab report in which I need to add columns 1, 2, and 3 together and then 4 and 5 together in separate calculated fields to create a percentage (which works).
|
| No min, max close buttons | 31 Jan 2008 16:45 GMT | 1 |
I created are report in A2007 w/SP1, but when I open it from code in preview mode, there is no min, max. or close button. It I open the report in Dialog mode or ReportView mode, there is a close button. If I open the report directly from the Navigation pane it is fine, with min,
|
| Selecting Image(s) to print in a Group Footer | 31 Jan 2008 14:24 GMT | 2 |
I am trying to do the following, but am running into limitations with my approach. Has anybody done this before? 1. I am printing a letter, and depending on certain check boxes being selected, I will be printing between 0 and 3 forms to go along with the
|