Passing dates from Access to SQL

[Tallboy]

Hi Guys,

I have my ADO code up and working and am calling stored proc so it all good.

But one problem I have hit on that I haven't been able to find a solution too it as follows;

I want to pass a date into my sql server tables from Access.

If I use an 'InputBox' in Access, it works great the record is stored with the date no problem.

If I use a txt box on a form in Access, I don't get any errors, but the record is just not added!

Can anyone throw any light on this?

Regards

 

[AccessBlaster]

Is your input form bound to a table?

 

[Galaxiom]

You have not given us much to go on but here is one common cause for this kind of thing.

The text does not become the Value property of the textbox until you move the focus out of the textbox. Until then it is only accessible as the Text property.

 

[mdlueck]

I was having trouble passing dates to SQL Server for storage. I found the solution to what was the trouble and posted the answer here:

http://www.access-programmers.co.uk/forums/showthread.php?p=1104450#post1104450