Search results

Try this in the last text box Lost Focus event. DoCmd.RunCommand acCmdSaveRecord MsgBox "you can not add or edit more records", vbOKOnly Me.YourFirstTextBox.SetFocusThis will not let you go past the last text box either empty or after entering data. Dale

Joey, Take a look at the attached. Are we getting close? Dale

Then what is wrong with post #2? Dale

Try on the form OnOpen event. Me.ShowDatePicker = 0 I am not sure if it will be 0 or false. Dale

You have only 1 table? You need at least 2. One other one for dates. Dale

Take everything out of your query except the following. tblEmployeeDetails.EmployeeID, tblEmployeeDetails.FirstName, tblEmployeeDetails.Surname, tblAddressList.DateFrom. Use the Summation icon in the query design view. GroupBy everything but the DateFrom field. Make that max. See is this...

What i s produit? It appears more than once with a different ID each time. Can you post a picture of your tables? Dale

OK, that helped. You want to let them add or edit 1 record only correct. In the On Click code for both buttons add the following as the last lines of code. me.YourButtonNameHere.Enable = False When they click the button 1 time this will turn the button off. Dale

Sure do. can you upload the database. I can show you better than type it out. Dale

Try the Dmax() function for the DateFrom field. Dale

Ok. Your users are adding and editing on 2 different forms. Correct. And as they finish adding a record you want to stop them from automatically going to the next new record.Correct. If this is true then they can not get to a new record without putting the cursor in the last text box and hitting...

Sounds like you need a refresher on tables. Take a look at this. http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Dale

On the After update of the last text box close the form. DoCmd.RunCommand acCmdSaveRecord DoCmd.Close acForm, "YourFormNameHere", acSaveYes Note: the acSave saves the form structure and not the data. Dale

Your tables are not normalized it appears to me. Your Product and valeur_liquidative should appear in a table only once. Read the following to see if helps you . http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Dale

Start by reading the following. http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Dale

Try changing the Macro to VBA. DoCmd.Close acForm, "FormNameHere", acSaveYes You can and will need to add some error handling. Use the quotes around your form name. Dale

I believe that if done correctly Dsum() does use date in the criteria. They Have to have to # date# I think. Also running totals are better done either on a form or report. Dale

Show the full code not just parts of it please. Dale

I think you need to normalize your tables. Data is appearing more than 1 time in your tables. Dale

I like helping and I like the idea that is is for free. I stopped writing for profit. Dale