Search results for query: *

Duane, I just downloaded a fresh copy of the program and when I ran it, I had the same errors. I must have a problem with my Access2000 installation. Thanks for all of your help. Bill

Duane, The name of the query, in my original post,is Q_A. Thanks, Bill

Duane, (Duane) Did the first SQL you posted have spelling errors as I asked earlier? (Bill) No it did not have any spelling errors. (Duane) Did you try to debug your code? (Bill) I tryed to run it in the intermediat window but nothing happened. When I compile the code it checked out ok...

Sorry Duane, I did not know about sending files. CboMn and cboYr are combo boxes. The SQL listed above is used in other querys. Here is a short query that also does not work: Q_LookUpMonth SELECT T_Month.MonthNum AS Mn, MonthName([MonthNum],True) AS MName FROM T_Month ORDER BY...

Duane, I am sending an attachment, by email, of the Access program that I am trying to use. When I run the program it deletes the T_TempTaskPlan table. I made a copy of this table and named it T_TempTaskPlanOrg. If it runs OK for you, I may have a problem with my Access2000 installation...

Thanks Duane, WeekdayName is in the third line of the SQL. I tried your suggestion, in the intermediate window, and it worked OK. I will try re-writing the SQL and see how it works. Thanks, Bill

I am trying to use WeekdayName in a cross tab query. It causes an error. I am looking for a work-a-round for this. The following statement is from the MS Access2000 Knowledge base: "When you use one of the new Visual Basic for Applications functions as an expression, you may receive the #Name...