Solved

Problems with subforms in Access 2000 Runtime

Posted on 2004-04-06
12
1,150 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
ID: 10771684
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
ID: 10772069
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
ID: 10772756
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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 26

Expert Comment

by:Alan Warren
ID: 10772777
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
ID: 10772974
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
ID: 10773014
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
 

Author Comment

by:earthman100
ID: 10776970
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
ID: 10777131
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
ID: 10777719
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
ID: 10778027
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
ID: 11076978
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
ID: 11077076
No problem.

Nic;o)
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

803 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