 |
28-Jul-2006, 08:12 AM
|  | Guest | | | | | | | | | | Access 2003 switchboard
I have an access 2k3 app that I distribute in runtime. Whne I install it on
a machine with windows 2000 Pro (SP3) when I click on any switchboard item, I
get the following message:
"The expression OnClick you entered as the event property setting produced Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10356-access-2003-switchboard.html
the following error: the expression you entered has a function name that
microsoft access can't find" The onClick function is "=HandleButtonClick(1)" Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10356
Any ides on what the problem is?
TIA
Phil * Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh! |
28-Jul-2006, 08:12 AM
| | Guest | | | | | | | | | | Re: Access 2003 switchboard
As you probably know, HandleButtonClick() is part of the code generated by
the switchboard wizard. The fact that it fails suggests that there is a
problem with the database. That could be a Name AutoCorrect fault (failure
to recognise names), or it could be a compilation problem that a Decompile
would fix (since the A2003 binary is different from the A2000 binary.)
Suggested sequence:
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why: http://allenbrowne.com/bug-03.html
2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact
3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes: Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10356
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
4. Open Access, and compact again.
5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see: http://allenbrowne.com/ser-38.html
6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.
--
Allen Browne - Microsoft MVP. Perth, Western Australia. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10356
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"philster" wrote in message
news:B4283352-9EDB-4538-BAC5-F4A51DA09129@microsoft.com...
>I have an access 2k3 app that I distribute in runtime. Whne I install it
>on
> a machine with windows 2000 Pro (SP3) when I click on any switchboard
> item, I
> get the following message:
>
> "The expression OnClick 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 onClick function is
> "=HandleButtonClick(1)"
>
> Any ides on what the problem is?
>
> TIA
>
> Phil
 |
28-Jul-2006, 08:14 AM
| | Guest | | | | | | | | | | Re: Access 2003 switchboard
Alllen,
Thank you for your detailed resonse. Unfortunately, this did not reslove
my issue. I found MS article 827490 which describes a similar problem if
access 2003 runtime is installed and then removed. This is in reference to
access 2002. This is a test machine that Installed the app on. In order to
install the next version, I had to remove the first installation. Since
then, subsequent installations produce the error. The test machine did not
have a previos version of Access installed - just the 2003 RT.
Thanks,
Phil
"Allen Browne" wrote:
> As you probably know, HandleButtonClick() is part of the code generated by
> the switchboard wizard. The fact that it fails suggests that there is a
> problem with the database. That could be a Name AutoCorrect fault (failure
> to recognise names), or it could be a compilation problem that a Decompile
> would fix (since the A2003 binary is different from the A2000 binary.)
>
> Suggested sequence:
> 1. Uncheck the boxes under:
> Tools | Options | General | Name AutoCorrect
> Explanation of why:
> http://allenbrowne.com/bug-03.html
>
> 2. Compact the database to get rid of this junk:
> Tools | Database Utilities | Compact
>
> 3. Close Access. Make a backup copy of the file. Decompile the database by
> entering something like this at the command prompt while Access is not
> running. It is all one line, and include the quotes:
> "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
> "c:\MyPath\MyDatabase.mdb"
>
> 4. Open Access, and compact again.
>
> 5. Open a code window.
> Choose References from the Tools menu.
> Uncheck any references you do not need.
> For a list of the ones you typically need in your version of Access, see:
> http://allenbrowne.com/ser-38.html
>
> 6. Still in the code window, choose Compile from the Debug menu.
> Fix any errors, and repeat until it compiles okay.
>
> --
> 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.
>
> "philster" wrote in message
> news:B4283352-9EDB-4538-BAC5-F4A51DA09129@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10356
> >I have an access 2k3 app that I distribute in runtime. Whne I install it
> >on
> > a machine with windows 2000 Pro (SP3) when I click on any switchboard
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10356
> > item, I
> > get the following message:
> >
> > "The expression OnClick 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 onClick function is
> > "=HandleButtonClick(1)"
> >
> > Any ides on what the problem is?
> >
> > TIA
> >
> > Phil
>
>
> |
28-Jul-2006, 08:14 AM
| | Guest | | | | | | | | | | Re: Access 2003 switchboard
Are you certain there are no broken references, or other issues with that
machine?
If not, you could export the form with the undocumented SaveAsText, delete
it, compact, and then import it using LoadFromText. The syntax looks like Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10356
this:
SaveAsText acForm, "Form1", "C:\Form1.txt"
LoadFromText acForm, "Form1", "C:\Form1.txt"
No guarantees.
If that does not solve it either, could it have to do with permissions?
Sandbox mode? Local computer administrator?
Not sure what else to suggest.
--
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.
"philster" wrote in message
news:42702A68-81DD-4EC4-99DD-665442814C60@microsoft.com...
> Alllen,
>
> Thank you for your detailed resonse. Unfortunately, this did not reslove
> my issue. I found MS article 827490 which describes a similar problem if
> access 2003 runtime is installed and then removed. This is in reference
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10356
> to
> access 2002. This is a test machine that Installed the app on. In order
> to
> install the next version, I had to remove the first installation. Since
> then, subsequent installations produce the error. The test machine did
> not
> have a previos version of Access installed - just the 2003 RT.
>
> Thanks,
> Phil
>
> "Allen Browne" wrote:
>
>> As you probably know, HandleButtonClick() is part of the code generated
>> by
>> the switchboard wizard. The fact that it fails suggests that there is a
>> problem with the database. That could be a Name AutoCorrect fault
>> (failure
>> to recognise names), or it could be a compilation problem that a
>> Decompile
>> would fix (since the A2003 binary is different from the A2000 binary.)
>>
>> Suggested sequence:
>> 1. Uncheck the boxes under:
>> Tools | Options | General | Name AutoCorrect
>> Explanation of why:
>> http://allenbrowne.com/bug-03.html
>>
>> 2. Compact the database to get rid of this junk:
>> Tools | Database Utilities | Compact
>>
>> 3. Close Access. Make a backup copy of the file. Decompile the database
>> by
>> entering something like this at the command prompt while Access is not
>> running. It is all one line, and include the quotes:
>> "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
>> "c:\MyPath\MyDatabase.mdb"
>>
>> 4. Open Access, and compact again.
>>
>> 5. Open a code window.
>> Choose References from the Tools menu.
>> Uncheck any references you do not need.
>> For a list of the ones you typically need in your version of Access, see:
>> http://allenbrowne.com/ser-38.html
>>
>> 6. Still in the code window, choose Compile from the Debug menu.
>> Fix any errors, and repeat until it compiles okay.
>>
>> "philster" wrote in message
>> news:B4283352-9EDB-4538-BAC5-F4A51DA09129@microsoft.com...
>> >I have an access 2k3 app that I distribute in runtime. Whne I install
>> >it
>> >on
>> > a machine with windows 2000 Pro (SP3) when I click on any switchboard
>> > item, I
>> > get the following message:
>> >
>> > "The expression OnClick 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 onClick function is
>> > "=HandleButtonClick(1)"
|
28-Jul-2006, 08:14 AM
| | Guest | | | | | | | | | | Re: Access 2003 switchboard
Allen,
You guessed it this time!! Thanks!! I had created a registry entry for
sandboxmode = 3 to surpress some dialogue boxes for Win XP . This causes the
error in Win 2K. Good news is that with the registry entry removed I don't
get the dialogues in Win 2K.
Phil
"Allen Browne" wrote:
> Are you certain there are no broken references, or other issues with that
> machine?
>
> If not, you could export the form with the undocumented SaveAsText, delete
> it, compact, and then import it using LoadFromText. The syntax looks like
> this:
> SaveAsText acForm, "Form1", "C:\Form1.txt"
> LoadFromText acForm, "Form1", "C:\Form1.txt"
> No guarantees.
>
> If that does not solve it either, could it have to do with permissions?
> Sandbox mode? Local computer administrator?
>
> Not sure what else to suggest.
>
> --
> 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.
>
> "philster" wrote in message
> news:42702A68-81DD-4EC4-99DD-665442814C60@microsoft.com...
> > Alllen,
> >
> > Thank you for your detailed resonse. Unfortunately, this did not reslove
> > my issue. I found MS article 827490 which describes a similar problem if
> > access 2003 runtime is installed and then removed. This is in reference
> > to
> > access 2002. This is a test machine that Installed the app on. In order
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10356
> > to
> > install the next version, I had to remove the first installation. Since
> > then, subsequent installations produce the error. The test machine did
> > not
> > have a previos version of Access installed - just the 2003 RT.
> >
> > Thanks,
> > Phil
> >
> > "Allen Browne" wrote:
> >
> >> As you probably know, HandleButtonClick() is part of the code generated
> >> by
> >> the switchboard wizard. The fact that it fails suggests that there is a
> >> problem with the database. That could be a Name AutoCorrect fault
> >> (failure
> >> to recognise names), or it could be a compilation problem that a
> >> Decompile
> >> would fix (since the A2003 binary is different from the A2000 binary.)
> >>
> >> Suggested sequence:
> >> 1. Uncheck the boxes under:
> >> Tools | Options | General | Name AutoCorrect
> >> Explanation of why:
> >> http://allenbrowne.com/bug-03.html
> >>
> >> 2. Compact the database to get rid of this junk:
> >> Tools | Database Utilities | Compact
> >>
> >> 3. Close Access. Make a backup copy of the file. Decompile the database
> >> by
> >> entering something like this at the command prompt while Access is not
> >> running. It is all one line, and include the quotes:
> >> "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
> >> "c:\MyPath\MyDatabase.mdb"
> >>
> >> 4. Open Access, and compact again.
> >>
> >> 5. Open a code window.
> >> Choose References from the Tools menu.
> >> Uncheck any references you do not need.
> >> For a list of the ones you typically need in your version of Access, see:
> >> http://allenbrowne.com/ser-38.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10356
> >>
> >> 6. Still in the code window, choose Compile from the Debug menu.
> >> Fix any errors, and repeat until it compiles okay.
> >>
> >> "philster" wrote in message
> >> news:B4283352-9EDB-4538-BAC5-F4A51DA09129@microsoft.com...
> >> >I have an access 2k3 app that I distribute in runtime. Whne I install
> >> >it
> >> >on
> >> > a machine with windows 2000 Pro (SP3) when I click on any switchboard
> >> > item, I
> >> > get the following message:
> >> >
> >> > "The expression OnClick 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 onClick function is
> >> > "=HandleButtonClick(1)"
>
>
> | 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Active Discussions | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
