Re: The "date" and the "visible" functions don't work

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thank you for your response. Unfortuanetly I did not find the word MISSING
when I looked at the References.

Here is my code for date. You can see it is very simple.

Private Sub DateLastUpdated_DblClick(Cancel As Integer)

Dim DateLastUpdated As String
DateLastUpdated = Date

End Sub

I am not getting a message now for the Date problem, but when I double click
on the field, nothing happens.

Regarding the "visible" problem, I get the following message (no number)

You entered an expression that has an invalid reference to the property
Visible.
The property may not exist or may not apply to the object you specified.

It is like neither of these functions exists - I've used them before in
Access 97, but my version of 2003 can't seem to find them. I know you can
use visible when creating a popup to select report criteria.

Do you have any more ideas?

thanks,
Etta M.






"Allen Browne" wrote:

> Welcome to the world of Access. :-)
>
> If this is a new setup, I'm guessing you have a missing reference.
> From the code window, choose References on the Tools menu.
> Look for any checked box with "MISSING" beside it.
> More on references:
> http://allenbrowne.com/ser-38.html
>
> There are some contexts where Visible does not show in the enumerated list
> while you code. Can't tell if that applies to you without more details.
>
> When you get an error message, it helps us identify the issue if you include
> the error number/message in your post.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "ettam" <ettam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:3294DDFB-11B0-4FD3-BAF9-C6A0BC85581C@xxxxxxxxxxxxxxxx
> >I have two problems that are probably related. I have just gotten my own
> > Access DB software. When I try and use the Date() function (or just Date)
> > in
> > VB code, I get an error message. The same thing happens when I use
> > "visible"
> > when creating a input parameter popup form and I enter the word "visible"
> > in
> > the SetValue action Item (it's not in the drop down list but it should
> > be).
>
>
>
.

Relevant Pages

  • Re: unknown function name in query expression
    ... >>I'm getting an error message when running a query that uses the NOW ... > This appears to be the very common References bug. ... Uncheck it, recheck it, close and open Access. ... > If none are MISSING, check any reference; ...
    (microsoft.public.access.queries)
  • Re: Undefined function Left in expression
    ... > I'm getting a weird error message and I don't know when the problem started ... My database is just a contact ... The arch-nemesis of Access is missing references. ...
    (microsoft.public.access.reports)
  • Re: How to display only 3 letters of a last name in field
    ... tried it just now and I am getting an error message "Undefined function ... This appears to be the very common References bug. ... Uncheck it, recheck it, close and open Access. ... If none are MISSING, check any reference; ...
    (microsoft.public.access.queries)
  • Re: How often to things crawl out of the sea?
    ... (all John's references are places where Scripture is referencing other ... KJV, and they're all there, Tobit and Maccabees and the others. ... really missing or are they simply excluded by the dictates (arbitrary ... Plenty of lots of ancient books are, ...
    (talk.origins)
  • Re: Help with DCount
    ... Klatuu wrote: ... There's nothing there that I can see thats marked Missing. ... References and see if any are marked *Missing* ... I got an error message up earlier about the Yearfunction I was ...
    (microsoft.public.access.formscoding)