Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 23rd, 2006, 08:00 AM
Authorized User
 
Join Date: Dec 2005
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default Date problem

Hi there

I am having a problem where the following coding

NextMonth = DateAdd("m", 1, (date))

works on all computers but one. when the code executes i get the following eror:

Complie error, cant find project or library.
(and highlights the 'date')

Can anyone shed some light as to why this is?

I have tried to test it by using:

Msgbox date and it shows the system date on working PCs

Any help and adive would be most appreciated thanks.

Derek

 
Old June 23rd, 2006, 09:35 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Two possibilities:

The references don't include the library that includes the 'date' reference
'date' needs to be declared explicitly (I believe the syntax is something like VBO.date)

 
Old June 23rd, 2006, 07:00 PM
Authorized User
 
Join Date: Jul 2004
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

open a module or form and view the code, then goto tools/reference on the toolbar - you should see an item checked that says "missing" to the right. Uncheck this library and scroll down to find a similar library.









Similar Threads
Thread Thread Starter Forum Replies Last Post
DATE PROBLEM ricespn Classic ASP Basics 3 October 20th, 2006 07:15 AM
Date Problem. rupen Classic ASP Basics 3 June 3rd, 2005 09:58 AM
Date Problem tdaustin Classic ASP Basics 10 August 13th, 2004 01:43 PM
date problem hosefo81 PHP How-To 2 May 26th, 2004 11:12 AM
Date problem Larson VB How-To 2 December 30th, 2003 06:10 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.