Solved

access parameter pop up

Posted on 2013-01-31
14
394 Views
Last Modified: 2013-02-04
Every time I launch a form a parameter is requested even though I have checked every sub form and query that contributes to the main form.

Is there a way that I can see all contributing parameters to a form to tick them off a list, as it were, and identify which parameter is in the background that I currently cant find that is causing the issue?
0
Comment
Question by:owenja
14 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 500 total points
ID: 38839044
No there is no such list.
One place to look is at the parent child links in each subform (container) control in the main form.
0
 

Accepted Solution

by:
owenja earned 0 total points
ID: 38839090
Thanks peter57r - it was a subreport created a long time ago that still had a link to a CustomerName property - I had to drop and recreate the sub report to get rid of the old CustomerName property - thanks for your help on this..
0
 

Author Comment

by:owenja
ID: 38839769
I've requested that this question be closed as follows:

Accepted answer: 0 points for owenja's comment #a38839090

for the following reason:

I discovered this without the help from any experts on this occasion
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 16

Expert Comment

by:kmslogic
ID: 38839770
The author asked a yes/no question and Peter answered it--I think points should go to him.
0
 
LVL 1

Expert Comment

by:modus_operandi
ID: 38844611
I've requested that this question be closed as follows:

Accepted answer: 0 points for owenja's comment #a38839090
Assisted answer: 500 points for peter57r's comment #a38839044

for the following reason:

Starting auto-close process to implement the recommendations of the participating Expert(s).
 
modus_operandi
EE Admin
0
 

Author Comment

by:owenja
ID: 38844612
I object as the answer given although answering the yes no component was not correct - nor should another expert volunteer their input as a true answer would never be no or yes it should be supported by a request for more information or an explanation as to a solution.  I don't pat good money to be treated to yes no answers when it was quite clear that a solution was intrinsic to the questions framework ie why is the prompt continually popping up.  I solved this before I saw the answer from the expert (it was not the solution) - should rewards be given for not solving a problem??
0
 
LVL 16

Expert Comment

by:kmslogic
ID: 38844705
You asked if there was "a way that I can see all contributing parameters to a form to tick them off a list, as it were, and identify which parameter is in the background that I currently cant find that is causing the issue?"

And there isn't a way to do that, nice as it would be.  The actual solution as you found, and as Peter suggested, was to go through the subforms that are on your main form one by one to see which one is causing the problem.

I'll ask for a moderator to make a call on this and manually make a choice instead of using the auto-close functionality.
0
 

Author Comment

by:owenja
ID: 38845500
I reiterate - I solved this issue before I read the solution volunteered by your friend and as I stated in the comment when I assigned the points back to my account - that I did not use his solution.

Do you want me to give points for unused solutions to support your friend?

If I was to volunteer a solution and it was not used but it was vaguely in the direction of a solution should I then be awarded points for it?

I will also discuss this with a moderator and I don't like the inference that you will decide this issue - not the moderator?
0
 

Author Comment

by:owenja
ID: 38848548
Excuse me but you allocated all 500 points to the answer given by your friend - why did you do that?

Are we here to serve your desire for points or are you here to earn the points by contributing solutions not just yes no answers - again there was an intrinsic relationship between the request and what an expert would do given the scenario?

It is easy to say yes or no and harder to look for a solution - this attitude is why so many of the questions posted onto your boards are immediately answered (to benefit the experts - not the solution seekers).  If I wanted to look up answers I would not pay a premium membership - I would simply go to a free forum and get a yes or no.

I want to take this to the next level above you as a moderator and ask questions of this organisation as to what it aims to achieve - massage the ego's of the experts by rewarding them for the minimum of effort? - or provide actual solutions that are though out and not off the cuff responses aimed at elevating one up the hitters ladder of fame!

Should I pay money for solutions, get a yes or no answer that is useless or post the questions onto free forums please?

Please point me toward the next step in your objection process please?
0
 

Author Comment

by:owenja
ID: 38850548
Again - you are hiding behind logic to avoid any effort in answering questions - this is not a solution just an answer.  Does he get 500 points for answering yes/no?  What are you running here and why is it a paid service - get me the route to lodge a formal compaint please because this goes to the heart of what you are supposed to provide - do you not seek to ask for more information when the question is intrinsically aimimg to ask for a solution? Would I hten erfarme the question to invite an open response or do your experts just aim to win points only?

Where is the next port of call above the moderators please?
0
 

Author Comment

by:owenja
ID: 38850723
In fact forget it - I've just looked at your awards and in order for the winner to have won he would have had to answer 29.5 questions per day at 500 points per question - 365 days per year so it's no wonder that you guys perform the way you do - in with the minimum amount of effort - ratchet up the points - get the yes no answers answered and get your mates to moderate - probably and more especially around awards time no doubt.

This certainly is "Experts Exchange" because customers don't mean a monkeys....

Happy for you all!
0

Featured Post

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)

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

773 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