Search results

Gosh, I didn't even check what version he is on, I send him 2013 so it must be that or higher. Altho this issue existed in 2010. I did watch what he was doing and that is all he did, used the date-picker.

Drat. I wonder what can be causing it. You have all been great, many thanks to all for taking the time to help with this.

The link in post # 5 describes the problem exactly, in case I haven't.

The error happens only on the right-click > filter > between. Then using the date-picker to select dates. This was a QND - quick and dirty - to provide a way to see the error. Certainly not a database I would give to a user! User wants to track time between steps, last step completion carries...

The culprit is the project start date.

This is Access 2013, Windows 10, 64bit. I am also on US format and it works fine for me, even when I change my date and time settings on my computer. static, not sure what you are telling me to try: "That might tell you if the date picker is returning day month in the wrong order at least." how...

That is exactly the issue, many thanks for the link. Seems that it is an Access bug as there was no solution.

The format is on the form, purely to remove the time as it isn't needed, and is Short Date, not forcing a format. This should come from the Windows settings. Is it this that is causing the problem?

I am in the USA and use m/d/y format for short date, dealing with someone in Europe with d/m/y. - date field is stored on a table in Date/Time datatype (includes the time) - continuous form showing all records including date in Short Date format - user right-clicks on date, selects Filter >...

Solved by changing this line: From: Set dbs=OpenDatabase("databasename") To: Set dbs=DBEngine.Workspaces(0).OpenDatabase("databasename")

I had tried putting it in after the Close (step 3) but that didn't help. What do you mean by "relevant places"? I have to admit to not fully understanding the way Access exits to the operating system and comes back.

(Access 2003) The code: 1-open another database 2-for a specified query (name supplied) for each fld in qfd.fields write a record to a local table 3-close database 4-create query based on local table 5-RefreshDatabaseWindow 6-open form with query as record source The code...

Put the tablename in the front - [tablea].[fieldx] - [tablea].[fieldy]