Search results

Thanks for the reply, i changed labels to text boxes but still flickering. Changed theme to classic windows but with no success on flickering. Anyway thanks

I have many forms having menus created by me. Instead of command buttons i used labels that can change colors on mouse move and execute procedures on click. It works perfect but on mouse moves it seems flickering. It's not a problem but it is a bit annoying. I'm giving a sample if anyone want...

Access gives error before geting to mytext_BeforeUpdate sub. The same happens for other errors too (Error 3201 etc...). I can trap them only when pressing my buttons. I don't understand why access is keeping on errors while i have DoCmd.SetWarnings False It's too hard to make a code for any...

this is a good idea but unfortunately this doesn't work. I put a breakpoint at mytext_BeforeUpdate and it doesn't even break at this point. I did that at form_beforeupdate with the same results.

You are right about no effecting on cycle property. The error still remains if i give a value on a textbox(datatype as number) as text. I trapped the error 2113 on my custom save button, but access gives an error like: "the value you entered isn't value for this field", when i press enter or...

i.m getting errors from access in my continuous form, when i click on previous records,even if cycle property is set to Current Record (if i change the value of a previous record to text and it's datatype is number). I used onerror statements for that situation too an my save button,on...

1. i thought it too, about cycle property, but i didn't like it. it worked yes. 2. unfortunately both text boxes have control sources fields of a table.

i'm getting my own messages when an error occurs(empty required field) and clicking my command button (save, nextrecord, ...), but i don't when i use tab or enter to access my records (for the same senario: empty required field) the (b) textbox takes it value from a code on exit of textbox (a)...

1. i already used, as i said, on error statements at my command buttons ms access gives error when i'm using tab or enter on my form (and have empty primary fields). Where should i reuse on error statement to avoid access messages an show my messages? I tried on form_BeforeUpdate...

Hi, this a great forum and i'm asking for help :) 1.i trapped error 3314 and other errors at my custm buttons(save,edit...) but... at my 2 forms(one single and the other continuous, access gives me an error about an empty field in a table (primary id), when i press tab (it moves to next...