Recent content by iommi

You can also run a dbengine(0)(0).execute("DELETE blabla FROM blabla WHERE etc") etc etc. This will just delete the record(s) in the recordset in your sql statement above. It does not prompt the user.

No. I tried this after readíng your advice... but I cannot validate in the beforeupdateevent. Access complains about this. It says its values must be saved before the code in the beforeupdateevent occours (in my case the validation). So its back to the origin problem. But I followed the advice...

Cant you just have a column-combo, where the user chooses a value? Must the combo pic up its items (selectable values) from an underlying table? I dont know if i have understood correctly, but when you post the values, you cannot update the recordset. Solution: Use dynaset. dbengine(0)(0)...

Hello again. Sorry to disturb again, but i forgot to ask one thing in my question below. If I put some validation code in the afterupdate or onexit event in a textbox, runs the validation (something is not to be less than 3) via the form (The user types some value which my validation...

Hello The purpose of the program is to randomise different patients, using block randomisation so they are optimally allocated to one of two groups. I am developing the program for a major hospital in Sweden, and the reason I asked was that if any person who runs the system fills in all the...

I wonder how to close a form, using the close event, without saving the data that are entered into the controls (txtboxes)? I have tried to loop as many times as there are number of controls -1 on my form (starting on 0) and take the controltype (if accontroltype = acTextBox then...) and set it...