| Thread | Last Post | Replies |
|
| Use report to print on 3x5 index cards | 17 Jan 2005 01:37 GMT | 1 |
Could someone tell me how to set the page size on an Access report to be 3" tall by 5" wide? I have a database of vocab terms, and have been using Word to perform a mailmerge, however, my symbols (ex: γ, δ, ε, ζ, η) appear as question marks after the merge. I've decided to ...
|
| Functions....multiple reports | 17 Jan 2005 01:10 GMT | 2 |
my database has 4 reports that I need to calculate the age of a person. I now use: Public Function Age() If Month([DeathDate]) < Month([Birthdate]) Or _
|
| julian day | 16 Jan 2005 23:58 GMT | 7 |
I would like to have the current julian day on my report. Is it possible to do this? I've looked in built in functions under date/time but did not find julian day. Is it listed under a different catagory? Thanks in advance.
|
| Using Public Variables in Visual Basic for MS Access | 16 Jan 2005 22:28 GMT | 1 |
I just reciently installed MS Office 2003 and attempted to prepare a report using MS Access with a Public Variable declared in Visual Basic for MS Access. When I attempt to run the report the declared variable in VB returns a #NAME? instead of the value. I run the same procedure ...
|
| What to do with network printers | 16 Jan 2005 17:21 GMT | 1 |
I recently wrote a little Access project that involves printing two forms at the click of a button. I took it to work and put it on a coworkers computer and when trying to print the reports, even to open the reports in design view, I get a message that Access can't retrieve ...
|
| How to put a sum at the end of data? | 16 Jan 2005 14:48 GMT | 2 |
Hi, I want to know, at the end of listed data, I need a sum to show total, The data shoould be: No. Data 1 3
|
| Use of KB article 296249 | 16 Jan 2005 03:08 GMT | 2 |
By suggestion from Marsh, I used KB article # 296249 (http://support.microsoft.com/default.aspx?scid=kb;en-us;296249) to print out summary data at the foot of every page on a report. This worked out perfectly on a two-page report, but when the report is only one page long, ...
|
| Saving the value returned from an expression | 15 Jan 2005 11:37 GMT | 1 |
I'm working in a report based of off 4 queries. Basically what I have to do is count the number of entries in each query and create totals so my basic design looks like this. Type Number"
|
| Problem with rename value in report | 15 Jan 2005 11:34 GMT | 1 |
Having insoluble problem for me, exaple: Have to make report which needing to show total count of marks by month. That's known, but have to instead of mark (1,2,3,4,5) (which I have in field), put words (A,B,C,D,E). One month that can be like this: Mark Total
|
| Report to pdf format | 15 Jan 2005 09:04 GMT | 4 |
I'm working on a project that requires a paginated report to be supplied to Clients in an electronic format. Additionally parts of the report are in landscape and one section is in A3. I use Win2pdf at present to manually create pdf files, and although the vb
|
| How to Concantinate Strings and Fields in Report Text Box | 15 Jan 2005 01:10 GMT | 2 |
This one must be simple but it drives me crazy. One of the fields in a query populating a report is named "Log Number" I want to show the following, for example, in a text box in the report page header band -
|
| Not printing field if not there | 15 Jan 2005 01:00 GMT | 2 |
On printing an Access2003 doc: I am printing the customers address for mailing. If they have a address2 (more then just a street name...address1 in this case would be a suite name, etc) I want to print it, if not, I don't BUT I don't want the blank line there. How would one do ...
|
| parameratized report | 14 Jan 2005 21:41 GMT | 6 |
How do I parameratize a report so that it can be opened from command buttons on various forms? I think the code is something like: DoCmd.OpenReport "rptMyReport", acPreview Report!rptMyReport!<what_goes_here1> = Me.CallerName
|
| Report Prints w/o OnActivate Event Code | 14 Jan 2005 21:02 GMT | 1 |
I have several textboxes (On a report) who's visible property I set to False with code behind the OnActivate Event... When I print this report via the DoCmd.OpenReport method, all of the textboxes are visible (<--- not desired). When I open the report in Preview the textboxes are ...
|
| Top 5 Summary in Reports | 14 Jan 2005 20:41 GMT | 1 |
Hey, I'm revealing my own stupidity here, but I'm confused right now. I know how to bring up the MAX value of something in a report. But I wanted to make a short summary list of the top 5 values in a specific catagory. For instance... I have a Fishing Tourney DB... 100 boats, each ...
|