p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Demons in my machine


Message #1 by "Charlie Goodwin" <cgoodwin@c...> on Fri, 07 Jun 2002 11:03:08 -0400
Access Exorcist Needed!!

As succinctly as I can make my situation...

Background:   I'm a longtime Access user - not a programmer - but I think
I'm getting good for a non- programmer - I'm really an artist by trade and
I've built a db for my art business - built with Access2K, last of many, ma
ny
iterations - I'll spare you the detailed description of the triple linked l
istbox
search function I built, etc., etc. - this one is my magnum opus.

Currently it runs entirely on macros, and very well, thank you, but I'm get
ting
fluent enough with Access to see myself converting macros to code soon, and
eventually learning to just code it straight up.

It's a very comprehensive artist's DB ... Codd would approve of the structu
ring of
everything I have put in to organize an artist - 46 tables worth and three 
times
that number of queries - I've got a lot of work into it.

And when I am sure I have the underlying table structure absolutely right, 
I have
artist  friends who I think would benefit from a Db like mine.   I'll split
 it into two
dbs, tables and interface and let a couple of friends have at it.   But, fi
rst I wanted to
be sure I won't be causing friends to have computer woes, so to start check
ing
it out on other machines, I have just installed  a copy on a friend's machi
ne also
running  A2K.

Currently the Db is a plain old mdb file.   Not split into two dbs yet, not
 runtime,
no provisions for anything other than a single user, no networking, It shou
ld be
straightforward.

Here is where the demons come in.

We started the Db on a new machine.   Initially, when I load it on it's "ho
me"
machine, up pops a splash screen to fend off boredome while other forms load
hidden in the background, however on the new machine, the loading sequence
had a cardiac.  Nothing loaded.

An error box popped up repeatedly with "Undefined function " Format" in
expression".

When I opened forms manually from the database window, listboxes wouldn't
populate.     Dates failed to display - instead showing    #name?.    It ac
ted like
many of the macros were unrecognised by the machine.   One form would open
only in design view.

I'm baffled.

I can't even tell you what went wrong, except that actions failed and went 
to the
"halt" window., listing various macros that didn't complete.

Problem is, I haven't a clue where to begin diagnosing whatever vile spirit
s that
have taken up residence in my Db.   Does this mean that in a previous life I
maybe didn't declare enough variables, used variants promiscuously, or defi
ed
logical naming conventions?

Without asking everyone to spell it out in grand detail, where do I start s
orting
this out?   Do any entry points or diagnostic questions to ask suggest them
selves
to wiser minds?

Of course, just to be perverse, on it's "native" computer, it still runs li
ke a top.
Based on that machine I wouldn't have a clue that some problem exists.   Ma
ybe
someone can suggest specific diagnostic questions to pursue?  Follow up tes
ting 
it on a third A2K machine yielded the same weird errors.

Many thanks in advance!

Charlie

Message #2 by wesley.fitzpatrick@s... on Fri, 7 Jun 2002 17:07:12 +0200
Don't know about the other things but for the date function you could try
checking your friends system date. If You have american format (mm/dd/yy)
say, and he/she has british format (dd/mm/yy) then this could throw up some
wobblies.

----- 
Wesley Fitzpatrick
IS Helpdesk
Syngenta Agro AG

Chemiestrasse 1, Dielsdorf, CH-8157, Switzerland

Tel: +41 (0)1 8558 411

Fax: +41 (0)1 8558 708

wesley.fitzpatrick@s... <mailto:wesley.Fitzpatrick@s...> 


 ~-----Original Message-----
 ~From: Charlie Goodwin [mailto:cgoodwin@c...]
 ~Sent: Freitag, 7. Juni 2002 17:03
 ~To: Access
 ~Subject: [access] Demons in my machine
 ~
 ~
 ~Access Exorcist Needed!!
 ~
 ~As succinctly as I can make my situation...
 ~
 ~Background:   I'm a longtime Access user - not a programmer - 
 ~but I think
 ~I'm getting good for a non- programmer - I'm really an artist 
 ~by trade and
 ~I've built a db for my art business - built with Access2K, 
 ~last of many, many
 ~iterations - I'll spare you the detailed description of the 
 ~triple linked listbox
 ~search function I built, etc., etc. - this one is my magnum opus.
 ~
 ~Currently it runs entirely on macros, and very well, thank 
 ~you, but I'm getting
 ~fluent enough with Access to see myself converting macros to 
 ~code soon, and
 ~eventually learning to just code it straight up.
 ~
 ~It's a very comprehensive artist's DB ... Codd would approve 
 ~of the structuring of
 ~everything I have put in to organize an artist - 46 tables 
 ~worth and three times
 ~that number of queries - I've got a lot of work into it.
 ~
 ~And when I am sure I have the underlying table structure 
 ~absolutely right, I have
 ~artist  friends who I think would benefit from a Db like 
 ~mine.   I'll split it into two
 ~dbs, tables and interface and let a couple of friends have at 
 ~it.   But, first I wanted to
 ~be sure I won't be causing friends to have computer woes, so 
 ~to start checking
 ~it out on other machines, I have just installed  a copy on a 
 ~friend's machine also
 ~running  A2K.
 ~
 ~Currently the Db is a plain old mdb file.   Not split into 
 ~two dbs yet, not runtime,
 ~no provisions for anything other than a single user, no 
 ~networking, It should be
 ~straightforward.
 ~
 ~Here is where the demons come in.
 ~
 ~We started the Db on a new machine.   Initially, when I load 
 ~it on it's "home"
 ~machine, up pops a splash screen to fend off boredome while 
 ~other forms load
 ~hidden in the background, however on the new machine, the 
 ~loading sequence
 ~had a cardiac.  Nothing loaded.
 ~
 ~An error box popped up repeatedly with "Undefined function " 
 ~Format" in
 ~expression".
 ~
 ~When I opened forms manually from the database window, 
 ~listboxes wouldn't
 ~populate.     Dates failed to display - instead showing    
 ~#name?.    It acted like
 ~many of the macros were unrecognised by the machine.   One 
 ~form would open
 ~only in design view.
 ~
 ~I'm baffled.
 ~
 ~I can't even tell you what went wrong, except that actions 
 ~failed and went to the
 ~"halt" window., listing various macros that didn't complete.
 ~
 ~Problem is, I haven't a clue where to begin diagnosing 
 ~whatever vile spirits that
 ~have taken up residence in my Db.   Does this mean that in a 
 ~previous life I
 ~maybe didn't declare enough variables, used variants 
 ~promiscuously, or defied
 ~logical naming conventions?
 ~
 ~Without asking everyone to spell it out in grand detail, 
 ~where do I start sorting
 ~this out?   Do any entry points or diagnostic questions to 
 ~ask suggest themselves
 ~to wiser minds?
 ~
 ~Of course, just to be perverse, on it's "native" computer, it 
 ~still runs like a top.
 ~Based on that machine I wouldn't have a clue that some 
 ~problem exists.   Maybe
 ~someone can suggest specific diagnostic questions to pursue?  
 ~Follow up testing 
 ~it on a third A2K machine yielded the same weird errors.
 ~
 ~Many thanks in advance!
 ~
 ~Charlie
 ~
 ~
 ~
Message #3 by wesley.fitzpatrick@s... on Fri, 7 Jun 2002 17:12:28 +0200
oh and btw- after installation on your friends machine go to Tools ->
Database Utilities -> Compact and repair database that should even out any
teething problems...

----- 
Wesley Fitzpatrick
IS Helpdesk
Syngenta Agro AG

Chemiestrasse 1, Dielsdorf, CH-8157, Switzerland

Tel: +41 (0)1 8558 411

Fax: +41 (0)1 8558 708

wesley.fitzpatrick@s... <mailto:wesley.Fitzpatrick@s...> 


 ~-----Original Message-----
 ~From: Charlie Goodwin [mailto:cgoodwin@c...]
 ~Sent: Freitag, 7. Juni 2002 17:03
 ~To: Access
 ~Subject: [access] Demons in my machine
 ~
 ~
 ~Access Exorcist Needed!!
 ~
 ~As succinctly as I can make my situation...
 ~
 ~Background:   I'm a longtime Access user - not a programmer - 
 ~but I think
 ~I'm getting good for a non- programmer - I'm really an artist 
 ~by trade and
 ~I've built a db for my art business - built with Access2K, 
 ~last of many, many
 ~iterations - I'll spare you the detailed description of the 
 ~triple linked listbox
 ~search function I built, etc., etc. - this one is my magnum opus.
 ~
 ~Currently it runs entirely on macros, and very well, thank 
 ~you, but I'm getting
 ~fluent enough with Access to see myself converting macros to 
 ~code soon, and
 ~eventually learning to just code it straight up.
 ~
 ~It's a very comprehensive artist's DB ... Codd would approve 
 ~of the structuring of
 ~everything I have put in to organize an artist - 46 tables 
 ~worth and three times
 ~that number of queries - I've got a lot of work into it.
 ~
 ~And when I am sure I have the underlying table structure 
 ~absolutely right, I have
 ~artist  friends who I think would benefit from a Db like 
 ~mine.   I'll split it into two
 ~dbs, tables and interface and let a couple of friends have at 
 ~it.   But, first I wanted to
 ~be sure I won't be causing friends to have computer woes, so 
 ~to start checking
 ~it out on other machines, I have just installed  a copy on a 
 ~friend's machine also
 ~running  A2K.
 ~
 ~Currently the Db is a plain old mdb file.   Not split into 
 ~two dbs yet, not runtime,
 ~no provisions for anything other than a single user, no 
 ~networking, It should be
 ~straightforward.
 ~
 ~Here is where the demons come in.
 ~
 ~We started the Db on a new machine.   Initially, when I load 
 ~it on it's "home"
 ~machine, up pops a splash screen to fend off boredome while 
 ~other forms load
 ~hidden in the background, however on the new machine, the 
 ~loading sequence
 ~had a cardiac.  Nothing loaded.
 ~
 ~An error box popped up repeatedly with "Undefined function " 
 ~Format" in
 ~expression".
 ~
 ~When I opened forms manually from the database window, 
 ~listboxes wouldn't
 ~populate.     Dates failed to display - instead showing    
 ~#name?.    It acted like
 ~many of the macros were unrecognised by the machine.   One 
 ~form would open
 ~only in design view.
 ~
 ~I'm baffled.
 ~
 ~I can't even tell you what went wrong, except that actions 
 ~failed and went to the
 ~"halt" window., listing various macros that didn't complete.
 ~
 ~Problem is, I haven't a clue where to begin diagnosing 
 ~whatever vile spirits that
 ~have taken up residence in my Db.   Does this mean that in a 
 ~previous life I
 ~maybe didn't declare enough variables, used variants 
 ~promiscuously, or defied
 ~logical naming conventions?
 ~
 ~Without asking everyone to spell it out in grand detail, 
 ~where do I start sorting
 ~this out?   Do any entry points or diagnostic questions to 
 ~ask suggest themselves
 ~to wiser minds?
 ~
 ~Of course, just to be perverse, on it's "native" computer, it 
 ~still runs like a top.
 ~Based on that machine I wouldn't have a clue that some 
 ~problem exists.   Maybe
 ~someone can suggest specific diagnostic questions to pursue?  
 ~Follow up testing 
 ~it on a third A2K machine yielded the same weird errors.
 ~
 ~Many thanks in advance!
 ~
 ~Charlie
 ~
 ~
 ~
Message #4 by braxis@b... on Fri, 7 Jun 2002 16:36:30 +0100 (BST)
Charlie

When your basic functions start to fail it's almost always a problem with references to the various little library files that Access
uses.

Although you aren't using any VBA code, I'll bet that your forms and queries have some formatting functions(format(), left()),
date\time functions (date()), etc. in them somewhere.

So, open the database on your friends PC. Press <alt><F11> to open the VBA code editor, and choose References from the
Tools menu. Hopefully one, or more, of the ticked references will have the word '*MISSING*' in bold letters next to it.

Make a note of the missing references file name, shown at the bottom of the refernces window, and do a search for it through Windows
Explorer. Hopefully it's installed on you friends computer, but hidden somewhere that Access isn't looking. Once you've found the
file go back to the references window. Click on the Browse button and show Access where to find the file.

Hopefully this will solve the problem.

Brian

>  from:    Charlie Goodwin <cgoodwin@c...>
>  date:    Fri, 07 Jun 2002 16:03:08
>  to:      access@p...
>  subject: Re: [access] Demons in my machine
> 
> Access Exorcist Needed!!
> 
> As succinctly as I can make my situation...
> 
> Background:   I'm a longtime Access user - not a programmer - but I think
> I'm getting good for a non- programmer - I'm really an artist by trade and
> I've built a db for my art business - built with Access2K, last of many, many
> iterations - I'll spare you the detailed description of the triple linked listbox
> search function I built, etc., etc. - this one is my magnum opus.
> 
> Currently it runs entirely on macros, and very well, thank you, but I'm getting
> fluent enough with Access to see myself converting macros to code soon, and
> eventually learning to just code it straight up.
> 
> It's a very comprehensive artist's DB ... Codd would approve of the structuring of
> everything I have put in to organize an artist - 46 tables worth and three times
> that number of queries - I've got a lot of work into it.
> 
> And when I am sure I have the underlying table structure absolutely right, I have
> artist  friends who I think would benefit from a Db like mine.   I'll split it into two
> dbs, tables and interface and let a couple of friends have at it.   But, first I wanted to
> be sure I won't be causing friends to have computer woes, so to start checking
> it out on other machines, I have just installed  a copy on a friend's machine also
> running  A2K.
> 
> Currently the Db is a plain old mdb file.   Not split into two dbs yet, not runtime,
> no provisions for anything other than a single user, no networking, It should be
> straightforward.
> 
> Here is where the demons come in.
> 
> We started the Db on a new machine.   Initially, when I load it on it's "home"
> machine, up pops a splash screen to fend off boredome while other forms load
> hidden in the background, however on the new machine, the loading sequence
> had a cardiac.  Nothing loaded.
> 
> An error box popped up repeatedly with "Undefined function " Format" in
> expression".
> 
> When I opened forms manually from the database window, listboxes wouldn't
> populate.     Dates failed to display - instead showing    #name?.    It acted like
> many of the macros were unrecognised by the machine.   One form would open
> only in design view.
> 
> I'm baffled.
> 
> I can't even tell you what went wrong, except that actions failed and went to the
> "halt" window., listing various macros that didn't complete.
> 
> Problem is, I haven't a clue where to begin diagnosing whatever vile spirits that
> have taken up residence in my Db.   Does this mean that in a previous life I
> maybe didn't declare enough variables, used variants promiscuously, or defied
> logical naming conventions?
> 
> Without asking everyone to spell it out in grand detail, where do I start sorting
> this out?   Do any entry points or diagnostic questions to ask suggest themselves
> to wiser minds?
> 
> Of course, just to be perverse, on it's "native" computer, it still runs like a top.
> Based on that machine I wouldn't have a clue that some problem exists.   Maybe
> someone can suggest specific diagnostic questions to pursue?  Follow up testing
> it on a third A2K machine yielded the same weird errors.
> 
> Many thanks in advance!
> 
> Charlie
> 
> 

Message #5 by "Leo Scott" <leoscott@c...> on Fri, 7 Jun 2002 08:49:39 -0700
It is highly likely that this is the problem.  Charlie probably used some
wizards to create some of the forms, reports, etc, in the database which
generate VBA code when they run.  He probably has some later versions of
some of the libraries on his machine than his friend and this caused the
MISSING references.

|-----Original Message-----
|From: braxis@b... [mailto:braxis@b...]
|Sent: Friday, June 07, 2002 8:37 AM
|To: Access
|Subject: [access] Re: Demons in my machine
|
|
|Charlie
|
|When your basic functions start to fail it's almost always a
|problem with references to the various little library files that
|Access uses.
|
|Although you aren't using any VBA code, I'll bet that your forms
|and queries have some formatting functions(format(), left()),
|date\time functions (date()), etc. in them somewhere.
|
|So, open the database on your friends PC. Press <alt><F11> to open
|the VBA code editor, and choose References from the Tools menu.
|Hopefully one, or more, of the ticked references will have the
|word '*MISSING*' in bold letters next to it.
|
|Make a note of the missing references file name, shown at the
|bottom of the refernces window, and do a search for it through
|Windows Explorer. Hopefully it's installed on you friends
|computer, but hidden somewhere that Access isn't looking. Once
|you've found the file go back to the references window. Click on
|the Browse button and show Access where to find the file.
|
|Hopefully this will solve the problem.
|
|Brian
|
|>  from:    Charlie Goodwin <cgoodwin@c...>
|>  date:    Fri, 07 Jun 2002 16:03:08
|>  to:      access@p...
|>  subject: Re: [access] Demons in my machine
|>
|> Access Exorcist Needed!!
|>
|> As succinctly as I can make my situation...
|>
|> Background:   I'm a longtime Access user - not a programmer - but I think
|> I'm getting good for a non- programmer - I'm really an artist by
|trade and
|> I've built a db for my art business - built with Access2K, last
|of many, many
|> iterations - I'll spare you the detailed description of the
|triple linked listbox
|> search function I built, etc., etc. - this one is my magnum opus.
|>
|> Currently it runs entirely on macros, and very well, thank you,
|but I'm getting
|> fluent enough with Access to see myself converting macros to
|code soon, and
|> eventually learning to just code it straight up.
|>
|> It's a very comprehensive artist's DB ... Codd would approve of
|the structuring of
|> everything I have put in to organize an artist - 46 tables worth
|and three times
|> that number of queries - I've got a lot of work into it.
|>
|> And when I am sure I have the underlying table structure
|absolutely right, I have
|> artist  friends who I think would benefit from a Db like mine.
|I'll split it into two
|> dbs, tables and interface and let a couple of friends have at
|it.   But, first I wanted to
|> be sure I won't be causing friends to have computer woes, so to
|start checking
|> it out on other machines, I have just installed  a copy on a
|friend's machine also
|> running  A2K.
|>
|> Currently the Db is a plain old mdb file.   Not split into two
|dbs yet, not runtime,
|> no provisions for anything other than a single user, no
|networking, It should be
|> straightforward.
|>
|> Here is where the demons come in.
|>
|> We started the Db on a new machine.   Initially, when I load it
|on it's "home"
|> machine, up pops a splash screen to fend off boredome while
|other forms load
|> hidden in the background, however on the new machine, the
|loading sequence
|> had a cardiac.  Nothing loaded.
|>
|> An error box popped up repeatedly with "Undefined function " Format" in
|> expression".
|>
|> When I opened forms manually from the database window, listboxes wouldn't
|> populate.     Dates failed to display - instead showing
|#name?.    It acted like
|> many of the macros were unrecognised by the machine.   One form
|would open
|> only in design view.
|>
|> I'm baffled.
|>
|> I can't even tell you what went wrong, except that actions
|failed and went to the
|> "halt" window., listing various macros that didn't complete.
|>
|> Problem is, I haven't a clue where to begin diagnosing whatever
|vile spirits that
|> have taken up residence in my Db.   Does this mean that in a
|previous life I
|> maybe didn't declare enough variables, used variants
|promiscuously, or defied
|> logical naming conventions?
|>
|> Without asking everyone to spell it out in grand detail, where
|do I start sorting
|> this out?   Do any entry points or diagnostic questions to ask
|suggest themselves
|> to wiser minds?
|>
|> Of course, just to be perverse, on it's "native" computer, it
|still runs like a top.
|> Based on that machine I wouldn't have a clue that some problem
|exists.   Maybe
|> someone can suggest specific diagnostic questions to pursue?
|Follow up testing
|> it on a third A2K machine yielded the same weird errors.
|>
|> Many thanks in advance!
|>
|> Charlie
|>
|>
|
|
|

Message #6 by "Gerald, Rand" <RGerald@u...> on Fri, 7 Jun 2002 10:56:40 -0500
Charlie,

Even though you think that you're not using "code" in your database, 
you
are.  The VBA functions, which you call in queries or macros need the 
VBA
libraries in order to function.  "Format" is one of those functions.

On the new machine in the database window select Modules and pick any 
module
in Design mode (if there are no existing modules pick New mode).  At 
the top
of the screen pick Tools / References from the design menu.  Add the
following library references (one at a time) and test your application 
until
you have all the Libraries you need.   One or more Libraries may 
already be
installed as may some others - leave them alone.

1. Visual Basic for Applications
2. Microsoft Access 9.0 Object Library
3. OLE Applications
4. Microsoft ActiveX Data Objects 2.1 Library

You will probably only need the first two references but I'm listing 
all
that I use to be safe.  An alternative is to do this same thing on your 
home
machine to see which Libraries are already installed and duplicate that 
list
on the new machine.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: Charlie Goodwin [mailto:cgoodwin@c...]
Sent: Friday, June 07, 2002 10:03 AM
To: Access
Subject: [access] Demons in my machine

Access Exorcist Needed!!

As succinctly as I can make my situation...

Background:   I'm a longtime Access user - not a programmer - but I 
think
I'm getting good for a non- programmer - I'm really an artist by trade 
and
I've built a db for my art business - built with Access2K, last of 
many,
many
iterations - I'll spare you the detailed description of the triple 
linked
listbox
search function I built, etc., etc. - this one is my magnum opus.

Currently it runs entirely on macros, and very well, thank you, but I'm
getting
fluent enough with Access to see myself converting macros to code soon, 
and
eventually learning to just code it straight up.

It's a very comprehensive artist's DB ... Codd would approve of the
structuring of
everything I have put in to organize an artist - 46 tables worth and 
three
times
that number of queries - I've got a lot of work into it.

And when I am sure I have the underlying table structure absolutely 
right, I
have
artist  friends who I think would benefit from a Db like mine.   I'll 
split
it into two
dbs, tables and interface and let a couple of friends have at it.   
But,
first I wanted to
be sure I won't be causing friends to have computer woes, so to start
checking
it out on other machines, I have just installed  a copy on a friend's
machine also
running  A2K.

Currently the Db is a plain old mdb file.   Not split into two dbs yet, 
not
runtime,
no provisions for anything other than a single user, no networking, It
should be
straightforward.

Here is where the demons come in.

We started the Db on a new machine.   Initially, when I load it on it's
"home"
machine, up pops a splash screen to fend off boredome while other forms 
load
hidden in the background, however on the new machine, the loading 
sequence
had a cardiac.  Nothing loaded.

An error box popped up repeatedly with "Undefined function " Format" in
expression".

When I opened forms manually from the database window, listboxes 
wouldn't
populate.     Dates failed to display - instead showing    #name?.    
It
acted like
many of the macros were unrecognised by the machine.   One form would 
open
only in design view.

I'm baffled.

I can't even tell you what went wrong, except that actions failed and 
went
to the
"halt" window., listing various macros that didn't complete.

Problem is, I haven't a clue where to begin diagnosing whatever vile 
spirits
that
have taken up residence in my Db.   Does this mean that in a previous 
life I
maybe didn't declare enough variables, used variants promiscuously, or
defied
logical naming conventions?

Without asking everyone to spell it out in grand detail, where do I 
start
sorting
this out?   Do any entry points or diagnostic questions to ask suggest
themselves
to wiser minds?

Of course, just to be perverse, on it's "native" computer, it still 
runs
like a top.
Based on that machine I wouldn't have a clue that some problem exists.
Maybe
someone can suggest specific diagnostic questions to pursue?  Follow up
testing
it on a third A2K machine yielded the same weird errors.

Many thanks in advance!

Charlie


Message #7 by "Gerald, Rand" <RGerald@u...> on Fri, 7 Jun 2002 11:03:25 -0500
We both had the same idea - -

I like the <alt>-<F11> shortcut, that you mentioned.  It works faster 
than
my suggestion of how to start the VBA editor.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: braxis@b... [mailto:braxis@b...]
Sent: Friday, June 07, 2002 10:37 AM
To: Access
Subject: [access] Re: Demons in my machine

Charlie

When your basic functions start to fail it's almost always a problem 
with
references to the various little library files that Access uses.

Although you aren't using any VBA code, I'll bet that your forms and 
queries
have some formatting functions(format(), left()), date\time functions
(date()), etc. in them somewhere.

So, open the database on your friends PC. Press <alt><F11> to open the 
VBA
code editor, and choose References from the Tools menu. Hopefully one, 
or
more, of the ticked references will have the word '*MISSING*' in bold
letters next to it.

Make a note of the missing references file name, shown at the bottom of 
the
refernces window, and do a search for it through Windows Explorer. 
Hopefully
it's installed on you friends computer, but hidden somewhere that 
Access
isn't looking. Once you've found the file go back to the references 
window.
Click on the Browse button and show Access where to find the file.

Hopefully this will solve the problem.

Brian

>  from:    Charlie Goodwin <cgoodwin@c...>
>  date:    Fri, 07 Jun 2002 16:03:08
>  to:      access@p...
>  subject: Re: [access] Demons in my machine
>
> Access Exorcist Needed!!
>
> As succinctly as I can make my situation...
>
> Background:   I'm a longtime Access user - not a programmer - but I 
think
> I'm getting good for a non- programmer - I'm really an artist by 
trade and
> I've built a db for my art business - built with Access2K, last of 
many,
many
> iterations - I'll spare you the detailed description of the triple 
linked
listbox
> search function I built, etc., etc. - this one is my magnum opus.
>
> Currently it runs entirely on macros, and very well, thank you, but 
I'm
getting
> fluent enough with Access to see myself converting macros to code 
soon,
and
> eventually learning to just code it straight up.
>
> It's a very comprehensive artist's DB ... Codd would approve of the
structuring of
> everything I have put in to organize an artist - 46 tables worth and 
three
times
> that number of queries - I've got a lot of work into it.
>
> And when I am sure I have the underlying table structure absolutely 
right,
I have
> artist  friends who I think would benefit from a Db like mine.   I'll
split it into two
> dbs, tables and interface and let a couple of friends have at it.   
But,
first I wanted to
> be sure I won't be causing friends to have computer woes, so to start
checking
> it out on other machines, I have just installed  a copy on a friend's
machine also
> running  A2K.
>
> Currently the Db is a plain old mdb file.   Not split into two dbs 
yet,
not runtime,
> no provisions for anything other than a single user, no networking, 
It
should be
> straightforward.
>
> Here is where the demons come in.
>
> We started the Db on a new machine.   Initially, when I load it on 
it's
"home"
> machine, up pops a splash screen to fend off boredome while other 
forms
load
> hidden in the background, however on the new machine, the loading 
sequence
> had a cardiac.  Nothing loaded.
>
> An error box popped up repeatedly with "Undefined function " Format" 
in
> expression".
>
> When I opened forms manually from the database window, listboxes 
wouldn't
> populate.     Dates failed to display - instead showing    #name?.    
It
acted like
> many of the macros were unrecognised by the machine.   One form would 
open
> only in design view.
>
> I'm baffled.
>
> I can't even tell you what went wrong, except that actions failed and 
went
to the
> "halt" window., listing various macros that didn't complete.
>
> Problem is, I haven't a clue where to begin diagnosing whatever vile
spirits that
> have taken up residence in my Db.   Does this mean that in a previous 
life
I
> maybe didn't declare enough variables, used variants promiscuously, 
or
defied
> logical naming conventions?
>
> Without asking everyone to spell it out in grand detail, where do I 
start
sorting
> this out?   Do any entry points or diagnostic questions to ask 
suggest
themselves
> to wiser minds?
>
> Of course, just to be perverse, on it's "native" computer, it still 
runs
like a top.
> Based on that machine I wouldn't have a clue that some problem 
exists.
Maybe
> someone can suggest specific diagnostic questions to pursue?  Follow 
up
testing
> it on a third A2K machine yielded the same weird errors.
>
> Many thanks in advance!
>
> Charlie
>
>


Message #8 by "Charlie Goodwin" <cgoodwin@c...> on Fri, 07 Jun 2002 16:24:34 -0400
Hello all,

I am going to try to respond here all at once to everyone's rapid and
generous replies to me.   With your expert help I have made progress:

I have found two files to be missing from the library references of one of 
the
machines my Db doesn't work on.

I needed comctl32.ocx   which I did locate in C:\WINDOWS\System rather
than in system32 where Access was looking for it.   I made the reference
to it, and Access seems to be quite satisfied on that count.

I still need dmocx.dll which is nowhere to be found on the second machine I
 am
using as the "crash dummy".   Can I simply copy it off my original developm
ent
machine (where it does reside) and paste it into the "crash dummy"?   I don
't
know dlls, and need to know how to get them safely installed in a machine t
hat's
missing them.

I do not yet see an improvement in the Db, but with all this super backup f
rom
everyone, I think it will be running fine soon.

In the future, how can I ensure other users will have machines configured w
ith
the correct libraries and references?

Do I include all the files they might need in the package I send out?   Or,
 do I
send out a dumbed down Db that requires only basic components that get
installed with every Access DB?

In response to leoscott@c... , I tend to use few wizards.   Usually I can
produce faster and/or get more of what I want when I set things up myself.
(Though I'm still baffled by the formatting on stuff like zip codes and pho
ne
numbers. I do use the wizards for those items, every time!)  I seem to have
figured out the date and currency formatting uses of the "format" function
for myself.  I have used lots of those in expressions in combos and listbox
es,
where I might draw info from several tables to make choices of say, art,
showing title, year of production, price, and medium.   I don't know any
way to make something like:

"Water Tower", 2001, $1000.00, oil on canvas

show up neatly as a choice in a combo, other than by incorporating a couple
 of
format functions.


In response to Wesley's email:

	"Don't know about the other things but for the date function
	you could try checking your friends system date. If You have
	american format (mm/dd/yy) say, and he/she has british format
	(dd/mm/yy) then this could throw up some wobblies."

I'm afraid I don't even know where to look to check the formatting of the s
ystem
date.   How do I check that?


Once again, thanks everyone!!!!!

Charlie










> Charlie
>
> When your basic functions start to fail it's almost always a problem with
 references to the various little library files that Access uses.
>
> Although you aren't using any VBA code, I'll bet that your forms and quer
ies have some formatting functions(format(), left()), date\time functions (
date()), etc. in them somewhere.
>
> So, open the database on your friends PC. Press <alt><F11> to open the VB
A code editor, and choose References from the Tools menu. Hopefully one, or
 more, of the ticked references will have the word '*MISSING*' in bold lett
ers next to it.
>
> Make a note of the missing references file name, shown at the bottom of t
he refernces window, and do a search for it through Windows Explorer. Hopef
ully it's installed on you friends computer, but hidden somewhere that Acce
ss isn't looking. Once you've found the file go back to the references wind
ow. Click on the Browse button and show Access where to find the file.
>
> Hopefully this will solve the problem.
>
> Brian
>
> >  from:    Charlie Goodwin <cgoodwin@c...>
> >  date:    Fri, 07 Jun 2002 16:03:08
> >  to:      access@p...
> >  subject: Re: [access] Demons in my machine
> >
> > Access Exorcist Needed!!
> >
> > As succinctly as I can make my situation...
> >
> > Background:   I'm a longtime Access user - not a programmer - but I thi
nk
> > I'm getting good for a non- programmer - I'm really an artist by trade 
and
> > I've built a db for my art business - built with Access2K, last of many
, many
> > iterations - I'll spare you the detailed description of the triple link
ed listbox
> > search function I built, etc., etc. - this one is my magnum opus.
> >
> > Currently it runs entirely on macros, and very well, thank you, but I'm
 getting
> > fluent enough with Access to see myself converting macros to code soon,
 and
> > eventually learning to just code it straight up.
> >
> > It's a very comprehensive artist's DB ... Codd would approve of the str
ucturing of
> > everything I have put in to organize an artist - 46 tables worth and th
ree times
> > that number of queries - I've got a lot of work into it.
> >
> > And when I am sure I have the underlying table structure absolutely rig
ht, I have
> > artist  friends who I think would benefit from a Db like mine.   I'll s
plit it into two
> > dbs, tables and interface and let a couple of friends have at it.   But
, first I wanted to
> > be sure I won't be causing friends to have computer woes, so to start c
hecking
> > it out on other machines, I have just installed  a copy on a friend's m
achine also
> > running  A2K.
> >
> > Currently the Db is a plain old mdb file.   Not split into two dbs yet,
 not runtime,
> > no provisions for anything other than a single user, no networking, It 
should be
> > straightforward.
> >
> > Here is where the demons come in.
> >
> > We started the Db on a new machine.   Initially, when I load it on it's
 "home"
> > machine, up pops a splash screen to fend off boredome while other forms
 load
> > hidden in the background, however on the new machine, the loading seque
nce
> > had a cardiac.  Nothing loaded.
> >
> > An error box popped up repeatedly with "Undefined function " Format" in
> > expression".
> >
> > When I opened forms manually from the database window, listboxes wouldn
't
> > populate.     Dates failed to display - instead showing    #name?.    I
t acted like
> > many of the macros were unrecognised by the machine.   One form would o
pen
> > only in design view.
> >
> > I'm baffled.
> >
> > I can't even tell you what went wrong, except that actions failed and w
ent to the
> > "halt" window., listing various macros that didn't complete.
> >
> > Problem is, I haven't a clue where to begin diagnosing whatever vile sp
irits that
> > have taken up residence in my Db.   Does this mean that in a previous l
ife I
> > maybe didn't declare enough variables, used variants promiscuously, or 
defied
> > logical naming conventions?
> >
> > Without asking everyone to spell it out in grand detail, where do I sta
rt sorting
> > this out?   Do any entry points or diagnostic questions to ask suggest 
themselves
> > to wiser minds?
> >
> > Of course, just to be perverse, on it's "native" computer, it still run
s like a top.
> > Based on that machine I wouldn't have a clue that some problem exists. 
  Maybe
> > someone can suggest specific diagnostic questions to pursue?  Follow up
 testing
> > it on a third A2K machine yielded the same weird errors.
> >
> > Many thanks in advance!
> >
> > Charlie
> >
> >
>
>
Message #9 by "Leo Scott" <leoscott@c...> on Fri, 7 Jun 2002 15:40:13 -0700
My reference to wizards was more about having the Toolbox Control wizard
turned on when you add a combobox or button to a form.  In cases like that
you don't see it but the "wizard" creates code behind the form to make it
all work.  All it takes is one form with code behind it or one module in the
database to cause the references problem.  What I found interesting is that
I searched my whole development system, Win NT4.0 sp6a Server with a full
Visual Studio 6.0 sp5, and couldn't find a single file named dmocx.dll.
What exactly is that for?


|-----Original Message-----
|From: Charlie Goodwin [mailto:cgoodwin@c...]
|Sent: Friday, June 07, 2002 1:25 PM
|To: Access
|Subject: [access] Re: Demons in my machine
|
|
|Hello all,
|
|I am going to try to respond here all at once to everyone's rapid and
|generous replies to me.   With your expert help I have made progress:
|
|I have found two files to be missing from the library references
|of one of the
|machines my Db doesn't work on.
|
|I needed comctl32.ocx   which I did locate in C:\WINDOWS\System rather
|than in system32 where Access was looking for it.   I made the reference
|to it, and Access seems to be quite satisfied on that count.
|
|I still need dmocx.dll which is nowhere to be found on the second
|machine I am
|using as the "crash dummy".   Can I simply copy it off my original
|development
|machine (where it does reside) and paste it into the "crash
|dummy"?   I don't
|know dlls, and need to know how to get them safely installed in a
|machine that's
|missing them.
|
|I do not yet see an improvement in the Db, but with all this super
|backup from
|everyone, I think it will be running fine soon.
|
|In the future, how can I ensure other users will have machines
|configured with
|the correct libraries and references?
|
|Do I include all the files they might need in the package I send
|out?   Or, do I
|send out a dumbed down Db that requires only basic components that get
|installed with every Access DB?
|
|In response to leoscott@c... , I tend to use few wizards.
|Usually I can
|produce faster and/or get more of what I want when I set things up myself.
|(Though I'm still baffled by the formatting on stuff like zip
|codes and phone
|numbers. I do use the wizards for those items, every time!)  I seem to have
|figured out the date and currency formatting uses of the "format" function
|for myself.  I have used lots of those in expressions in combos
|and listboxes,
|where I might draw info from several tables to make choices of say, art,
|showing title, year of production, price, and medium.   I don't know any
|way to make something like:
|
|"Water Tower", 2001, $1000.00, oil on canvas

Message #10 by "Charlie Goodwin" <cgoodwin@c...> on Sat, 08 Jun 2002 11:42:51 -0400
Sorry to be so slow responding...

In the VBA Code Editor dmocx.dll is listed on my machine as a
ctv OLE Control Module.   Access assumes that dmocx.dll lives
in C:\WINDOWS\System32 .

When I started learning Access, it was on a NT3.51 machine with
a buggy copy of Access.   The wizards caused more problems
than they solved, so I sorted out how to produce stuff without
them.


Charlie




> My reference to wizards was more about having the Toolbox Control wizard
> turned on when you add a combobox or button to a form.  In cases like that
> you don't see it but the "wizard" creates code behind the form to make it
> all work.  All it takes is one form with code behind it or one module in 
the
> database to cause the references problem.  What I found interesting is th
at
> I searched my whole development system, Win NT4.0 sp6a Server with a full
> Visual Studio 6.0 sp5, and couldn't find a single file named dmocx.dll.
> What exactly is that for?
>
>
> |-----Original Message-----
> |From: Charlie Goodwin [cgoodwin@c...]
> |Sent: Friday, June 07, 2002 1:25 PM
> |To: Access
> |Subject: [access] Re: Demons in my machine
> |
> |
> |Hello all,
> |
> |I am going to try to respond here all at once to everyone's rapid and
> |generous replies to me.   With your expert help I have made progress:
> |
> |I have found two files to be missing from the library references
> |of one of the
> |machines my Db doesn't work on.
> |
> |I needed comctl32.ocx   which I did locate in C:\WINDOWS\System rather
> |than in system32 where Access was looking for it.   I made the reference
> |to it, and Access seems to be quite satisfied on that count.
> |
> |I still need dmocx.dll which is nowhere to be found on the second
> |machine I am
> |using as the "crash dummy".   Can I simply copy it off my original
> |development
> |machine (where it does reside) and paste it into the "crash
> |dummy"?   I don't
> |know dlls, and need to know how to get them safely installed in a
> |machine that's
> |missing them.
> |
> |I do not yet see an improvement in the Db, but with all this super
> |backup from
> |everyone, I think it will be running fine soon.
> |
> |In the future, how can I ensure other users will have machines
> |configured with
> |the correct libraries and references?
> |
> |Do I include all the files they might need in the package I send
> |out?   Or, do I
> |send out a dumbed down Db that requires only basic components that get
> |installed with every Access DB?
> |
> |In response to leoscott@c... , I tend to use few wizards.
> |Usually I can
> |produce faster and/or get more of what I want when I set things up mysel
f.
> |(Though I'm still baffled by the formatting on stuff like zip
> |codes and phone
> |numbers. I do use the wizards for those items, every time!)  I seem to h
ave
> |figured out the date and currency formatting uses of the "format" functi
on
> |for myself.  I have used lots of those in expressions in combos
> |and listboxes,
> |where I might draw info from several tables to make choices of say, art,
> |showing title, year of production, price, and medium.   I don't know any
> |way to make something like:
> |
> |"Water Tower", 2001, $1000.00, oil on canvas
>
>

Message #11 by "Carnley, Dave" <dcarnley@a...> on Mon, 10 Jun 2002 08:42:09 -0500
The way to be sure you get everything installed is to use the "package and
deployment wizard".  I don't know if this comes with access 2k or not, I got
my copy from the Office Developer CD.  It analyzes your project and creates
an install package that includes everything your app needs.



-----Original Message-----
From: Charlie Goodwin [mailto:cgoodwin@c...]
Sent: Saturday, June 08, 2002 10:43 AM
To: Access
Subject: [access] Re: Demons in my machine


Sorry to be so slow responding...

In the VBA Code Editor dmocx.dll is listed on my machine as a
ctv OLE Control Module.   Access assumes that dmocx.dll lives
in C:\WINDOWS\System32 .

When I started learning Access, it was on a NT3.51 machine with
a buggy copy of Access.   The wizards caused more problems
than they solved, so I sorted out how to produce stuff without
them.


Charlie




> My reference to wizards was more about having the Toolbox Control wizard
> turned on when you add a combobox or button to a form.  In cases like that
> you don't see it but the "wizard" creates code behind the form to make it
> all work.  All it takes is one form with code behind it or one module in
the
> database to cause the references problem.  What I found interesting is
that
> I searched my whole development system, Win NT4.0 sp6a Server with a full
> Visual Studio 6.0 sp5, and couldn't find a single file named dmocx.dll.
> What exactly is that for?
>
>
> |-----Original Message-----
> |From: Charlie Goodwin [cgoodwin@c...]
> |Sent: Friday, June 07, 2002 1:25 PM
> |To: Access
> |Subject: [access] Re: Demons in my machine
> |
> |
> |Hello all,
> |
> |I am going to try to respond here all at once to everyone's rapid and
> |generous replies to me.   With your expert help I have made progress:
> |
> |I have found two files to be missing from the library references
> |of one of the
> |machines my Db doesn't work on.
> |
> |I needed comctl32.ocx   which I did locate in C:\WINDOWS\System rather
> |than in system32 where Access was looking for it.   I made the reference
> |to it, and Access seems to be quite satisfied on that count.
> |
> |I still need dmocx.dll which is nowhere to be found on the second
> |machine I am
> |using as the "crash dummy".   Can I simply copy it off my original
> |development
> |machine (where it does reside) and paste it into the "crash
> |dummy"?   I don't
> |know dlls, and need to know how to get them safely installed in a
> |machine that's
> |missing them.
> |
> |I do not yet see an improvement in the Db, but with all this super
> |backup from
> |everyone, I think it will be running fine soon.
> |
> |In the future, how can I ensure other users will have machines
> |configured with
> |the correct libraries and references?
> |
> |Do I include all the files they might need in the package I send
> |out?   Or, do I
> |send out a dumbed down Db that requires only basic components that get
> |installed with every Access DB?
> |
> |In response to leoscott@c... , I tend to use few wizards.
> |Usually I can
> |produce faster and/or get more of what I want when I set things up
myself.
> |(Though I'm still baffled by the formatting on stuff like zip
> |codes and phone
> |numbers. I do use the wizards for those items, every time!)  I seem to
have
> |figured out the date and currency formatting uses of the "format"
function
> |for myself.  I have used lots of those in expressions in combos
> |and listboxes,
> |where I might draw info from several tables to make choices of say, art,
> |showing title, year of production, price, and medium.   I don't know any
> |way to make something like:
> |
> |"Water Tower", 2001, $1000.00, oil on canvas
>
>


Message #12 by "Charlie Goodwin" <cgoodwin@c...> on Mon, 10 Jun 2002 11:08:12 -0400
Hello,

Dave, I'll get the Office Developer package.

	>The way to be sure you get everything installed
	>is to use the "package and deployment wizard".
	>I don't know if this comes with access 2k or not,
	>I got my copy from the Office Developer CD.  It
	>analyzes your project and creates an install
	>package that includes everything your app needs.

With all the help everyone's offered, I've made real progress in getting
my Db to work on other machines.

Poking around my DB, I cleaned out a tiny chunk of code I was trying
out...an initial (and unsucessful) foray into VBA...and a test form that I
had been using to try out active x controls.

After backing up, I deleted those items, and then unchecked two
oddball library references I suspect those experiments had summoned up.

I pruned it down to the four libraries Gerald Rand had noted as usual ones:
1. Visual Basic for Applications
2. Microsoft Access 9.0 Object Library
3. OLE Applications
4. Microsoft ActiveX Data Objects 2.1 Library

I tested again.   Voila, it runs beautifully.   And it now runs properly on
a machine it didn't run on at all before.

Next I test it on other boxes to be sure I have deleted enough, but not too
much.

Thanks all!

Charlie







> -----Original Message-----
> From: Charlie Goodwin [cgoodwin@c...]
> Sent: Saturday, June 08, 2002 10:43 AM
> To: Access
> Subject: [access] Re: Demons in my machine
>
>
> Sorry to be so slow responding...
>
> In the VBA Code Editor dmocx.dll is listed on my machine as a
> ctv OLE Control Module.   Access assumes that dmocx.dll lives
> in C:\WINDOWS\System32 .
>
> When I started learning Access, it was on a NT3.51 machine with
> a buggy copy of Access.   The wizards caused more problems
> than they solved, so I sorted out how to produce stuff without
> them.
>
>
> Charlie
>
>
>
>
> > My reference to wizards was more about having the Toolbox Control wizard
> > turned on when you add a combobox or button to a form.  In cases like t
hat
> > you don't see it but the "wizard" creates code behind the form to make 
it
> > all work.  All it takes is one form with code behind it or one module in
> the
> > database to cause the references problem.  What I found interesting is
> that
> > I searched my whole development system, Win NT4.0 sp6a Server with a fu
ll
> > Visual Studio 6.0 sp5, and couldn't find a single file named dmocx.dll.
> > What exactly is that for?
> >
> >
> > |-----Original Message-----
> > |From: Charlie Goodwin [cgoodwin@c...]
> > |Sent: Friday, June 07, 2002 1:25 PM
> > |To: Access
> > |Subject: [access] Re: Demons in my machine
> > |
> > |
> > |Hello all,
> > |
> > |I am going to try to respond here all at once to everyone's rapid and
> > |generous replies to me.   With your expert help I have made progress:
> > |
> > |I have found two files to be missing from the library references
> > |of one of the
> > |machines my Db doesn't work on.
> > |
> > |I needed comctl32.ocx   which I did locate in C:\WINDOWS\System rather
> > |than in system32 where Access was looking for it.   I made the referen
ce
> > |to it, and Access seems to be quite satisfied on that count.
> > |
> > |I still need dmocx.dll which is nowhere to be found on the second
> > |machine I am
> > |using as the "crash dummy".   Can I simply copy it off my original
> > |development
> > |machine (where it does reside) and paste it into the "crash
> > |dummy"?   I don't
> > |know dlls, and need to know how to get them safely installed in a
> > |machine that's
> > |missing them.
> > |
> > |I do not yet see an improvement in the Db, but with all this super
> > |backup from
> > |everyone, I think it will be running fine soon.
> > |
> > |In the future, how can I ensure other users will have machines
> > |configured with
> > |the correct libraries and references?
> > |
> > |Do I include all the files they might need in the package I send
> > |out?   Or, do I
> > |send out a dumbed down Db that requires only basic components that get
> > |installed with every Access DB?
> > |
> > |In response to leoscott@c... , I tend to use few wizards.
> > |Usually I can
> > |produce faster and/or get more of what I want when I set things up
> myself.
> > |(Though I'm still baffled by the formatting on stuff like zip
> > |codes and phone
> > |numbers. I do use the wizards for those items, every time!)  I seem to
> have
> > |figured out the date and currency formatting uses of the "format"
> function
> > |for myself.  I have used lots of those in expressions in combos
> > |and listboxes,
> > |where I might draw info from several tables to make choices of say, ar
t,
> > |showing title, year of production, price, and medium.   I don't know a
ny
> > |way to make something like:
> > |
> > |"Water Tower", 2001, $1000.00, oil on canvas

  Return to Index