469,127 Members | 1,279 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,127 developers. It's quick & easy.

Access Subreport within a main report problem

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.

Note:
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

Thanks,
mhegazy
Sep 12 '12 #1
6 2298
TheSmileyCoder
2,321 Expert Mod 2GB
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.

Questions:
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
mhegazy
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?


Thanks
mhegazy
Attached Images
File Type: jpg Problem with MS Access .jpg (34.9 KB, 269 views)
File Type: jpg Problem with MS Access #2 .jpg (34.6 KB, 225 views)
Sep 12 '12 #3
TheSmileyCoder
2,321 Expert Mod 2GB
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
mhegazy
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.

thanks
mhegazy
Attached Images
File Type: jpg Subreport property_link master & Child fields.jpg (55.0 KB, 313 views)
Sep 12 '12 #5
TheSmileyCoder
2,321 Expert Mod 2GB
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
mhegazy
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.

Similar topics

1 post views Thread by shaqattack1992-newsgroups | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.