Search results

Can anyone please tell me how I make certain records ot enabled. I have a tick box that indicates when a record is complete. I do not then want a user to go in a change its details. I can do a Me. [field].enabled = False but this does all record. Thanks for your help. Dawn

Hello Again I have a form whereby I have two fields : a date field and a yes/no checkbox. I have a Save and Close button when pressed it runs a procedure to say if there is a date in the date field but the yes/no checkbox = 0 ( i.e. null) then show a message box. Which all works fine for the...

Brilliant. Thank you. Dawn

Very basic question coming up ... Does anyone know how to Save the current record on a form using Visual basic. I have an update query that will not work from a button on this form until I save this record. Currently, I have to move to a different record and back again and then run the query...

Thanks for all your help. It now works. Regards Dawn

I've added my fields and tables in but there seems to be a problem with the DLookup function. It is in red. Sorry I don't know much about programming. Regards Dawn

Brilliant. Thank you.

Hello There Does anyone know of a way or point me in the right direction to how I can set up my own security within Access 97. I have 1 user and 1 password to acess mulitple workgroups. I have already created a login form so when the user types in their user name a list of available...

Hello There Can anyone please tell me if when I'm in a form entering data say, in the first two records I exit out of the form and when I return I would like the cursor to jump to a control of my choice on the next blank record. I cannot do the method AcNewRecord as I have predefined records...