Search results for query: *

Thanks for your help.

Yes, that last construct worked. Do you think that you know why our earlier efforts didn't ? If I learn I can avoid coding that way in the future.

double integer ---- when I go to the Table Design View and select the field GDATE it shows a field size of double which I assumed meant double integer. I changed the field size to long integer and got the same error message. "I would take out the criteria from the last query and set an order...

I inserted the Nz function into qryGDATE1 as directed and I still got the the same error message "Data type mismatch in criteria expression" on execution.

I short circuited the Function so that it always returned "Sunday" and I still got the same error. I believe that the Function is not the problem. Somehow in the WHERE statement Access is not recognising either side of the = sign to be of the same data type. I have tried many different way to...

I agree that your code is more comprehensive than mine but it still gives me the same error message "Data type mismatch in criteria expression" on execution. Actually my database does not have any dates like the examples you gave. My date Field GDATE is either empty (null) or it contains 8...

Sorry but this suggested qryGDATE3 code did not work giving the same error as before "Data type mismatch in criteria expression

I misspoke in my last post. GDATE does not contain null values since qryGDATE1 eliminates the null type dates. GDATE ranges from 19680810 to 20080426.

Are all values in GDATE truly convertable to dates? No, some are null values. Each of these variables is a reserved word. They shouldn't be used as variable names. Good point. Nobody else mentioned that. I have changed them Day to Lday, etc.

If you look further up in my post I did do that and it gives me the error message "Data type mismatch in criteria expression" on execution. Someone on another board suggested that I use the CStr function. It gives the same error message. I included that in my statement so that no-one else would...

...I just want to select all the results that come up with a DOW equal to "Sunday". How can I make this work ? Query - qryGDATE1 SELECT N_League.* FROM N_League WHERE GDATE>0 AND GDATE-10000*INT(GDATE/10000)>0; Query - qryGDATE2 SELECT qryGDATE1.*, FuncWkd(qryGDATE1.GDATE) AS DOW FROM...

Your explanation is inadequate. How do I perform step 1 ? You blithely say : 1. Create your sub form. Try to make sure that your controls and fields related to your main form match exactly. HOW ?????

No, it doesn't !! My Form Wizard NEVER offers me the choice of selecting "Sub-Form". No mention of "Sub-Form" anywhere ! That's my problem. I am running Windows XP Microsoft Office 2003. Make sure "Sub-Form" is selected at the bottom. NO Chance of performing this operation. What's wrong...

Basic question here. I have a main form Projects based on tblProjects. I have a main form Clients based on tblClients. How do I make a subForm for the clients in the form Projects ? Client_Contact is the common field. I know nothing about subForms

Thanks, I figured I was missing an Event Trigger somewhere but I couldn't figure out where ? I was concentrating on the field itself - forgot about the Form detail.

I have the following code in a Form : Private Sub Client_Bldg___Change() Dim Client_No As Variant Dim Client_Addr1 As Variant Dim strCity, strState, strZip, strCrit As Variant If Left(Me.Client_Bldg__, 1) = "1" Then Client_No = 1...

I had to redo the form starting with the wizard. Trying to edit my old form wouldn't work. Now it's working. Thanks. Now my next questions is : What if the Year Filed is NOT on my Form but I still want to update it as above ? There now is no Me.txtYear. "Me." implies that the field is...

Microsoft Access can't find the field Year referred to in your expression. (at Nyear = ) Private Sub txtDate_of_Expense_AfterUpdate() Dim NYear As String Dim INYear As Integer Dim XNyear As Variant NYear = Year(Me.txtDate_of_Expense) 'INYear = NYear 'Me.Year = Year(Me.[Date_of_Expense])...

My Year field is numeric (double integer) Option Compare Database Dim NYear As String Dim INYear As Integer Dim XNyear As Variant Private Sub Date_of_Expense_AfterUpdate() 'XNyear = Year(Me.[Date_of_Expense]) 'INYear = NYear 'Me.Year = Year(Me.[Date_of_Expense]) If...

I get error Type mismatch when I run this . What is wrong ?