Search results

Ok, ignore that last message. I Just saved the module as mod Secuirty and it works fine :) I already had a macro called "autoexec" as that runs a piece of code that disables the program X button (you cannot exit out of Access without click a button on my form). So i guess it does store the...

Hi, and thanks for that :) Does the module i create need to be called anything in particular? Or will any name do? And also... if i create a macro, i take it i dont need a form to open up in the "Startup" option? Scott

Ahh sorry, i thought it was a constant, my knowledge of this is a little vague so the terminology was wrong :) Ok, sounds like as you say i need to declare a public variable, but everytime i have tried this when the "frm logon" closes, the variable does not stick and i cant call it using VBA in...

I manged to finally sort out the code that lets you logoffwindows by running a function, this is the module called WinExit, then behind the button you want to use, you just put Run "LogOffWindows" and this one works fine :): Option Compare Database Declare Function ExitWindowsEx Lib "user32"...

Yes, its that time again im back to programming in VBA for a new project im doing at work... The short description is: I have a database that is accsessed by 6 people, i had changed the front end of the database so that you have to login in with the NT user name we have here at work. It all...