Search results

This is more to authorize to the table, but I want to start opening a form thru my switchboard menu, then there will be a check on opening the form. Thank you

No, last time DBGuy said that his real name is George.

Below is my icon, since I have 2 databases, any one can help me how can I customize the icon not to show MS Access Icon? Thank you

Thanks George, but I do not know what is the VBA for this, probably lookup the table and the User access type and than say if.... then open, other Msg Box. Thank you Frank

Helo, Anyone can help me how to make that certain users can only access certain forms or reports. In my login table I have: UserID UserName Password Accesstype Thank you Frank

Thank you Arnel for all your help for me. May God richly bless you and your family.

Thank you Arnel, you made everything clear. Now my question, I want to make both FE and Autoupdater to be ACCDE/Mde to prevent other people to try to modify, Can it work as usual?

Thank you Arnel it works now, and the tblLocalVariable does not look like linked table anymore. Pls correct me if I am wrong: Below action we do just once for client computer at the time of set up copy the FE and the autoUpdater to the Client machine. run autoUpdater (hold-shift key) and run...

Hi Arnel, with this autoupdater guidelines : . "This table MUST exist in the front end, and must not just be a linked table from the back end.", I tried to have a table that I import from your Autoupdater.mdb the table named: tblLocalVariables, but when I run the Loader, it disappeared and...

Hello, I have difficulty in renaming the table. When I right click the mouse then I go to rename while the cursor is on the table. When I click rename is quickly jump to another table, so I could not finish renaming. How can we make that the cursor stay in that table, so that I can rename it...

Thank you Paul, It works now like what I wanted

Hello, how can I disable shrinkage of the form, because it is often when I wanted to move the form to the bottom, inadvertently my mouse cursor was on the top edge of the form, and when I dragged it, the form was shrunk to the bottom. I tried to see on the form property, but I could not find it.

Hi Arnel, From this text that we have on the Autoupdater text, we can save the Autoupdater in the same folder as Client FE's folder, It is not in desktop directory. Autoupdater Icon that we need to put on Desktop. Am I write? "4. Place the AutoUpdater.mdb on the client computer, where it will...

Arnel: I can not fill in this during the setup: Current FE Version Server Last FE Version Copied Over to Client Computer

Thank you Pat for an alternative, but I think let me just follow thru Arnel's suggestion. Thank you

Thank you Arnel, it seems my test is working, but this is when I used unsplit database, then I split. Now I am thinking how can I test my split database which is already go live. I renamed the Autoupdater to Loader, and it seems, this file that we can customize the icon on desktop for user to...

How can I create a .bat file and when the user run it. If we still ask them to run it, they do not even know how to run it or they could forget to run it

Arnel, what do you mean by this: //Edit: in case you are interested, i update the Loading of frmSetup. It will now, add the correct path of the Local installed ms access. I do not know where the MS Access program installed in the office. It could be installed in the server, not in client PC...

Thank you Arnel, I will try it after Jun 30, 2021. Because now we are busy in posting all transaction and make a preliminary stock takes of approx 200 items of supplies.

Thank you Arnel I will try it. To test/simulate it at home. Can I make it a pretending server such as C:\workshop\Nevergiveup\allwaystry\EVStrialInventory.accde Thank you. Frank