Solved

Problems with subforms in Access 2000 Runtime

Posted on 2004-04-06
12
1,129 Views
Last Modified: 2012-08-13
I have a database that loads fine in Access 2000, but when I load it in Access 2000 runtime, several of the subforms will not even load.

To debug it so far, I put code into the form_load events for the subforms that shows a message box when it is triggered.  When I load it in 2000, the subforms load first, followed by the load event on the form that holds the subforms, BUT

When I load it in Runtime, the subforms form load events don't even trigger before the main form's do, causing errors when it tries to refer to the subform's objects.

Any idea why it would bypass loading the subforms altogether, as it seems to be doing?  Is there a limit to the number of subform objects that can be loaded at a time by the runtime version?  ...because I have a whole bundle of 'em in here.  Any suggestions are very welcome.

Thanks!
0
Comment
Question by:earthman100
  • 3
  • 3
  • 3
  • +2
12 Comments
 
LVL 27

Expert Comment

by:jjafferr
Comment Utility
Hi earthman100,

if you like, you can email me you mdb after zipping it, and I will have a look at it.
click on my name to see my email in  my profile.
send me a brief desciption of the problem too.

jaffer
0
 

Author Comment

by:earthman100
Comment Utility
Jaffer,

As this is a commercial application and I have partners that would prefer not to have the source code "on the street" I respectfully cannot go that route.  No offense, but if you have any suggestions that may steer me in the right direction in this case, that would be great instead.  

Just to clarify, the app. runs fine in the full version(s) of Access, just not in the runtime 2000.
0
 
LVL 26

Expert Comment

by:Alan Warren
Comment Utility
Hi

re: because I have a whole bundle of 'em in here
not familiar with this problem at all, but could be related to the jet Error 3014 - Can't Open Any More Tables

http://www.mvps.org/access/bugs/bugs0010.htm

Alan
0
 
LVL 26

Expert Comment

by:Alan Warren
Comment Utility
Hi earthman100

re: causing errors when it tries to refer to the subform's objects
again, not sure what sort of referencing you are doing here but you may be able to reverse the process instead of sucking the information from the sub-form you could push the information to the parent

Me.Parent.txtSomeControl = Me.somecontrol

Alan

0
 
LVL 54

Expert Comment

by:nico5038
Comment Utility
Hmm, some thoughts:

1) Is the .mdb "clean compiled" (Run "Debug/compile all modules" when in VBA code)
2) Did you decompile the database before creating the runtime package:
   http://www.granite.ab.ca/access/decompile.htm
3) Do you work on the same Windows OS as where the runtime is implemented ?
    (XP gives me errors on A2000 databases that work under W98/W ME)
4) Are the references OK on the machines you install the runtime ?

Nic;o)
0
 
LVL 27

Expert Comment

by:jjafferr
Comment Utility
Sorry earthman100, I didn't read the question correctly the first time, I thought it was a normal Form/SubForm.

Two things:
1-
Are the ActiveX components included in your run-time distribution?
2-
try upgrading
Microsoft Data Access Components (MDAC) 2.8 Software Development Kit
http://www.microsoft.com/downloads/details.aspx?familyid=5067faf8-0db4-429a-b502-de4329c8c850&displaylang=en

jaffer
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:earthman100
Comment Utility
Thank you all for your suggestions so far.

References:  I have checked the references on the Runtime testing machine and they all seem valid.  All of the ActiveX controls are running fine.  Two of the three subforms that aren't loading properly have no activex controls on them.

Recreating Forms:  I have removed the subforms from the main form, compiled, compacted, decompiled, and then recreated them, with no luck.  

OS:  I am running the XP Home on the test machine and XP PRO on the development machine

Oddly enough, it just seems to have trouble with the three subforms and no others, even though there are about a dozen other subforms on the main form that load fine.  I am currently going back through my backups to see when they stopped loading, to try and find some clue.  ANy other suggestions offered would be of great help.  Thanks!

0
 
LVL 54

Expert Comment

by:nico5038
Comment Utility
Hmm, under XP Access acts differents as under W98/W2000 :-(
I've had trouble with parameter popups when closing a form (http://www.experts-exchange.com/Databases/MS_Access/Q_20662877.html) and looks to me this is a problem in the same "corner" of form eventhandling.

Nic;o)
0
 

Author Comment

by:earthman100
Comment Utility
I have gotten as far as realizing that when I remove everything from the offending form (controls and code), it still won't load, but if I create a new form and copy and paste all the controls and code into it, it seems to work now.

So....this is the route I am taking to fix it - rebuilding all three forms.  I have no idea why they have done this, but I am on the road to recovery.  

Thanks to you all anyways for your suggestions, I think I can make it from hgere on in!

0
 
LVL 26

Expert Comment

by:Alan Warren
Comment Utility
Thanks for the feed-back earthman100, it all helps.
Glad you are on top of it.

Alan
0
 

Accepted Solution

by:
modulo earned 0 total points
Comment Utility
A request has been made in Community Support to close this question:

http:Q_20990575.html

If there are no objections, a moderator will finalise this question after 4 days by:

- PAQ-ing the question and refunding 500  points

Please leave any recommendations here.

modulo

Community Support Moderator
Experts Exchange
0
 
LVL 54

Expert Comment

by:nico5038
Comment Utility
No problem.

Nic;o)
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now