| Thread | Last Post | Replies |
|
| Access report transmittal question | 01 Jun 2005 00:53 GMT | 1 |
I created an access report that gets run via a control button on a form. The report list teacher information (extracurricular activities) and contains checkboxes depending upon what activity they signed up for. Using behind the scenes code I am transmitting the report to the ...
|
| Access Application | 01 Jun 2005 00:22 GMT | 3 |
I have a start up form that when a user clicks a button it runs several queries that clear table, append data, create tables and then launch a report. Everything works fine on me desktop. I send the database to someone else and he receives several message box
|
| Chart RowSource problem in Report | 31 May 2005 23:38 GMT | 1 |
Has anyone run into a problem with using the RowSource property for a chart in a report. The line of code is: Me.Usage_Chart1.RowSource = "Some SQL Select Statement" I keep getting the following error:
|
| Setting value of a text box on a report from VBA code | 31 May 2005 22:53 GMT | 3 |
Good Morning, I have created a coversheet and would like to add a date field. I have an input box to enter the day to be displayed, but I'm having trouble setting the text box value to the date supplied.
|
| zip code in label | 31 May 2005 21:44 GMT | 2 |
In my label query the zipcode looks like 00969-7659 In the labelreport it shows 009697659 How can I show the - sign in the report? I tried Format([zip],"00000""-9999""")) but this not works Any idea how to do? Hermie
|
| Sending multiple reports by email | 31 May 2005 20:00 GMT | 5 |
I know you can use the SendObject method to send a single item via email (I'll be using the Snapshot format) but I really want to send more than one attachment. Is there a way to do this? Is it possible to 'fool' Access into thinking there's only one attachment when there are a ...
|
| Changing Report Caption | 31 May 2005 18:41 GMT | 1 |
I am having problems with changing the caption of a report in code. The return error message is "Type Mismatch". Below is a sample of my code: DoCmd.OpenReport "SL_Rebate_Statement_List_Combined", acViewDesign Reports!SL_Rebate_Statement_List_Combined.Caption = strReportName & " " ...
|
| I can set a 0" margin in Word, but not in Access - why? | 31 May 2005 13:50 GMT | 2 |
I'm trying to print address labels but the minimum bottom margin for this printer is 0.46". However in word, when i use the wizard it sets a 0" margin at the bottom - same printer. I can't fit all the labels on my report. The access label wizard won't work either, for the ...
|
| Report columns spanning multiple pages | 31 May 2005 13:01 GMT | 1 |
I currently have a report with a fixed number of columns. I programmatically fill in the values of the header and detail controls and then hide any unused fields so that the proper number of columns are displayed on the report. My problem now is that I need to change the report ...
|
| Monthly Calendar Report | 31 May 2005 05:14 GMT | 3 |
Can a monthly calendar Report be created in Access (2000 or 2003) that prints corresponding date fields. For example: I have and event management database; It contains fields for Event Names & corresponding Event Dates. I would like to print a report in the format of a monthly ...
|
| Duane Hookom's calendarDisplay db | 31 May 2005 05:07 GMT | 8 |
This post is related to the Calendar display database designed by Duane Hookum. First thank you very much Duane. The database is for doctors patients appointments. You
|
| timeline | 31 May 2005 05:05 GMT | 1 |
I know there are a few threads that deal with this, but none are specific enough for me. I need to create a timeline divided into three categories: pre-proposal, proposal, and post-proposal so that each project has a rectangle divided into these three parts in a Gant chart-like ...
|
| Details size when subreport included | 30 May 2005 23:53 GMT | 2 |
i have a subreport feeding the Details section of a report. the number of records the subreport returns varies. This has the unfortunate habit of pulling the footer up so that the contents lie just below the subreport (the fewer records returned, the higher up the page are the ...
|
| Stop a subreport from printing | 30 May 2005 19:28 GMT | 1 |
I have a report with a subreport. Before displaying this report from my application, I allow the user to select what they would like to display on the report. Printing of the subreport is optional. I'm using the following code:
|
| Count if PaymentAgreed=Yes AND Paid=No | 30 May 2005 17:16 GMT | 1 |
an example: Payment Agreed Paid Yes Yes Yes No
|