Search results

Hi Doc thanks for nice explanation, and also Uncle thanks for your videos.

Yes I see in my case my events disable or enabled some fields on the form so the user can not enter or change data in the field.

Hi Gasman thanks. I will look the videos.

Hello yes I understand what you mean. My example is about entering a value in some field. When opening some forms- here I use some events on forms load event and current event so with this I am preventing possible errors?

Ohhh I see and now I undestand what is the purpose of having error handling in the procedure. :unsure: Ohh Then I was doing right all the time. :) I have very special database and I am thinking in all possible mistakes that can occur when user will start entering data in the fields. Thank you...

Hi Ok I see. So it depends what the code does and what is the purpose? yes in some cases I have code that if some value is null then msg box and some another action? my example:

Hello experts. I was just reading someting about ms access and read this and then start to think that in my database I do not have any error handling? So my question is that statment true? I have to make for every procedure error handling? Can someone tell me how I can do that? Maybe some...

My number is 67. Now You tell another number...

Our result be 226. Tell another number

Very niceee. Nice too hear and nice to see that. I hope you make pictures and have fun with every visit you make. 🤗 Knowledge from you experts is very valuable. :love:🤗

Hi yes Thank you Pat and Gasman for cooperation. :love: I check my events and my corection. It is so nice to see good cooperation from you experts. thank you 🤗

hmmm 🤔 I am opening the second form with on click event? I am opening with where argument like you say? in my before update event i am using some validaton rule?

Thank you for your explanation. I will try also that if I will get in problems with "my" solution. 🤔

I have to say that I am very stupid. :cautious: I make a mistake and becouse of me the form was all the time locked. When I have a record ID signed ( here all the field are disabled, greyed) then from that record I make another entry...and becouse I use AcFormEdit the fields were all...

Hi Pat Yes finally I think I managed to resolve my problem. I will see with a lot of testing if I am correct. I put acFormAdd and I make also where argument to open a specific record. Ohh I was so stupid. :cautious: thank you very much

I am just testing and for now i am using some button to open a form in add mode hmmm i still have to try all the suggestions from Pat and I think my problem is the same like here: https://www.access-programmers.co.uk/forums/threads/open-form-to-add-mode-or-edit-mode.295855/

Hi Gasman how you resolve that problem?

Well I think that my situation is very complicated. But I will try what you all suggest me today. To set Data entry to No. I need that users always when choosing records from form A and when going to the form B to enter data like new record. User just need to enter data. If he want to see...

OK I will think what to do i will do a lot of testing I am entering into new entry from some another form. They are connected. Becouse of that I set Data entry to Yes...but now i am thinking to make some button so the user will click that button to enter new data. ohhh i just wanted to be more...

Hi Pat Yes I am sure that must be some my mistake. Well now I put in the form properties the form in dialog yes and now on load event is no errror?? hmmm very strange I will continue testing to see if the error will apperar again ohhhhh :cautious: Before I have in this way: now I just...