Search results

I already have find as you type but still not work. Thank you, Frank

Yes the situation is not all the supplies description have the starting # Thank you, Frank

Hello, I noticed that any supplies description of our supplies starting with "#", e.g "#15 Citra Cide" This will not be auto find, so we have to scroll down and search on the combo window. Anyone can help me why, and how can we solve the problem?. Thank you Frank

HI Arnel, In reference to Pat's comment about RI ( Referential Integrity) in my database, I want to try to change the control name to be "txt_ItemCode". But since my database is already go live since Mar 2021. What do you think that I am so careful in order not to have a problem on my database...

Thank you Gasman. I am more understood now, the different between the field and the control. Frank

Thank you Arnel, it works perfectly. I did it on my testing database. Thank you very much Frank

As simple as that?, will it not confused because the name of the form field is the same as the name of the table field?. Thank you, Frank

Hi Arnel, I have a question, maybe because It was too long, 10 years ago I never touched anymore the MS Access VBA. so I forgot the naming convention. In my case now, the name of the field of Form, I made it as Itemcode, that should have been txt_ItemCode. So now the name of the field of the...

What do you mean Pat by Don't forget to also set RI

Thank you Arnel, I have tried your suggestion and it works like a chant Frank

Thank you Arnel, I will try it, but I see your suggestion is very good. Thank you, Frank

Because the user will input the ckout list by department, by requester name. so on one go of the data entry only allowed to enter one type of supply. but user try again to type the same supplier for the different requester which create error message and they do not know how to cancel it. Thank...

This is the sample to avoid duplicate item at one go of the data entry in the form., but my problem as you can see in the previous form, my form used sub form, so I am afraid it is not going to work. Anyone can help me? Thank you Frank

It is already using combo and it is already automatic finding the name of supplies, but for the next row, even though we have told do not enter again for the same go, but they still try to enter, so I want the before update in the column, as they enter the same name, there is an alarm and there...

Hello any body can help how to avoid duplicate supplies in one go of the data entry in the form? As you can see in the attached form, I want the user as he type the same supplies name there will be a massage saying " this is duplicate, please enter it in the next data entry. Thank you. Frank

Thank you Pat and all of you guys, your comments trigger my brain to search the reason why it did't work, and now it works for me. The clue is that we should filter it from the field of the the table on the many side in the one to many relationship. So the customer name should be taken from the...

It works for other button to open the reports, so maybe I will try to make a different report and different query and different button Frank

Hi Pat, I can change the link using link manager at office and at home. As you can see attached even I have changed the name of the combo, but the report still show nothing. Regarding the combo, already shows the name of the customer. I do not know where *I am wrong. Thanks for any idea. Frank

The way I created the new combo is by copying the running one, such as item description selection, so I think it should work. And the format of the column is the same, and the coulumn count, and the bound column . column count is 2, because customer name is the 2nd column in the table. Ok I...

No Gasman, it is customers, that is why it shows already in the combo32 Frak