473,387 Members | 1,520 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

date function in access97

Hi,

I have an access application that uses the code:
Me!txtCreationDate = Format(Date, "Long Date") & " " & Format(Time, "hh:mm:ss")


This works fine under access 2000 and access97 on Windows 98 but, when
run on access97 under windows NT4, it crashes with an 'object not
found' message.

Anybody got any ideas

Thanks,
Paul
Nov 12 '05 #1
1 3067
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You don't have the necessary Reference on the NT machine.

Open a VBA module.
Click Tools in the menu bar.
Select References in the menu.
Look for a MISSING reference - uncheck it.
If no MISSING reference is there - make sure the correct VBA
references are checked.

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP5cN5IechKqOuFEgEQKm9ACeJ7p8IizYkhFv71ngyU8ip4 qzlUAAn0A7
DaRKGgpruImfv3WsSbGDTXWZ
=pZSO
-----END PGP SIGNATURE-----

Internet Arrow Limited wrote:
Hi,

I have an access application that uses the code:

Me!txtCreationDate = Format(Date, "Long Date") & " " & Format(Time, "hh:mm:ss")

This works fine under access 2000 and access97 on Windows 98 but, when
run on access97 under windows NT4, it crashes with an 'object not
found' message.

Anybody got any ideas

Thanks,
Paul


Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: SnowsAngel | last post by:
Hi Everyone, I am a newbie to this forum but am at my wits end. I have a problem with Dates in Access. It is happening in two seperate applications. I am in Australia and need to have...
3
by: JMCN | last post by:
Can anyone give me some direction on how to return values without the "/" since access imports the "7/1/2003" with the "/". in my query i tried: date: (DatePart("mmddyyy",)) but i received...
1
by: DD | last post by:
I have a mainform with a subform. The main form as a dropdown box "chooseDate", in the afterupdate event i requery the subform so all records with the same date are viewed. Now i only want to...
1
by: Mario Crevits | last post by:
My name is Mario Crevits, I'm from Belgium (Roeselare) and I'm working with Access97 for several years now. We are in an Access97-2000 migration project. I'm writing a wizard for the end-users to...
2
by: Terry | last post by:
I have a database that I would like to query for a specific date range. I want to create a report based on this query that will pull any records from the last 7 days. Is this possible? Can...
3
by: JingleBEV | last post by:
Hi all, I have a masked text control that would return a date in string format via the mask property like: "9/23/2004" and i have a calendar control that would pop up when I click a command...
3
by: arthur-e | last post by:
A new Machine was set up by our IS department - it came with Office Pro 2003. Access97, Word97 and Excel 97 were added. I'm trying to update an Access 97database to 2003 but get weird compiling...
1
by: IamKJVonly | last post by:
I have office 97 which includes access97 and have built many access97 databases and use VB4 as the front end. I have just gotten a new computer which has 1 gig of memory on it and when I try to...
3
by: Ramchandar | last post by:
Hi, I am creating reports using VBA code. I have the same query in a querydef residing both in Access97 and Access2003. The result of this querydef is then moved to a table in Access97 and...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.