Hi please check below query.

"INSERT INTO Utilization (OnDate,UserID,Completed,StartTime,EndTime,Priorit yID_FKey,EventID_FKey) VALUES (#07/27/2007#,'ranjaria','No','07/27/2007 12:21:23 PM',NULL,1,42)"
--------------

It gives error as "Data type mismatch in criteria expression"
I did figure it out as it has problem with "Now()" i have used in query. (which is in single quote see actua query as below:

"INSERT INTO Utilization (OnDate,UserID,Completed,StartTime,EndTime,Priorit yID_FKey,EventID_FKey)" & " VALUES (#" & txt_date.Value & "#,'" & GetLoggedInUserName() & "','No'" & ",'" & Now() & "'," & "NULL," & cmb_priority.Value & "," & cmb_events.Value & ")")


Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.

Hi Rupen,


Just a couple of pointers. Things like this are hard to debug because its all clumped together..

Try breaking out the code above so each part is assigned to a variable, and then
generate the SQL based on these variables. This will allow you to step through
and see what each Item is actually ending up to be.. You will eventually hit
one that is the wrong type!

Good luck, please come back if you still have problems.

Rob


<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>

Hi Rob,

I tried to debug the statement, also copied the entire statement from debug windoe to MS Access Query designer and executed over there, to my surprise it didn't give any error to me. It gives error at VBA level.

I suspect it has problem while storing Now() value.

Please help!!

Thanks,



Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.

Rupen,

OK, would be very helpful for me if you could post your code and actually tell
me what the error is.. ;) :)

Regards,
Rob

<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>

Hi Rob,

Thank your for help, but it was 'No', which was problemetic, In table design it was Yes/No field and hence can't give in ''.

That's all.

Thanks,

Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.

No Problem, glad we got there in the end!

<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>