I've done alot of projects in Lotus Approach and am now trying to convert to Access. One of the features of Lotus Approach is "variable fields", which are not connected to any particular table or record but rather hold values for the project as a whole.
E.g. a project includes a table of user names. Each user has a security level. When a user logs in, a macro sets the overall security for the session (a variable field) to the security level for that user.
This is particularly useful when running macros, as you can program the macro to check the security level before running, and therefore control what actions each user can perform.
My question is - does Access have a similar sort of field which is not attibutable to any table or record, but rather to the whole project?
Thanks
AL
E.g. a project includes a table of user names. Each user has a security level. When a user logs in, a macro sets the overall security for the session (a variable field) to the security level for that user.
This is particularly useful when running macros, as you can program the macro to check the security level before running, and therefore control what actions each user can perform.
My question is - does Access have a similar sort of field which is not attibutable to any table or record, but rather to the whole project?
Thanks
AL
