Hello, I want to let users select which field should be included in a report. I already code a form in order to get strQryPersonal which is the SQL string...

Hello I have the following code on the OnOpen event of a subreport Dim strSQL As String If Me.Parent.Name = "rptSuitcaseStatus" Then Me.RecordSource =...

Hi, I'm a novice at Access and have a simple question: Is there a way to move multiple controls - say 10 labels or text boxes - to the right by 0.3" on an...

I would like to use an ActiveX Control to display a Calendar on a report. The report will display timekeeping data for a group of individuals. I would like...

I am trying to get my repeort to show Practice Name and if it is null to print address 1. what expression do I need to write to accomplish this. thanks...

I am a slow at this. So Please bear with me. I am using Access 2007. In my report I want my Practice Name to be first, but in some case there is no practice...

I am using Access 2003. I have 4 tables. They all have quartely data using the same fields. I want to use just one form instead of a separate report for...

Is it possible to read the WhereCondition argument in the Report_Open event? DoCmd.OpenReport "rptAddressLabel", acViewPreview, , "uidMember = 1234" I want...

Hi I am attempting to loop through a query recordset printing a statement for each record. I have the following code.. Private Sub...

Hi I have numerous reports that are working fine my only problem is if there are numerous detail lines on the reports therefore causing an extra page, how do I...

HI, I am trying to create a despatch note report, everything was working fine until I tried to place a control in the subreport (despatch note detail)....

Hi I have command button with the following code on: Private Sub cmdPrintDespatchNote_Click() Dim lngOrderNum As Long Dim rsDes As DAO.Recordset

I have the data in a report Project: Starting Month: # of Months: Product Quantity

I have produced a report in sorted by manager with a new page per manager but now they wish to receive their part of the report by e-mail. I presume that I...

Hi there I am not sure if this is the right forum if not please re-direct me to the right one. On a form I have an option group each option runs a...

I have created 4 snapshot reports for two different users and saved them into two separtate folders. I now want to e-mail the two users with their reports...

Access 2003 I've tried changing paper size to A4 in File, Page Setup. I accept the change and go straight back into File, Page Setup only to find that...

Access 2002 I have a report (unbound) with 2 subreports - more subreports later. The subreports report Age Group counts, and their record source is a query...

Access 2002 It is such a long time since I had to create reports and despite searching this Group and a lot of trial and error I just have not got a...

Novice builder so be gentle ;) Here is the problem. I have constructed a report that utilizes a main table that has a one to many with other tables. And...