I use the strSQL command below to insert values into a table. This works fine except that I must have values in all 4 fields. If I'd wouldn't enter data...

I want to create a form in a datasheet view. Data displayed should be based on a value picked from the combo box. For ex. a user will select his name in the...

I have a form with SUBMIT button. When clicked the form checks whether or not any controls are left blank. If yes, all blank controls are highlighted in...

I have a form that I use to automatically list specific fields in a list box that need to be updated at a later date. Two text boxes are used to enter the data...

I have three combo boxes in a form that requery and then the subform gives the results. Everything works fine but...: when I look for another set of values,...

Hello to everybody. How may I cancel a record with a button and all the relative informations in the subform. Many thanks Regards John

I am creating a form using a subform. I have 2 tables that i am accessing the data from which I have created a relationship for. I would like to be able to...

I have created a form that is attached to a query. When you open the form it has text boxes that are populated with the first record. Their are two text boxes...

Had one issue calculating time in a Report. The report shows people looking for service, it has the time the person arrive and the time an officer call them. ...

I have a form with a combo box on it that is populated with items from another table. I have it so that it is sorted alphabetically but rather than the first...

I had a subform in a form. The subform has a check command to set value (date and user) for two fields in the subform. If I open this form and click in the...

Here's the requirement. User needs to be able to enter 2 items of data onto a form and press a button. The code behind the button needs to check that both...

I had a form and save it into *.mdw. I need to save as Data Access Page and it worked. But, I changed the form and saved it as Data Access Page again. Page did...

Hi all :-) XP Pro, Access 2003 I have an entry form for record sales activities, and when I do a print preview, nothing shows up except the header...

I have a form which has a student's details, together with the Caregiver One and Caregiver Two details. I want the Last Names and Addresses of the Caregivers...

Hi, I'm wondering if someone can help? I am stuck on this?? I have created two forms who's tables are joined by primary/forigen keys. Table\Form #1 -...

I have a table for cars and a table for lorries. I have a wonderful form I have created using tabs for the cars, but now I want to transfer it over to the...

i created a form to add data to a table. I have a column it calculates how many hours take me to do a work. I have Start time column and Finish time column. I...

I am creating a questionarrie database where some questions have choices like "Strongly Agree", "Agree", "Disagree", and "Strongly Disagree" while...

I would like to create a form that remains the same except for the number. The number will be contineous, ie: checks, control batch numbers, invoice numbers.