Search results

Hi MajP, I want it not to let us move to the next field in the subform, because when when we moved, there is an error message from the access itself to say we should fill the customer ID, but even I stuck I can not go back, unless when my cursor in the description field i press escape than i...

Hello, How can we make it not to leave a field blank such as customerID from the Main form, before it goes to the sub form as I marked in red in the attached form. Because when we got in the sub form, I can not get back to the previous field ( CustomerID}. and get stuck, so I delete the...

Thank you Gasman, I will do as you suggest Thank you

Hello, can anyone help me how to make on the form : on Load, there is a message says" please do not use this form, still under development" the user press OK, then exit the form. Thank you for any help. Frank

Hello, attached is my switchboard menu. Is there any simple way to not allowing anyone to access menu no. 1 " New Items of supplies", Or just to allow User-3. I have the user table with the field "Users". Thank you for any help Frank

Arnel, it seems you misunderstood what I mean. I mean is I want to explain what is new in the new version, let's say in version 2002.02. I developed new feature, ;like "there is level of authority, only user 2 can update/enter a new items of inventory. Menu no 1 is only used by user2". This...

Hi Arnel, I come back to you because I got this knowledge from you. I am thinking now on where shall we put the explanation of what is new in the new version. Can we put it on the tblLocalVariables, in the field version?. Right now it is empty, because the way I update it is just change the...

Hello, I keep updating my Inventory database that is already go live. My question is where can I store the information of each version. I do not want to keep in in the table, but just somewhere in the software that just the developer that can access it and know the information Thank you. Frank

Thank you Pat, I will try to think what is the best method for my database design.

OK June I will do the research.

Is that using TempVars is another way to keep the login value in memory?, but I do not have the sample to learn. Do you have it?

The doc_Man, this code: SetFormSecurity Me, Forms!LoginForm!txtLogin, can work if my login form is always open right?. When the login successful, the form will automatically close and go to navigation(Switchboard) which is a drilldown menu like this:

Could you let me know your suggestion Pat Hartman?. My main purpose is to just let the user to read-only/just to view for all user forms, except for report they can just print it. Thank you Frank

Thank you Sir, I will try it

Thank you Sir, I will try to figure it out. Frank

Hello, I am gonna try like this class module on on load of each form in order to make user for Read_only on each form: rivate Sub Form_Load() Dim User AS String Dim LoginType As Integer User = Forms (Mavigation Form)!TxtLogin LoginType = Dlookup("UserSecurity","TblUser","User2") If...

Thank you very much Leo. Frank

Thank you George, you are awesome. You helped me a lot, even when I was in Indonesia, now I am in California you still help me. Thank you and God bless you. Frank

Thank you very much George, I will try it

Sorry George, I did receive it. But in which event should I put : Me.Combobox.Requery Is it on click on the combo? Thaks