login form

B

binksmatthew

Registered User.

Local time

Today, 06:09

Joined

Mar 3, 2007

Messages

21

• Mar 3, 2007

• #1

i was wondering if there is any way that i could get the users name from the login form that i have just entered to the switchboard form that appears after a member has logged in.

 

missinglinq

AWF VIP

Local time

Today, 01:09

Joined

Jun 20, 2003

Messages

6,417

• Mar 3, 2007

• #2

Declare a Public variable in an independent module, then assign the login name to the variable at login time; this will make the login name available anywhere within the database.

 

boblarson

Smeghead

Local time

Yesterday, 22:09

Joined

Jan 12, 2001

Messages

32,040

• Mar 3, 2007

• #3

Just remember to declare it as Public and not Dim, otherwise it will only be available within the scope of the module it is in.

 

B

binksmatthew

Registered User.

Local time

Today, 06:09

Joined

Mar 3, 2007

Messages

21

• Mar 3, 2007

• #4

im fairly new to access and dont really know how to create a public module. can anyone give instructions or an example. thanks

 

boblarson

Smeghead

Local time

Yesterday, 22:09

Joined

Jan 12, 2001

Messages

32,040

• Mar 3, 2007

• #5

 

B

binksmatthew

Registered User.

Local time

Today, 06:09

Joined

Mar 3, 2007

Messages

21

• Mar 3, 2007

• #6

thanks for the instructions. it works perfectly now

 

boblarson

Smeghead

Local time

Yesterday, 22:09

Joined

Jan 12, 2001

Messages

32,040

• Mar 3, 2007

• #7

Glad to be of service.