Recent content by bnd_ck

@Pr2 that's spot on..it worked. i have many more report calling in the program,all had similar issue.you saved my time..thumbs up:):):):):):) keep it up good work

debug gives me this run time error 3075 syntax error in date in query expression '(([startdato]<=#26.08.2014# AND [sluttdato]>=14.07.2014#) both dates appear are user inputs via form(dt picker date control)

@pre2 other dates straight away getting from query. this is the date only input

this my code part with your last suggestion format & replace Set db = CurrentDb() Set rs = db.OpenRecordset("qry_plan_workorders_for_report") ' delete all recs in temp table DoCmd.SetWarnings False DoCmd.RunSQL "DELETE * FROM tblTempPlan" DoCmd.SetWarnings True Do...

many thanks pre2 same error run time error 3075, syntax error in date query expression '#11.07.2014' :confused: NOTE: user enter this date via date picker control.(short date format)

thanks, but same error run time error 3075, syntax error in date in query expression.

thanks, i want to store it using SQL Inser command INSERT INTO tb1(field1,field2,,,,) VALUES (" & var1 & ", #" & userdate & "#,,,,) that user date giving me syntax error cuz user enterd date as "dd.mm.yyyy"format . i tried sql format function. but no luck. how do i do it?..

I am access vba developer. my client uses european system date in his computers. he doesnt want to change his date settings(dd.mm.yyyy). i am facing problem now inserting Date fields to access tables since it uses US date format "dd/mm/yyyy". giving me run time error in insertion. is there any...