Hi I have continuous subforms on a main form. In some instances these subforms show a lot of records. The subform design is such that each record does...

I'm trying to create an Access application for my personal use that will index the photographs I take with my Canon Digital Rebel XT camera. I usually take...

Hi, I have VB code that assigns a value to controls, used for several controls on several forms. OTOH some of these controls (not all) have a beforeUpdate...

I'm making a database for a book store and I have created the invoice... However, when I want to add a new record, i.e. make a new invoice for a different...

Hi I have a form with 2 drop down lists. Drop down list #1 is the category (state), #2 is the sub-category (cities). I would like to display the sub-category...

Hi there, I wonder if someone could help me. I've got an Access 2000 database which is accessed by several users. Basically i've got a form attached to a...

History: have a multi-user dB split into front and back end that is used for expense reporting. There are "print" buttons that call this event...

Douglas, I followed your method of passing values from a form to report and wrote code something like this- in cmdGenerateReport_Click event in form...

Why does the answer to this calculated control sometimes say 3.6E-12 or 7E-12? =NZ(,0)-Nz(,0) Thanks Tony

I have a problem which has been reported here before but which I can't seem to solve. A primary form has a number of command buttons which open new...

I have created an autoform on a table which lists products stored in our store room. Is it possible to create a text box and a button on the form which will in...

I am using the Time & Billing template to create a database for a service company. I want to be able to apply a % discount to the 'hours billed' only. I know...

Greetings, I have the following code and I get a "The OpenForm action was cancelled" message. Private Sub btnThisWeeksGames_Click() On Error GoTo...

In Access 2000, how can you find where the data comes from in a Pivot Table form created with the Pivot Table Wizard? I have looked in the form properties,...

Hi all To carry out an immediate update to tables when entering data into a form I had been using: DoCmd.RunCommand acCmdSaveRecord DBEngine.Idle...

I have an extremely large database which is in a continuous form format, and what I would like to happen is, instead of using the find button that would just...

Hi everyone, I am trying to pre-poulate the form fields with the previous entry. I am using the following code: Private Sub...

Hello All I have a form that has an OnOpen event, an AferInsert event and an AfterUpdate event. Until yesterday they all worked fine, but then I...

Hi I have another question I have a from which uses a command button to load a report based upon the catergery selected in a combo box. i want to add two...

I have a switchboard in my DB that opens a form and previews a few different reports. Once other users are done with their data entry they will close the...