Search results

Matt Thanks for your reply. Were would this code go?

Hi All I was wondering if somebody could help me, I have a form and I would like to add validation if a text box is null, not entered, a message to say that this is a compulsory field? Any suggestions or pointers in the right direction? Thanks in advance Andrew

Tried that but readonly was un checked. Just tried again, and it worked!! Strange, may of been a network issue Thanks for your replies....

John thanks for your reply When i hold down shift it still comes up with "The database will open read only" Any other ideas?

John could I ask you to do me a favour? and send this as a mdb file to my hotmail account as duer to restrictions i cannot open zip files in work. I have pm'd you my email address Many thanks Andrew

Hi I have added the startup function within access, to open my form to edit data. When it now opens it automatically opens read only and it does not allow me back in to the start up menu to change this?? Any suggestions?? Thanks Andrew

SOLVED i added a default value of false which overcome the issue. Thanks Andrew

Solved All sovled, I used Refresh instead.

Hi All I have added a me.requery within a checkbox but when I check the box it always goes to the first record, any reason why? An example, if i tried to check the box on record 7, it would go stright to record 1. Thanks in advance Andrew

gemma-the-husky Thanks for your replies and help with this... I am still struggling to adopt this code and overcome the error. Forgive me but I am fairly new with VBA within access. I have tried the nz and it still comes up with an error. Is there ant other appraoches you could suggest?

Were would that go within this code: Dim ctl As Control If YourCheckBoxNameHere Then For each ctl in Me.Controls If ctl.Tag = "disable" Then ctl.Enabled = False End If Next ctl Else For each ctl in Me.Controls If ctl.Tag = "disable" Then ctl.Enabled = True End If Next ctl End If

My Bad... Apologies! It working thanks very much, it works great.' One slight issue, is when a new record is created a runtime error appears "94" Invalid use of Null.... Any ideas to over come this?

Attached is an axample...

Hi Thanks for both of your replies.... My bad, when i said i put disabled i did actually put disable. gemma-the-husky I have tried your suggestions and it does not have any affect. when you say locked "true" this just doesnt allow any of the data to be edited and does not grey out the...

Hi Sorry just replying now, but got off from work early yesterday and only just had chance to reply. I have followed your instructions but nothing happens, no error messges. When the checkbox is ticked, the fields which i have entered "disabled" without the quotes just stay the same... Any...

Hi All this is my first post..... I was wondering whether som one could point me in the right direction with this? I am looking for when the checkbox field is ticked then this will grey out all text fields within the form for that record. Any ideas? Thanks in advance Andrew