date function in access97

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Internet Arrow Limited

    #1

    date function in access97

    Hi,

    I have an access application that uses the code:
    [color=blue]
    > Me!txtCreationD ate = 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

    #2
    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/AwUBP5cN5IechKq OuFEgEQKm9ACeJ7 p8IizYkhFv71ngy U8ip4qzlUAAn0A7
    DaRKGgpruImfv3W sSbGDTXWZ
    =pZSO
    -----END PGP SIGNATURE-----

    Internet Arrow Limited wrote:
    [color=blue]
    > Hi,
    >
    > I have an access application that uses the code:
    >
    >[color=green]
    >>Me!txtCreatio nDate = 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]

    Comment

    Working...