Search results

Hi, I'm not much farther along than you in my database studies, but it seems to me that queries are not for relating input forms to; they are mostly for gathering information. The customerID in your form is based on a query and not on the original table. As far as I know, your input forms must...

The answer to the search/chart relationship Well Bill, since nobody else seems to want to answer your questions about this problem, I guess you have to answer yourself. What you need to do is agonize for several hours for several days playing around with your form that refuses to cooperate, as...

Hi, I'm having problems relating a pivotchart with search criteria automatically after the search - all on the same form. This will be a nifty trick if it is possible, and I can imagine other uses for a form like this. Without being overly wordy, I attach a mdb in hopes that someone with a...

Hi Gromit, I like your sample search form and will use something like it in my own project. As you gave permission to adapt this form for personal use, I made the small change of adding the btnSearch_Click event at the very end of the btnClear procedure to repopulate the sub form, as this made...

Magnificent Mentoring! Hi Gromit, Thanks so much for your help! Your simple, straight forward example ended hours and hours of 'Access Agony'. It worked flawlessly! I also looked at the WROX forum where you said 'credit was due', but that was a case of transposing columns to columns, not...

Gromit, Thanks for the help. After a bit of screen print work today, I will start following your directions, and thanks for the offer to post again if still stuck. I will look at the WROX example as well. I'm surprised that in all my reading and Access study I have never come across a...

I am having trouble arranging my data from a record row into a query that will give me columns for the pivot charts that I need. My guess is that I need some sort of a complicated SQL statement, and I know almost nothing about SQL. I have expressed the problem better, and with graphics, here...