Is it possible to create repeating items in Access, similar to what Repeating Tables provides in Infopath? I have creating a database to manage contacts and...

I have a main form acting the part of a switchboard. On this you choose from a variety of selection criteria. This criteria is then used in a query which...

Hi, I have a checklist table which has many fields. This table relates with the main table by the caseNo field. I created a form with the datasource from main...

I have an "Audit Trail" database... the form track all previous data values in the "Updates" field. I need some help w/ customizing the VBA code so that NOT...

I'm using the following code for the On Delete event of a form to clear a checkbox in a related table if the user deletes a record in the form: Private Sub...

Hi Stephen: I am still trying to figure this out. Could you elaborate on what you wrote below? My default is set for "single form". It's not clear to me the...

This code; Me.Parent!SecondSubformCONTROLName!BoxName = Me!BoxName was suppose to have the first subform field called: Box Name, going to the second subform...

I have added a Duplicate record button on my form created using the wizard. When I use it I get a run time error 3022, "duplicate records..........". because...

I'm having a problem pasting from an Excel "template" to an Access Form. I've had great success with this process other situations, but for some reason this...

Does anyone know how to add several fields together in a form to arrive at a grand total? I am a social worker who uses an access database and need to have...

I have a dlookup on an unbound field on a form: =DLookUp("","Organization"," = '" & Forms! !Office & "'") This works OK on the form, but when the form is...

Hello, I would like help with coming up with the simplest way to enter a currency value in an input box in this manner: 1) if a person enters "5", the...

Is there any way to have a button remain pushed in when a user clicks on it? I want the button to remain in even when the mouse is released and...

Hi, I need to create a form that has checkboxes. 10 columns of different Divisions with 9 rows of hours such as 10-11, 11-12, 12-1 and so on. In each row under...

I have a form with a calendar in the header and I have a date text field in the detail section. I have put code in the double click of the date field which...

I want the user to pick a name from a combo box that is based on a query and is bound to the number ID---but my names are split into Last, First, Degree...

Hi, Please help me with the problem as following which I'm encountering at work: I want to create a switchboard for the existing Access Database(2000,...

Is there any way to prevent access from traversing a forms records when a user scrolls using the mouse wheel? I have a text box on the form and I would rather...

Hi there, What I am requiring is a form which when i look up the ID in a combobox(IssueID), matching fields for that record will appear - I need to be able to...

I want to create a form that will look up records via a social securtiy number (ssn) from a table the data already exists. I do not want to add, delete or...