In a Form, I want to run a Macro if a specific condition is met. Does anyone know how to do this? I tried a Command button but it does not have th Control...

I created a database in Access 2000. It printed fine. Opened it in Access 2003. Report left margin is 2.5 – I change it, it won’t change. What should...

I am using MS Access 2007 and I have a switchboard on which I have several buttons to run various reports. Since I want to have the ability to put a...

I am trying to create a report that looks like a report from excel. I have two tables; tblProviders and tblBenefits I want the report to look like this: ...

Hi, Wondering if somebody can help me out, I am in a really desperate situation to get this sorted. I have a form that draws records of from the underlying...

How do I view the report in the form ( like sub form ) ? Somebody told me to use the snapshot viewer, but I don't know how to do it. I need help.

I have a report with the following groupings: 1.) Claimant 2.) Group 3.) Carrier in the Claimant footer I have the a control named max_ded with the following...

We have just installed MS Office 2007 and we have access 2007. When tried to open a form a message is displayed saying the transaction and/ or form is...

I have a report that uses from a query. When I run the query, the criteria box pops up one time. I fill in the info I need and the query runs. Great. ...

When I run a report, which contains sub-reports, the first time the information on the sub-reports displays. If I run the report again - even for the same...

Has anyone had a problem with reports in Access 2007 being extremely slow when based on a query that runs very quickly (couple of seconds) that is getting...

I have a report which is sent as an attachment dynamically when cmdUpdate_click event occurs. I would like to customize the title of the report to include...

=Hour(Nz(DSum("-","tblMain","= AND Between Now() And Now()+7"),0)) The formula works perfect if I substitute the Now()+7 portion of the equation with a...

I want to format an access report to print landscape on legal size paper with two pages on each page, page 2 on the left half and page 3 on the right, with...

I have: TRANSFORM Count(tblCandidates.CALL_RESULTS) AS CountOfCALL_RESULTS SELECT tblCandidates.CALLED_ON FROM tblCandidates, WHERE...

I have two logos I need to have show up in report header both when viewed and printed. As I have them now, they are OLEUnbound embedded. I have several...

Hi, I am wondering to know if a sub report can drive a main report meaning the main reports can only show data if a sub-report have data ? My problem is the...

I need to get as many lines as possible on each report page - with readable font size. The default spacing between lines is too large. How do I reduce it?

I'm finishing an application in access 2007. I tried to install the application on the computer with no access 2007. It was running well but when I tried to...