Solved

Problems with subforms in Access 2000 Runtime

Posted on 2004-04-06
12
1,140 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
 
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

911 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

22 Experts available now in Live!

Get 1:1 Help Now