473,320 Members | 2,193 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Report with Subreport gets Enter Parameter Value Message

The Problem: I have a report with one sub-report that give an Enter Parameter Value message on loading. The message appears when we open the report on a different computer than the development computer. When we go back to the development computer the error remains until we magically try something and compact/repair and the error disappears until the next time. The magical something is not consistent. For example: we could delete the link master and child fields and it will fix the issue after compacting and repairing but the next time we try this it does not fix the problem. We have not come up with any one action that fixes this or an underlying cause for the message. Below is as detail about the database, report and sub-report. Let me know if you need other information to help troubleshoot this reoccurring issue. Thanks for looking at it, I am extremely frustrated.

The Database: This is an Access Front End Database that has Linked Oracle and Access tables. In the next month or so all tables will be converted to Oracle but at this moment we are pulling data for the report from both Oracle and Access linked tables.

Data Source for Report: The report is based on a series of queries including 1 union query pulling from both Oracle and Access tables. These queries go down two paths and the final query pulls them both together with a left join. The queries are filtered from a form where the user has the option to enter parameters.

The Report: The report is set to show 2 detail records (Current and Baseline) for each Subproject in a linear view. I have grouped by SubprojectID but all the information is shown in the Detail records. The information that would show duplicates (SubprojectID, Subproject Title, Division, Status Indicator) are set to hide duplicates = Yes. There are multiple fields that are being conditionally formatted. The report also has 1 other grouping that is an expression (=1). We are using this to allow the page header of the report to show differently when the report footer (separate page) loads.

Without the Sub-report the report as described above runs great.

Data Source for Sub-report: The sub-report is based on 4 Tables (2 Oracle and 2 Access). The sub-report criteria is all set in the query (either hard coded or functions i.e. Month(Date()) ) and does not pull from the parameters. We are counting on the linking fields (SubprojectID) in the report and sub-report to limit the data on the report.

The Sub-report: The sub-report shows 1 field (Comments associated with the SubprojectID). The sub-report groups by SubprojectID but like the report the data is all in the detail. The sub-report also sorts by 3 other fields that are in the query and not showing in the sub-report. There can be multiple records in the sub-report linking to the two records in the base report for each subproject.

I hope I explained this so you are able to visualize this report and can help troubleshoot the issues. Below is a picture of the report in design view


I have tried everything I can think of and am still having problems.
Attached Images
File Type: jpg Snap1.jpg (37.2 KB, 290 views)
Aug 5 '13 #1

✓ answered by zmbd

It is only a guess; however, then I suspect that your issue is the different versions. A lot of weirdness can happen when different versions start messing with stuff.

Now, I hope that all of the clients are getting their own copy of the frontend. If not, then that is your first issue and hopefully once distributed to the clients this will fix the problem(s) (HOWEVER, I doubt this will do the trick - but it's an easy fix and easy is always worth a try :) )

I think instead that you are going to have to test my hypothesis. The only way I see to test this is to take at least one of the pilot PCs and install v2010 to it. I would HIGHLY advise a complete un-install of all prior versions of Office. Reboot at least twice... have all of the OS updates installed, reboot once more after the last update. THEN and ONLY then install your Office-2010.
Then Give that pilot its own copy of the frontend and go from there. I have feeling that this will solve the issue.

7 2941
jimatqsi
1,271 Expert 1GB
Can you run the sub-report by itself? Does it get this error sometimes/all the time?
Aug 5 '13 #2
Yes, I can run the sub-report by itself. The Sub-report runs successfully with no message when I run it alone. Once the report get the message it will stay until we take some undetermined action then it is good until we try it on a different computer and we get the message again.
Aug 5 '13 #3
zmbd
5,501 Expert Mod 4TB
Please be aware of the fact that your image is not available to most of us due to Local IT policies.
You can use the "advanced" editor to upload the image to Bytes using one of the image formats.
Aug 5 '13 #4
zmbd
5,501 Expert Mod 4TB
I've heard of this happening when two different versions of Access are used... is this the case here (You are using 2007/2010 on the development PC and an older version on the other PC)?
Aug 5 '13 #5
We are about to upgrade all computers to Access 2010 but the computers we have been pulling this report up on are not part of the pilot and have not yet been upgraded to Access 2010.
Aug 5 '13 #6
zmbd
5,501 Expert Mod 4TB
It is only a guess; however, then I suspect that your issue is the different versions. A lot of weirdness can happen when different versions start messing with stuff.

Now, I hope that all of the clients are getting their own copy of the frontend. If not, then that is your first issue and hopefully once distributed to the clients this will fix the problem(s) (HOWEVER, I doubt this will do the trick - but it's an easy fix and easy is always worth a try :) )

I think instead that you are going to have to test my hypothesis. The only way I see to test this is to take at least one of the pilot PCs and install v2010 to it. I would HIGHLY advise a complete un-install of all prior versions of Office. Reboot at least twice... have all of the OS updates installed, reboot once more after the last update. THEN and ONLY then install your Office-2010.
Then Give that pilot its own copy of the frontend and go from there. I have feeling that this will solve the issue.
Aug 5 '13 #7
I apologize for the delay in closing this thread. I have tested zmbd's theory about the issue being related to the two versions of Microsoft Access being used with this database at once. When I go into the database on a computer that uses Access 2010 and then open the database in Access 2007 I get a compile error and missing references for the Word and Excel libraries. I fix the references, compile VBA, and compact the database. Now my report runs. The odd part is the issue is happening with machines that are running Access 2007. The same actions are consistently correcting the issue. So my guess is that it has to do with the VBA not being compiled when the database was closed.

As for my users who have upgraded to Access 2010, I have created a copy of the database for them in Access 2010 and asked them to only use this database. These actions seem to have solved the issue so I am going to close this thread. Thank you all for your input and assistance with this issue.
Aug 15 '13 #8

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

Similar topics

3
by: Phil IU Guy | last post by:
I am having 2 issues, both acting very randomly, and for the most part I dont get this message on most computers, but I have had a couple computers get either issue 1, or issue 2. Issue #1: I...
1
by: Chuck | last post by:
I have a query that uses the query with the critera set to . We I run the query the msgbox pops up asking for the name information to be entered, but on the top (blue background) of the message box...
9
by: Megan | last post by:
Hi- I'm creating a database of music bands with their cds and songs. I'm trying to program an SQL statement so that I can enter a string of text in a textbox, press the 'Enter' key, and have...
1
by: Michael Quinlan | last post by:
I have a customer with an Access 2000 database that was created by a former (and no longer available for questions) employee of theirs. Recently, the "Enter Parameter Value" dialog began appearing...
13
by: cfrance1 | last post by:
Hello, I recently started working with access for a school project in my Information Systems Management class. I'm a Finance major so it's not like I had to get this deep into this stuff, but I...
2
by: billtubbs | last post by:
Hi I am getting the common problem of the "Enter Parameter Value" dialog box, which pops up every time I execute a query. I built the query using the Expression Builder in Access. If any of my...
1
by: waltnixon | last post by:
I've got an MS Access query which runs fine when double clicked and returns all of the rows in a test database I'm building. I've set up a multi group report based on the query. I immediately...
3
by: myemail.an | last post by:
Hi all, I use Access 2007 and have come across this error a number of times. I have two tables (customer information) which should contain - ideally - the same data. I create a query to compare...
1
by: Sport Girl | last post by:
Hi everybody, please can anybody help with this question: I an working with Acees 2007, and everytime I run a report I have a dialog box prompting "Enter Parameter Value" requesting for a...
2
by: Sep410 | last post by:
Hi all, I am using vb.net and Sql2005 and crystal report viewer in my application. the peroblem is when I run a report and I set the value for parameter a Enter Parameter value pops up.I shoudl...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.