[AccessD] Combo Box Query Fails

Max Wanadoo max.wanadoo at gmail.com
Fri Mar 26 08:38:41 CDT 2010


Yes, well I did tell you that when it was first posted (almost certainly a
missing reference).  Ahem!

BUT what we couldn't have known was which reference was causing the problem.


If you check the reference on-load up then it will tell you what is missing
and as long as that is the first thing it calls and the code itself passes
muster then you wouldn't have had that long discussion with the client or
this list.

Worth considering I would say.

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, March 26, 2010 1:32 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Combo Box Query Fails

Too true.  Slowest machine is actually between my ears.  In retrospect, it
was obvious.  

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Friday, March 26, 2010 6:27 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Combo Box Query Fails

Hmm, perhaps not but it would have told you where the problem lay within 2
micro-seconds (on my machine anyway, yours may be slower <g>).

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, March 26, 2010 1:23 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Combo Box Query Fails

However, reading your post I was just thinking that the problem occurred in
a standard module that used the Left function (a sure sign you've got a
missing reference).  So not calling those options that reference excel and
outlook would not solve the problem.

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Friday, March 26, 2010 1:22 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Combo Box Query Fails

Rocky
You could put the code I posted here earlier to run with the Autoexec on
start  up and if any reference are found to be  MISSING then the code could
report the fact that these dependent  options will not be available.  You
would then know that this was the case and set  a flag  in your program not
to call those modules.


Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, March 25, 2010 11:41 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Combo Box Query Fails

Problem solved.  I sent him a one-form mdb with the same references checked
as the mde.  And in the CBF I used the Left and CHR functions.  Sure enough
it failed, but this time I was able to see the problem.  It was missing the
Outlook library.  Although he bought O2K3 Pro and installed it he didn't
tell me he had not installed Outlook.  Adding Outlook solved the problem.  

But I think I have to figure out how to do late binding so that this doesn't
happen again.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, March 22, 2010 8:24 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Combo Box Query Fails

Make sure whatever shortcut they're using points to the correct runtime
executable, which IIRC is NOT Access.exe.  You can get problems unless you
point to the Sagekey exe.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, March 19, 2010 6:16 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Combo Box Query Fails

Can't check the refs because it's an mde.  But there should be no ref
problem with the Wise/Sagekey install.  At least I've never had one before
with any mde.

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Friday, March 19, 2010 4:39 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Combo Box Query Fails

Rocky,

My suspicion when "common" items such as these fail is that there is a
missing reference which has nothing to do with these particular  functions
but which just case Access to wobble.

Can he check the Refs to see if there  is a Missing one?

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, March 19, 2010 11:14 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Combo Box Query Fails

Dear List:

New user of my E-Z-MRP system does not have A2K3 so I sent him the runtime
(Wise/Sagekey).  The program file itself is an mde.

Runs fine on his box.  All other boxes on his network fail when he tries
this combo box that has a query as its row source.  The query uses Left,
Instr, and Chr(10) and that is failing.  

I discovered one difference between his box and the other - he's got Office
2003 Standard (no Access); the box we were testing it where it failed has
Office 97 - Word, Excel, PowerPoint.  

Could that be creating the problem?

MTIA

Rocky

 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list