ChrisM@Work,

I know how to do it. I didn't say it could not be accomplished some other way.

My original post said that an alias cannot be referred to in a...

Just a clarificaton:

An alias for a calcuated column can be used in GROUP BY or ORDER BY clauses, but not in the SELECT column list as vega805 was attempting (at...

I stand corrected...and pleased that the functionality does exist.

Thanks.

Access lets you define a calculated column in a query and then use the calculated column name in other calculated columns. SQL Server will not allow this. In...

DECLARE @Tol1 AS INT

, @Tol2 AS INT

, @Trig AS INT

, @car...

Use CTEs to eliminate subselects and make your code more readable (the view is also eliminated by the first cte):

WITH cte_tables (zCardNo, zDate, zDatetime1, zChannel_no)

AS ( SELECT cardno, CONVERT(DATE, datetime1),...

-----------------------------

-- The following returns what you asked for (but may not be what you want):

-----------------------------

SELECT Cust_No_A

,Cust_Name_A

,Cust_Address_A

,Cust_City_A

,Cust_State_A

,Cust_Zip_A

,NULL AS Cust_No_B

,NULL AS Cust_Name_B

,NULL AS Cust_Address_B

,NULL AS Cust_City_B...

The simplest solution is to split the Contains() into two Contains():

WHERE

(

(Contains(r_resume_text,'"FirstWord" OR "SecondWord"'))

...

I can't help you get the line of code to execute, since I cannot debug it myself.

The reason CurrentUser() returns Admin is that CurrentUser() is returning the Access security user,...

You haven't indicated that the line of code:

Me.txtUserID = Environ("UserName")

is executing. You will have to figure that out.

I would take out the line:

On Error Resume Next

Also, set...

If your form is "bound" to a recordsource (table or view), the textbox's control source would be the name of the column in the recordsource that will receive the value....

My appologies. The function to return the logged in user is:

Environ("USERNAME") not "UserID"

It is in the right place.

I'm not sure why you have an On Error Resume Next.

Set a breakpoint in the code on the Me.txtUserID = Environ("USERNAME") by clicking on that...

Assuming your New Button name is "cmdNew" and your UserID Textbox Name is "txtUserID":

In the cmdNew_Click event, after the recordset is placed on the new record, add the code:

Me.txtUserID =...

Within Access you can use the Environ("UserName") function to get the user that is logged into Windows.

The suser_sname() may return the Domain/UserID if using Windows authentication.