Re: New Install - problems with existing modules etc

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

Apparently it is not important.
On my old laptop, I thought I would try and recompile, and it also stopped
at the first Me.combobox with member or datafile not found. I searched this
newsgroup for the error and found several suggestions of replacing the period
with an exclamation mark. I did a search for Me. and replaced it with Me!
The compile ran flawless. I transferred the file to new computer and now the
program works there as well.

"Anne" wrote:

I am using Allen Browne's suggestion of re-registering the libraries and I am
getting an error:
C:\program files\common files\system\ado\msado21.tlb was loaded, but the
DllRegisterServer entry point was not found. C:\program files\common
files\system\ado\msado21.tlb does not appear to be a .dll or .ocx
What does that mean?

"Anne" wrote:

I have tried all suggestions without success. This form is almost identical
to another form which works. I copied an pasted the main items from the
working form to the non working form. I deleted all other items on the non
working form and still the errors. I think I will create a new form from
scratch.
It just does not leave me with much confidence, that I won't run into the
same problems sometime later.

"Linq Adams via AccessMonster.com" wrote:

The Access gnomes frequently get confused as the actual cause of an error,
especially, it seems, when there are multiple errors, and the error messages
are not always very helpful.

When apps run fine on one machine and not on another, the first thing you
have to think about are missing references.

Here are Doug Steele's instructions on how to troubleshoot the problem:

*** Quote ***

Any time functions that previously worked suddenly don't, the first thing to
suspect is a references problem.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target machine).
Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in and
reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out of
the dialog, then go back in and reselect the references you just unselected.
(NOTE: write down what the references are before you delete them, because
they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Just so you know: the problem will occur even if the library that contains
the specific function that's failing doesn't have a problem.

**** End Quote ****

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200810/1


.

Relevant Pages

  • Re: Lebans ReportToPDF
    ... References from the menu bar and examine all of the selected references ... unselect them, and back out of the dialog. ... But some time ago I started receiving "Compile Error: ...
    (microsoft.public.access.reports)
  • Re: error 7777
    ... 'end' on the error message, the programme moved on to the end rtecord quite ... Select Tools | References from the menu bar. ... If any of the selected references have "MISSING:" in front of them, unselect ...
    (microsoft.public.access.modulesdaovba)
  • Re: Missing Date functions in XP (datediff, dateadd)
    ... Doug Steele, Microsoft Access MVP ... >>The other possibility is that your references are messed ... >>all of the selected references. ... then go back in and unselect the ...
    (microsoft.public.access.queries)
  • Re: Exporting data to word errors.
    ... suddenly stops working, the first thing to suspect is a References ... Examine all of the selected references. ... unselect them, and back out of the dialog. ...
    (microsoft.public.access.modulesdaovba)
  • Re: New Install - problems with existing modules etc
    ... working form to the non working form. ... Select Tools | References from the menu bar. ... If any of the selected references have "MISSING:" in front of them, unselect ...
    (microsoft.public.access.formscoding)