Referencing this page:
https://www.access-programmers.co.uk/forums/threads/tempvars-vs-type-variables.315649/
May I ask your opinions as to which may be a better option for my database?
I am building a program that several departments will use: for inventory, for ordering, logging repairs, logging problems with equipment, etc.
Currently we use several different databases but I would like to combine them into one, that way ordering parts/supplies and tracking costs is easier, among other possible benefits.
So, in one program, I use a User class module that I believe I found on this site. And I'm looking over it wondering what are the possibilities with a class? Then I find some tempvars, and remembered someone here had a distaste for them. And of course, I have a few global variables.
Add to that @NauticalGent posts an example of a global instance of a type? I have never used that before and don't really understand it.
The program opens with a hidden form, checks for inactivity behind the scenes (well, it will once it's done) and a menu screen appears allowing users to open the form(s) they need to use if they have permission to do so.
Generally, I call a function to get the user name and use that to determine what is available to the user.
Bottom line questions:
is a class worth using here?
would a global type be worthwhile? and how does that work? is it persistent throughout opening and closing of many forms?
would tempvars be more useful?
https://www.access-programmers.co.uk/forums/threads/tempvars-vs-type-variables.315649/
May I ask your opinions as to which may be a better option for my database?
I am building a program that several departments will use: for inventory, for ordering, logging repairs, logging problems with equipment, etc.
Currently we use several different databases but I would like to combine them into one, that way ordering parts/supplies and tracking costs is easier, among other possible benefits.
So, in one program, I use a User class module that I believe I found on this site. And I'm looking over it wondering what are the possibilities with a class? Then I find some tempvars, and remembered someone here had a distaste for them. And of course, I have a few global variables.
Add to that @NauticalGent posts an example of a global instance of a type? I have never used that before and don't really understand it.
The program opens with a hidden form, checks for inactivity behind the scenes (well, it will once it's done) and a menu screen appears allowing users to open the form(s) they need to use if they have permission to do so.
Generally, I call a function to get the user name and use that to determine what is available to the user.
Bottom line questions:
is a class worth using here?
would a global type be worthwhile? and how does that work? is it persistent throughout opening and closing of many forms?
would tempvars be more useful?