Dlookup works when viewed one record at a time on the Form. I create a Report based on the retrieved data from the form with the dlookup information repeated...

I'm having some trouble with the "DoCmd.OpenReport" function. I currently have a report, and I'm using the "OpenReport" command (using Access 97) to print the...

Good morning, A little probelm has stumped me and I have looked for the answer here, without success. If someone could help, I would appreciate it. I have a...

I am making a report that will be mailed. What i want to be able to do is have this: First Name, Last Name Address City, Prov Postal Code But i need to make...

I have a ordersform, qryordersform (based on a false Yes/No Check Box on my orderstable), and a rptneworders that pulls only the false records (new records)...

I am trying to print off records in a report. I only want 1 recored to be printed off at a time........not all records in the table. I have a form that calls...

I am using the Mail Recipient (as Attachment) button on a custom toolbar to mail an Access 2002 (SP3) report, choosing RTF format. For records in a memo field...

i need to add this code to one of the feilds in my access report: Public Function GetID(Expr3 As Integer) As Integer If Len() = 3 Then Expr3 = &...

I have a "remarks" field that will only be used occasionally and in the interest of not having many repeated blanks on a report, I'd like the field not to be...

First of all, I'd like to thank all. I have this formula which works well CDate( & " " & )-CDate( & " " & ) I get a values as double precision numbers like...

Hi, I would like a report which prints out a weekly itinerary plan for our employees. I have looked at Duane Hookom's reports but they don't quite achieve what...

I have a report that is based on a query that searches for a check box field to be false. Once the report is run, I would like to have a confirmation box on...

Hi, Is there a way of changing a bar to a line as I have a line column graph with two X axis and even if I change the axis it keeps it a bar. I have...

I have two subreport in the invoice now i would like to combine, both subreport total in my invoice. So as to have one total after which i would like to...

I want to create a report that gives Sales YTD by month for each customer. I get the relevant data from SQL Server and insert it into a local table and then...

I have a table with a single record. I made a form for that, but I have to quit the form before the changes in fields of this form are saved. I already tried...

In the company information I have a place to add the logo. It is a bound OLE object and works, but for some reason DLookup will not work in the report. Is...

Hello All I am using A97. I have a button on a form that, when clicked, brings up two reports. The on-event code is below. The problem is that I want to stop...

I have some code which seems to work fine in print preview; however, when the report is printed no detail records are shown. The code is run as "Format"...

Hi, Is there a way to set chart control properties such as Y-axis scale parameter programmatically? I want to set this parameters based on values from a...