Connecting Tech Pros Worldwide Forums | Help | Site Map

date function in access97

Internet Arrow Limited
Guest
 
Posts: n/a
#1: Nov 12 '05
Hi,

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

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

MGFoster
Guest
 
Posts: n/a
#2: Nov 12 '05

re: date function in access97


-----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:
[color=blue]
> Hi,
>
> I have an access application that uses the code:
>
>[color=green]
>>Me!txtCreationDate = Format(Date, "Long Date") & " " & Format(Time, "hh:mm:ss")[/color]
>
>
> 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[/color]

Closed Thread