Re: [MS_AccessPros] Now() and Date() crashing

 

... or code not compiling or not saving it after it does (tip: turn off Compile on Demand and make sure you always do this).

If code compiles ok, close and back then decompile, compile, and compact/repair

if error still persists, perhaps one of the report control sources is not valid?

~ crystal

On 8/3/17 8:52 PM, 'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals] wrote:

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: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___