Search results

Thanks this is exactly what I'm looking for.

I have a button on a form with code that accesses data from the table it reads using the Me key word.I've added a new field to the table but when I try to accesss the data in the form button code I get error Method or data member not found. How can I access this data from the form without...

I have been able to create a button that copies the exsisting record and appends it to the end of the table as a new record. Here is the code: Private Sub Command2_Click() On Error GoTo Err_Command2_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem...

I have a table which has a finite number(43) of records at the begining. Any subsequent records I add will always be derived from starting with one of these 43 records and altering certain fields to form new records. I have a form containing only the fields I want to allow to be edited.I would...

THANKS FOR ALL THE HELP. I GOT THE CODE TO WORK FINE.

I would like to have a command button in a form that opens another form ,first test the value of a check box.Based on the result the button would either open the form allowing access to it or inform the user that the check box must be checked first.The following code checks a text box for null...

I have a form that I wish to add a control to .The control I want to add exists in a table I have.But when I pull down the field list from the tool bar it isn't there .I added the field to the table after I had created the form.Is there a way to update the form list to show this new field?(so I...