How to create a variable? (login as'"Currrent User")

[Henro V]

I want the login name that somebody enters when starting the database to be
set as a variable.

I'll try to explain:

I have a table (Engineer) that lists engineers (they are the users)
The relevant fields are

Engineer.Name
Engineer.Code (where the login in the database is the Engineer.Code)

I have a table (Hours) that lists the hours that they worked
The relevant field here is

Hours.Name

I made a query on the table Hours that is called Hours Query
On the field
Hours Query.Engineer
I set the criterium
[Which engineer?]

What I want to do is create a variable "CurrentUser" that, instead of asking
to type in the engineer name fills the current user name in instead of
asking the question [Which Engineer?].

Can I do this and how?

TIA

Henro

[Nigel tombs]

Does each engineer have there own network login?
If so, then you can trap the NT username using an API call.

"Henro V" <ma**********@hotmail.com> wrote in message
news:bp**********@news4.tilbu1.nb.home.nl...

I want the login name that somebody enters when starting the database to be set as a variable.

I'll try to explain:

I have a table (Engineer) that lists engineers (they are the users)
The relevant fields are

Engineer.Name
Engineer.Code (where the login in the database is the Engineer.Code)

I have a table (Hours) that lists the hours that they worked
The relevant field here is

Hours.Name

I made a query on the table Hours that is called Hours Query
On the field
Hours Query.Engineer
I set the criterium
[Which engineer?]

What I want to do is create a variable "CurrentUser" that, instead of asking to type in the engineer name fills the current user name in instead of
asking the question [Which Engineer?].

Can I do this and how?

TIA

Henro

[Arno R]

Henro,
How about using CurrentUser() ?

--
Hope this helps
Arno R
"Henro V" <ma**********@hotmail.com> schreef in bericht news:bp**********@news4.tilbu1.nb.home.nl...

I want the login name that somebody enters when starting the database to be
set as a variable.

I'll try to explain:

I have a table (Engineer) that lists engineers (they are the users)
The relevant fields are

Engineer.Name
Engineer.Code (where the login in the database is the Engineer.Code)

I have a table (Hours) that lists the hours that they worked
The relevant field here is

Hours.Name

I made a query on the table Hours that is called Hours Query
On the field
Hours Query.Engineer
I set the criterium
[Which engineer?]

What I want to do is create a variable "CurrentUser" that, instead of asking
to type in the engineer name fills the current user name in instead of
asking the question [Which Engineer?].

Can I do this and how?

TIA

Henro

[Henro V]

How can it be so simple!

That one does the trick!

Thnx a lot!

Henro

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...

Henro,
How about using CurrentUser() ?

--
Hope this helps
Arno R
"Henro V" <ma**********@hotmail.com> schreef in bericht

news:bp**********@news4.tilbu1.nb.home.nl...

I want the login name that somebody enters when starting the database to be set as a variable.

I'll try to explain:

I have a table (Engineer) that lists engineers (they are the users)
The relevant fields are

Engineer.Name
Engineer.Code (where the login in the database is the Engineer.Code)

I have a table (Hours) that lists the hours that they worked
The relevant field here is

Hours.Name

I made a query on the table Hours that is called Hours Query
On the field
Hours Query.Engineer
I set the criterium
[Which engineer?]

What I want to do is create a variable "CurrentUser" that, instead of asking to type in the engineer name fills the current user name in instead of
asking the question [Which Engineer?].

Can I do this and how?

TIA

Henro

[Henro V]

That was the idea but I have already defined the engineers in the database
together with their network login codes so CurrentUser () does the trick!

Thnx for thinking anyway and I must say, you were thinking exactly along the
lines I was thinking.

Grtz Henro

"Nigel tombs" <ic*****@tiscali.co.uk> wrote in message
news:3f**********@mk-nntp-2.news.uk.tiscali.com...

Does each engineer have there own network login?
If so, then you can trap the NT username using an API call.

"Henro V" <ma**********@hotmail.com> wrote in message
news:bp**********@news4.tilbu1.nb.home.nl...

I want the login name that somebody enters when starting the database to

be

set as a variable.

I'll try to explain:

I have a table (Engineer) that lists engineers (they are the users)
The relevant fields are

Engineer.Name
Engineer.Code (where the login in the database is the Engineer.Code)

I have a table (Hours) that lists the hours that they worked
The relevant field here is

Hours.Name

I made a query on the table Hours that is called Hours Query
On the field
Hours Query.Engineer
I set the criterium
[Which engineer?]

What I want to do is create a variable "CurrentUser" that, instead of

asking

to type in the engineer name fills the current user name in instead of
asking the question [Which Engineer?].

Can I do this and how?

TIA

Henro