NumbersMax
Board Regular
- Joined
- Jun 19, 2007
- Messages
- 200
All,
I'm running Access 2003/Window XP. I have a query that I run every Monday that has suddenly stopped running. I've narrowed the problem to the date criteria. I'm converting the date-formatted begin and end dates using Format() to text like "yyyymmdd" so that it matches the date field in our mainframe. This query and many others like it have been working for over a year now. The criteria looks like this:
Between Format([Forms]![Main Form]![BeginDate],"yyyymmdd") And Format([Forms]![Main Form]![EndDate],"yyyymmdd")
Let me emphasize that NO changes have been made to the form date fields or query design. The one major change I can think of is the set up Windows Updates I ran before I left work on Friday.
The reason I believe it could be the windows updates is because I tried to use the very same Between, Format, And statements on my computer to help someone else a week or so ago...it ran on my computer fine, but refused to run on his.
Can anyone confirm whether a windows update could cause this problem? Does anyone know of a possible correction to the problem that won't require finding/rewriting all the queries I have like this to ask for the date already in the text field...I already know one way to make that work:
Between [enter begin date like yyyymmdd] And [enter end date like yyyymmdd]
Thanks in advance for your advice,
Max
I'm running Access 2003/Window XP. I have a query that I run every Monday that has suddenly stopped running. I've narrowed the problem to the date criteria. I'm converting the date-formatted begin and end dates using Format() to text like "yyyymmdd" so that it matches the date field in our mainframe. This query and many others like it have been working for over a year now. The criteria looks like this:
Between Format([Forms]![Main Form]![BeginDate],"yyyymmdd") And Format([Forms]![Main Form]![EndDate],"yyyymmdd")
Let me emphasize that NO changes have been made to the form date fields or query design. The one major change I can think of is the set up Windows Updates I ran before I left work on Friday.
The reason I believe it could be the windows updates is because I tried to use the very same Between, Format, And statements on my computer to help someone else a week or so ago...it ran on my computer fine, but refused to run on his.
Can anyone confirm whether a windows update could cause this problem? Does anyone know of a possible correction to the problem that won't require finding/rewriting all the queries I have like this to ask for the date already in the text field...I already know one way to make that work:
Between [enter begin date like yyyymmdd] And [enter end date like yyyymmdd]
Thanks in advance for your advice,
Max