how to give a user a limited time access to certain forms ?

[cewolf]

Greetings every one !!

it is my first time here

i have a problem that i dont know how to solve ...

i have database that i am working on , i want to give a user a time limited accsess ( one week ) to the reports section for example !!

after a certain date he will require a password or the report button will be inactive



i have an idea how to do that but i don't know how to apply it in VBA ( i am not good at all with programming )

-at program start up , it will check for today's date if it is greater or equal to (lets say ) 24-9-2013 then it will change a field in an X table from "yes" to "no" ,


-after that the code will check table X for the yes no field , if yes then open Form A
if no then open form B / or make report button inactive


how to do that in VB ... and is there is a better way to do it ? can it be done in the macro builder ?

a ton of thanks

Z

[Dal Jeanis]

The question of VBA or macro is just a style preference - they can both accomplish the same thing, for the most part.

There are a lot of design issues in what you're talking about - it isn't hard, but there are lots of fiddling little details that all have to match each other.