Solved

access parameter pop up

Posted on 2013-01-31
14
371 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
 
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now