syntex error in date

[aman1234]

Hi Guys

The following line gives me the Syntext error message in date in query expression. I think I am using wrong date fomat. But the Scandate in table is stored in yyyymmdd format. e.g 20140624

the combobox1 stored Day (DD)
combobox2 stores month (MM)
combobox3 stores Year (YYYY)

Please Login or Register  to view this content.

Thanks

[Norie]

There should be no spaces after the #.

Also, you might want to reconsider the format you are using for the date, try yyyy-mm-dd.

[romperstomper]

That's probably not a real date value, so you don't need # in there and your order is wrong (should be yyyymmdd not ddmmyyyy).

[aman1234]

Again the same error message guys. i made the following change:

Please Login or Register  to view this content.

[aman1234]

And also I just noticed that in the table the Scandate has number data type. I thought it was date . So can you please make the changes accordingly please.

Thanks

[romperstomper]

You didn't make any of the changes I mentioned.

[Norie]

There should be no space before or after #.

Try this.

Please Login or Register  to view this content.

[aman1234]

Thanks romperstomper, i am writing the following lines of code but they don't copy any data from Access to Excelsheet.

Please Login or Register  to view this content.

[romperstomper]

There isn't any code there to copy any data anywhere, so I'm not particularly surprised by that. You also haven't changed the date format as I suggested.

[aman1234]

Hi guys

I am writing this code but its not working. Scandate has number data type.

Please Login or Register  to view this content.

[Norie]

j should be outside the quotes.

[aman1234]

Norie, its giving me runtime error 6 Overflow at following

Please Login or Register  to view this content.

[Norie]

You don't need Val, actually you don't need j.

Please Login or Register  to view this content.

[aman1234]

Thanks Norie and romperstomper I changed the data type of J from Integer to long and it started working.

Thanks