I have a primary form which is used to enter/edit data in a table named Test_Results. On this primary form there is a subform which displays site addresses. ...

How can i format a text field to be mixed case? Cheers Orla

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...

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...

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, 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,...

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...

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...

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...

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...

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...

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...

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'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...

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...

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

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...

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...

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...

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...