Passing variable between tables

[Afrosheen via AccessMonster.com]

Is there a way where I can pass a variable between tables?

What I'm trying to do is create a login program. The field I want to used is
called [userlevel]. I then want to load the other table menu program based on
the userlevel of the login. I don't know if this can be done or not.

I'm really not familiar with the Access Security section to try that. I
tried it one time and had to uninstall Office and then reinstall it so I
could get at my programs. I read an article on Access Security by Joan Wild
and it seems easy enough. I just need to be able to get to my programs after
setup.


Thanks for your help in advance.

 

[Dennis]

You don't pass a variable to a table per se. You use it to filter the records
in the table. Personally (and I've done this lots of times during my work for
government agencies) I use VBA code to make certain functionaliy Visible (or
not) based on the capability of the UserLevel lookup result in my MetaData
table.

 

[Afrosheen via AccessMonster.com]

Thanks again for your reply.
What this userid program does is after you enter all the correct information,
then that program will stop and start loading the actual table that the user
is going to work on.

You don't pass a variable to a table per se. You use it to filter the records
in the table. Personally (and I've done this lots of times during my work for
government agencies) I use VBA code to make certain functionaliy Visible (or
not) based on the capability of the UserLevel lookup result in my MetaData
table.

Is there a way where I can pass a variable between tables?

[quoted text clipped - 9 lines]

Thanks for your help in advance.

 

[Dennis]

I understand. The methodology I spoke of is the same however. The value in
the variable will be used as a filter for the records. Unless you mean that
there is more than one table, and the variable value will determine which of
those multiple tables will be used during the session.

Thanks again for your reply.
What this userid program does is after you enter all the correct information,
then that program will stop and start loading the actual table that the user
is going to work on.

You don't pass a variable to a table per se. You use it to filter the records
in the table. Personally (and I've done this lots of times during my work for
government agencies) I use VBA code to make certain functionaliy Visible (or
not) based on the capability of the UserLevel lookup result in my MetaData
table.

Is there a way where I can pass a variable between tables?

[quoted text clipped - 9 lines]

Thanks for your help in advance.

--



.

 

[tom_willpa]

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com