Search results

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

Could you resend it George?. I did not receive it. Thanks Frank

I do not know the VBA for requery. Did you mean we click the arrow of the combo?. I did it but It still didn't show the new customer Thanks for your enlightening me. Frank

Hello in my supplies issuance form, there is a button to add for new customer or supplier. when I add it, it will not be shown on the combo box, until we close the form and open it. What event procedure shall I make on the combo in order to automatically showing the new added supplier, just if I...

Thank you Arnel, I got it

how can I see the sorting grouping which button should i click

Hello I just copied the customer report to supplier report in order to make a supplier report gouping by supplier or items. Can anyone hlep me how to edit the grouping from cutomer id to supplier id as shown in the attached picture. Thank you Frank