Recent content by KavJack

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...

My query qryGDATE3 won't work. I get message "Data type mismatch in criteria expression" on execution. qryGDATE2 does work correctly. 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...

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.