Answer my 2 questions please!!

[claudz_08]

Hi i have two questions that needs some answers.

1. I want to put in my form the name of the user who is logged in the pc. for example, i am logged in my pc so therefore the name that appears on the txtbox of my form would be claudz. How do i do this? what should be the sql statement to be put in the textbox?

2. Is it possible to put a subreport on a form? i mean instead of a subform on a form it would be a report. I could do this because the only choices that are given when making a subform are tables and queries. no report. please help.

thanks.

 

[ColinEssex]

Do a search for the answer to question 1. This has been covered many times.
Col

 

[IMO]

The answer to Question 2...
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51078

IMO

 

[Hayley Baxter]

You can find an example on how to get the current NT user in this thread

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30421