?
Solved

Problems with subforms in Access 2000 Runtime

Posted on 2004-04-06
12
Medium Priority
?
1,180 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

752 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