WEIRD ERROR AT REFRESHING DATA DISPLAYED IN AN ACCESS FORM

  • Thread starter Thread starter Geo
  • Start date Start date
G

Geo

In a form wich displayes the data from a query, I use a command button to
refresh the displayed data after modifies. The command button execute a
macro :
requery (with no arguments) + show all records
It was aorking, but from last week, when I try to use that refresh button
more than once, I get the next 2 CONSECUTIVE ERROR MESSAGES:
-UNKNOW FUNCTION NAME
- OBJECT INVALID OR NO LONGER SET

Can you,please, help me?
 
Create a blank db.
Import everything to the new one.
save it with a temporal name.
delete the original one (or rename it)
rename the just created db to its original name.
....and try.

Thanks,

German Saer
(e-mail address removed)
Orlando, FL
 
Geo said:
In a form wich displayes the data from a query, I use a command button to
refresh the displayed data after modifies. The command button execute a
macro :
requery (with no arguments) + show all records
It was aorking, but from last week, when I try to use that refresh button
more than once, I get the next 2 CONSECUTIVE ERROR MESSAGES:
-UNKNOW FUNCTION NAME
- OBJECT INVALID OR NO LONGER SET

Can you,please, help me?
Click to expand...
 
~{4s<R:C~}!

~{:\C0CA5D4r~}?~{Dc~}?,~{NROkM(~}?~{Dc~}?~{PB~}??,?~{UR~}96~{Dj~}??~{5DR;N;EsSQ~},??~{K}TZNd~}?~{?UWS~}
~{VP~}???,~{DGDjK}~}17~{V\~}?.~{C{WV~}:??&??~{Ct~} ?~{8_~}3,~{K}JG:SDO~}?~{7bHK~},~{K}0V0VJG~}?~{PP~}?,
TEL:0378-2930775-21239,?~{TZ~}??~{R24r2;M(~},~{NR~}?~{JGTZ~}?~{<NAo1y~}???~{5D~},
98~{Dj~}6~{TB~},~{NR>M5=~}?~{]8AK~},~{VA=q~}?~{SP~}??~{5=~},~{O#M{~}??~{;rU_V*5@K}5DEsSQ~}?~{8f~}?~{K}~},
~{R2U_;r~}?~{:MNR~}??.
~{Hg9{~},??&?~{Ct~} ~{?45=AKR2~}??~{:MNR~}??


TEL:0769-2053911 ??
mobile: 13612662102 ??~{PEO"~}
E-maill: (e-mail address removed)
(e-mail address removed)


TKS!!!

?~{Go~}?
2004/08/22
 
¤j®a¦n!

«Ü«_¬Nªº¥´ÂZ§A­Ì,§Ú·Q³q¹L§A­Ì·s»D²Õ,´M§ä96¦~»{ÃѪº¤@¦ìªB¤Í,·í®É¦o¦bªZº~ªÅ¤l
¤¤¾ÇŪ®Ñ,¨º¦~¦o17©P·³.¦W¦r:·¨ÄR&?·¨±Ó Ū°ª3,¦o¬Oªe«n¶}«Ê¤H,¦oª¨ª¨¬O­¸¦æ­û,
TEL:0378-2930775-21239,²{¦b¹q¸Ü¤]¥´¤£³q,§Ú­Ì¬O¦bºû¹Å·È¦B³õ»{ÃѪº,
98¦~6¤ë,§Ú´N¨ìªF²ð¤F,¦Ü¤µ¨S¦³Ápµ¸¨ì,§Æ±æ»{ÃѩΪ̪¾¹D¦oªºªB¤Í½Ð§i¶D¦o,
¤]ªÌ©Î½Ð©M§ÚÁpµ¸.
¦pªG,·¨ÄR&·¨±Ó ¬Ý¨ì¤F¤]½Ð©p©M§ÚÁpµ¸


TEL:0769-2053911 ±M½u
mobile: 13612662102 ½Ðµo«H®§
E-maill: (e-mail address removed)
(e-mail address removed)


TKS!!!

·¨¬îµØ
2004/08/23
 
¤j®a¦n!

«Ü«_¬Nªº¥´ÂZ§A­Ì,§Ú·Q³q¹L§A­Ì·s»D²Õ,´M§ä96¦~»{ÃѪº¤@¦ìªB¤Í,·í®É¦o¦bªZº~ªÅ¤l
¤¤¾ÇŪ®Ñ,¨º¦~¦o17©P·³.¦W¦r:·¨ÄR&?·¨±Ó Ū°ª3,¦o¬Oªe«n¶}«Ê¤H,¦oª¨ª¨¬O­¸¦æ­û,
TEL:0378-2930775-21239,²{¦b¹q¸Ü¤]¥´¤£³q,§Ú­Ì¬O¦bºû¹Å·È¦B³õ»{ÃѪº,
98¦~6¤ë,§Ú´N¨ìªF²ð¤F,¦Ü¤µ¨S¦³Ápµ¸¨ì,§Æ±æ»{ÃѩΪ̪¾¹D¦oªºªB¤Í½Ð§i¶D¦o,
¤]ªÌ©Î½Ð©M§ÚÁpµ¸.
¦pªG,·¨ÄR&·¨±Ó ¬Ý¨ì¤F¤]½Ð©p©M§ÚÁpµ¸


TEL:0769-2053911 ±M½u
mobile: 13612662102 ½Ðµo«H®§
E-maill: (e-mail address removed)
(e-mail address removed)


TKS!!!

·¨¬îµØ
2004/08/22
 
George,

try this (as one last-gasp attempt to solve):

1) uninstall Office and reboot

2) go to this site:

http://www.microsoft.com/office/ork/2000/appndx/toolbox.htm

and download:

Office Resource Kit core tool set - updated April 20, 2000
ORKTools.exe File size: 8.9 MB

The Office 2000 Resource Kit contains the following set of core tools:

Custom Installation Wizard (version 1.00.00.3728)
Excel File Recovery Macro and Date Tools
Microsoft Internet Explorer Administration Kit 5.x (version 5.0.2809.2500)
Language Version utility (version 9.00.0028)
Terminal Server Tools
Profile Wizard
Removal Wizard
System Policy Editor and Templates
Unbind Binders Utility

3) run the *Removal Wizard* and reboot

4) download and run a Registry Cleaner

I don't know your skill level, so some suggestions
(but use at your own risk!)

Error Nuker
http://www.errornuker.com/info/01.php?hop=mdigr

RegSeeker
http://www.snapfiles.com/get/regseeker.html

other reg cleaners:
http://www.sofotex.com/download/PC_Utilities/Registry_Tools/

or try to delete all Office registry settings yourself.

Then reboot.

5) Reinstall Office and reboot.

6) go to Office Update site and have it check your installation.

http://office.microsoft.com/OfficeUpdate/default.aspx

click on "Check for Updates"

7) reboot
 
Back
Top