Jim – The number one cause of internal function failures is a mismatch with the DAO library. Open your VBA editor. Click on Tools>References and check for any marked MISSING. Uncheck the MISSING library and find the lowest level library in your list and select it.
While the problem stems from many possible sources fixing that should make everything else work.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, August 03, 2017 1:00 PM
To: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Now() and Date() crashing
It works today. I did compile it to make sure. Not sure why it would do that.
Thank You
Jim Wagner
On Thursday, August 03, 2017 11:43:35 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Jim,
Have you attempted to compile your code?
What happens if you open the debug window (press Ctrl+G) and enter
? Now()
Regards,
Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, August 3, 2017 1:24 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Now() and Date() crashing
Hello all,
Yesterday a report I created as a copy of another one, was giving me an error on the =Now() in the footer of the report. I tried to use Date() and it said on both that it could not find that function. the user received a windows update the day before. is there something that is wrong with the database or the function?
Thank You
Jim Wagner
Posted by: "Bill Mosca" <wrmosca@comcast.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar