Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

access parameter pop up

Posted on 2013-01-31
14
Medium Priority
?
419 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
14 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
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…

670 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