Reports

Concatenate Unbound
Well I tryed to Concatenate inside of a quiry, but the problem still is there. What am I doing wrong. I am new so please understand. I have a report with 8 different textbox's (unbound) inwhich it checks for information and places an X in the textbox(s). I first put all in the name header, but would only re... 22 Sep 2005 16:57

Output report as PDF
I wish to output a report as a PDF file. I have Acrobat and CutePDF installed, but want to store the report as a PDF file with whatever name I choose to give it without any operator intervention. There must be a simple way to achieve this, any ideas? Thanks Malc ... 6 Sep 2005 12:02

Calculating negative and positive numbers
I am trying to do calculations in a field that has both positive and negative numbers. I need to calculate the positive numbers. Can someone help? -- rugiem ... 29 Aug 2005 12:19

#Error
I'm re-designing my reports to be a little more clean. I'm using the trick Duane Hookom suggested: convert labels to text boxes and use the control source to make them visible or invisible depending if they have a value or not. So far it's working as expected, however, I came upon a glitch. I have "-" and "+" t... 22 Aug 2005 14:15

Choose printer+parameters programatically
Hi all, Is there a way to choose the destination printer + parameters programatically when we want to print a report? If so, can those parameters be in such a detail as to allow choosing the paper size and margins (left, right, top, bottom), for example? Let me explain the need of such a solution (and the p... 29 Jun 2005 05:22

Avery Labels
I have only just started using Access 2003 and can't get the Avery DL30 (or 5160) OR the Avery L7158 up on the drop down list of available labels. Have custom created the L7158 but have printer margin problems and only end up with two columns of labels, not 3. These labels are VERY common mailing address labe... 24 Feb 2005 13:23

OpenArgs Error
Hello All, I'm using Access 2003 and I'm getting a "Run-time error 13 : Type mismatch" message from running the following code: Private Sub Regional_AfterUpdate() Dim Agent_Name as String Agent_Name = "John Doe" DoCmd.OpenReport "Clients", acViewPreview, , , Agent_Name End Sub Access is saying ... 22 Mar 2005 09:24

Run report wizard from code
I am trying to launch the Reports Wizard from code. The only info I can find to do this is to use this code: Application.Run "acwztool.frui_entry","Tablename",acReport Invoking this gives a missing form name error for "frui_frmMain". I created a blank form with that name, and it comes up blank. It does not s... 21 Feb 2005 00:01

Publish YES/NO Checkbox in Word
I've created my first Access Data Base and I'm happy with the results in Access (2003). One of the reports I've set up uses Multiple YES/NO check boxes. The data for the boxes is entered through a form and has it's own field in the table. They show up in the report (both the yes and no values) as appropriate... 14 Feb 2005 18:10

Images in a Report.
Hi, I'm setting up a database for membership. I want to be able to print ID Cards for members, using fields from the members table, including a photo. I've used a Fial DialogFilePicker to capture the address of the photo. I'm trying to use a label report to print the ID Cards. This looks grand and has almos... 13 Feb 2005 20:23