Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

access parameter pop up

Posted on 2013-01-31
14
Medium Priority
?
422 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 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

972 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