Search results

Yes sorry - it was a while ago and I knew I added something into the sql string. Thinking about it I made a table so sqlstr="select xyd into tempTable from tblname" docmd.runsql sqlstr docmd.OpenTable "TempTable"

Hopefully this will work for you. Go to Control Panels, Region and choose MM/dd/yyyy for Short Date Make a new module called ShortDateSetting Paste the following code into the new module. Option Compare Database Option Explicit Public Const LOCALE_SSHORTDATE = &H1F Public Declare PtrSafe...

Add a WHERE string - I know you don't need one but without it won't be recognized as a SQL