Insert into field Tempvar using query

[jaryszek]

Hi,

i am building append query with SQL:

INSERT INTO tb_Main ( Cause, NAZWISKO, IMIE, Pesel, Data_korekty, Login )
SELECT DISTINCT tbl_Export.BLAD, tbl_Export.NAZWISKO, tbl_Export.IMIE, tbl_Export.Nr_dokumentu, tbl_Export.krzyzyki, [ZmienneTymczasowe]!Username AS Login
FROM tbl_Export
WHERE (((IsNull([tbl_Export].[Nr_dokumentu]))=False));

This is working ok excluding [Tempvars]!Username...

How should i write in?

Best Wishes,
Jacek

[ranman256]

dont know where the temp var is coming from,
but I have my username on the form (invisible) when the form opens.

txtUser = Environ("Username")

then I can run queries off that:
select forms!myForm!txtUser from table....

[jaryszek]

Thank you ranman256!

Hmm temvar is coming from login form.

I can use txbox with tempvar like you but there is no possible to write an expression within QUery?

Jacek

[aytee111]

I agree with ranman, I always have the user information on the main form, then I can refer to it whenever I need it on forms/queries/reports.

[NoellaG]

Hi, you can use it without putting it on a form creating this simple function in VBA:

Public Function GetUsername() As String
GetUsername = Environ("username")
End Function

In your query you can use the function Getusername() in a similar way as you do with the date() function

[jaryszek]

Thank you Guys,

NoellaG solution is working !!

Best Wishes,
Jacek

[aytee111]

Yes, that was a good solution. Just a warning, however, functions in queries are very slow so if you have more than 100 records the query will take a long time to run. Remember that for future functions.

[jaryszek]

Thank you aytee111,

so if i will use tempvars in my query it could also make my queries slower.
So the best approach will be using reference to a form i think...

Thank you Guys,
Best wishes,
Jacek