Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

access parameter pop up

Posted on 2013-01-31
14
Medium Priority
?
423 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
11 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 2000 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

569 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