Hello
Forum,
I am exploring on how I can better secure my database.
I stumbled upon a macro lock navigation pane.
The property sheet has so many events,
I do not know which one to embed the macro to.
Any suggestions?
TIA
Haziq
Hello
Forum,
I am exploring on how I can better secure my database.
I stumbled upon a macro lock navigation pane.
The property sheet has so many events,
I do not know which one to embed the macro to.
Any suggestions?
TIA
Haziq
You design is a bit green at the moment.
You are getting people to log in , but then using their windows user name as the user name in records.
If these are secured domain PC's then the login form is really a moot point, unless you are paranoid about people not locking there screens when away, and other people doing things they shouldn't
Your stock level management is going to cause you issues, you are storing a qty on hand figure which will give you headaches going forwards, and you only have a single location for any item.
But stock levels are not an easy thing to manage - review http://allenbrowne.com/AppInventory.html for some valuable insight.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Dear,
Minty
This database design has been changing and I have yet to finalise it.You design is a bit green at the moment.
I will be sticking with login page as this db will be on a pc that does not log-off.
All I have is dummy data. =)only have a single location for any item.
I have been told many times in this forum but I have yet to find a solution.But stock levels are not an easy thing to manage.
you are storing a qty on hand figure which will give you headaches going forward.
I will read and reread http://allenbrowne.com/AppInventory.html till I get it.
Thanks for all your time, assistance and patience w/ me.
(You have posted solutions on many of my threads from ytd.)
Haziq