Try creating a new blank database and importing all the objects from the old one.
John
-----Original Message-----
From: toukey1
Sent: 23 Mar 2012 17:00:08 GMT
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Assistance with database
I did a compact and repair on the machine with Access 2007 when I first noticed the problem.
Toukey
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> What happens if you compact / repair? (Make a backup first!)
>
> John
>
> -----Original Message-----
>
> From: toukey1
> Sent: 23 Mar 2012 16:34:14 GMT
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Assistance with database
>
> Hey John,
>
> No missing libraries. The following are the libraries that are checked:
>
> . Visual Basic For Applications
> . Microsoft Access 12.0 Object Library
> . OLE Automation
> . Microsoft ActiveX Data Object 2.1 Library
> . Microsoft DAO 3.6 Object Library
>
> Regards
> Toukey
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Toukey -
> >
> > When you open the VB editor, choose References from the Tools menu. Do you see any library marked missing?
> >
> > John Viescas
> > (Luxembourg)
> >
> > -----Original Message-----
> >
> > From: toukey1
> > Sent: 23 Mar 2012 13:22:22 GMT
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] Assistance with database
> >
> > Hi John,
> >
> > Hi tried that but same thing. I also notice that if I go into an Event Procedure there is no code, it's blank!
> >
> > Any other ideas?
> >
> > Toukey
> >
> > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> > >
> > > Toukey-
> > >
> > > Sounds like you are missing one or more VBA libraries on your machine. Open the VBA editor and do a compile.
> > >
> > > John Viescas
> > > (Luxembourg)
> > >
> > > -----Original Message-----
> > >
> > > From: toukey1
> > > Sent: 23 Mar 2012 02:22:13 GMT
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Assistance with database
> > >
> > > Hi,
> > >
> > > I developed a database using windows XP 32-bit and MS Access 2003. I am trying to open the database on the network using a machine that's running Windows 7 Home Basic SP1 64-bit and MS Access 2007. When the database opens and I click a button on the switchboard, I am getting the following error:
> > >
> > > The expression On Click you entered as the event property setting produced the following error:
> > >
> > > The expression you entered has a function name that Microsoft Access can't find
> > > * The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
> > > * There may have been an error evaluation the function, event, or macro.
> > >
> > > I have added the location to the Trusted site but still no success.
> > >
> > > Any solutions?
> > >
> > > Regards
> > > Toukey
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar