By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Access Subreport within a main report problem

P: 19
I have some troubles with my database. I am trying to create a subreport within a main report, I tried this with two different ways. the result is the same in both ways.
Way #1 - In the main report, clicked Subform/Subreport icon and selected the subreport from the list which has been prepared prior.

Way #2 - In the main report, clicked Subform/Subreport icon then built the subreport form the corresponding query, so that the fields I want appeared in the Child fram within the main report.

In both ways, at the run time the database gets panic, and Access shutdown my application database.

Either main report or subreport is workig individually in good condition viewing the data based on the filter criteria.

Please if you can help on this, I would appreciate very much

Sep 12 '12 #1
Share this Question
Share on Google+
6 Replies

Expert Mod 100+
P: 2,321
RunTime is a special version of access used for running access on a PC that does not have the full package installed.

Please confirm or deny that this is what you mean.

Do you get an error message? If so what is the error number and description? If there is error in code, please post full relevant code, and indicate on which line it errors.

How is the subreport linked to the main report?

Have you tried compact and repair?

Does the database contain custom VBA code?
Sep 12 '12 #2

P: 19
Thanks for TheSmilyCoder for prompt reply.

Yes sir, I am confirming the descriped problem in my 1st post. Also I have attached two screen shots explaining what happen with me. (See attached: Problem with MS Access.jpg)

Concerning your questions:
1- The subreprot is linked with Date field which is present in the subreport and not appearing in the main report.

2- Yes, I have tried to compact and repair the database, no changes encountered same situation. (See attached: Problem with MS Access #2.jpg)

3- What did you mean with Custom VBA codes?

Attached Images
File Type: jpg Problem with MS Access .jpg (34.9 KB, 198 views)
File Type: jpg Problem with MS Access #2 .jpg (34.6 KB, 163 views)
Sep 12 '12 #3

Expert Mod 100+
P: 2,321
Your description does not seem to match your screenshots. The screenshots seem to indicate you are using a normal version of access and not a runtime version of access. Runtime is something your clients can use without purchasing the full version of access (In which you can develop and modify databases).

By custom VBA (Visual Basic for Applications) I mean code that you (Or someone else) have written in the access database to go beyond the native/built in functionality.

Have you created any macros in your database?

Is this fully your database, or have others taken part in developing it?

In design view, right click the control containing the subreport, and then view its properties, I would like to see whats written in the Link Master Field and Link Chield field properties.
Sep 12 '12 #4

P: 19
No custom VBA having codes with un-native functionality.
All of them are regular.

No macros in my database.

I have attached a screen shot showing you the Link Master Field and Link Chield field properties.

Attached Images
File Type: jpg Subreport property_link master & Child fields.jpg (55.0 KB, 254 views)
Sep 12 '12 #5

Expert Mod 100+
P: 2,321
I can't really see that there is anything obviously wrong. It could be an Access Error, or a corrupt database.
If it was me, I would probably try the following in the order suggested:
Make sure you have the latest service pack installed.

Try to create a new database, and then import all objects from the old database into the new database and see if that solves anything

Try to run the office installer and selecting Repair (I do believe it has a repair option).

Delete both the main report and the sub report and create both from scratch.
Sep 12 '12 #6

P: 19
I will try and see.

Thanks for the smileyCoder.
Sep 13 '12 #7

Post your reply

Sign in to post your reply or Sign up for a free account.