Search results

I am helping a friend with his Access 2007 database. I have some basic competency with Access 2007 but am having a problem with a form. This form contains a subform which has data that came from a query. I have attached an image showing the form. I would like to do two things: - Allow user...

My question concerns reports in Access 2007. "rptInvoice" prints an invoice and multiple line items. If a line item is for $1,000 or more, I want to print another line immediately below it which shows a credit of $50. If the line item is for less than $1,000 this additional line should not...

Hello, I have a form with quite a few controls. I may want to hide these controls based on the security level of the user. Rather than set the visible property of each control to False, I would like to cover the controls with a rectangle or some graphic so the controls won't be seen. Is this...

Hello, I am trying to make some changes to a form in an Access database application designed by someone else. I am also learning Access as I go along. The form I want to change has a subform that shows contacts for a company. The subform is populated by a query. I've noticed that I can edit...

Hello, I am trying to help a small company that is using an .mdb database in Access 2007. Their previous programmer left little documentation, unfortunately. The problem occurs when they call some routines that are intended to create a PDF file from an Access report. The routines were...

Hello, I am using Access 2007. I used VBA to print out all the properties for a form. I saw a number of formatting properties that were not listed on the Property Sheet, and I don't know how I could change them other than through VBA code. Here are the form properties that are not shown on...

I am running Access 2007. I have an .mdb database, and it works fine. BUT, I am unable to make any change whatsoever to the VBA code without causing an error when I try to open the database. For example, I view the code for Form_frmMenu. Inside a function, on a blank line, I enter the code...

Hello, I have two separate .mdb databases. Each contains a form named "frmMenu". I would like to compare these two forms. Specifically, I would like to compare everything about them - the controls, their properties, and the VBA code. Ideally, I could export each form to a text file and use...

Hello, It seems there are various ways to test a newly opened recordset for no records. But wouldn't this be the simplest and most foolproof? If Not (rs.BOF And rs.EOF) Then ... Thanks.

Hello, I am quite new to both Microsoft Access and VBA. I am using Access 2007. I have been asked to write some simple VBA code to be used inside an existing .mdb database. I will be using DAO. My question is very simple. If I want to open a recordset, is the following code sufficient...