A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Find Specific Data



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2008, 05:39 PM posted to microsoft.public.access.forms
Corporate IS Solutions
external usenet poster
 
Posts: 1
Default Find Specific Data

I created a database in Access 2000 where it has a form that shows data on a
business. There are command buttons on that form; Contacts, Addidtional
Information, ect. When you click the Contacts command button the Contacts
form opens showing only contacts whose works for that business (there is a
business text field on the Customers table with a drop down box to the
business name from the Business table). The same is for the Additional
information button and other buttons. This feature works just fine with
Access 2000 and Access 2003. I put that database on a workstation with Access
2007 and that feature does not work. Even if I recreate the command button
from within Access 2007. When the buttons are clicked it opens a window which
is titles "Enter Parameter Value" and no matter what information I put in it
will not show specific data (which would be Contacts just for that business
which is shown in the current form). When any informaiton in put in the
"Enter Parameter Value" it displays every contact (not limiting it to the
current displayed business).

Again, in all previous verions this works just fine. Any help would be
greatly appreciated.
  #2  
Old April 15th, 2008, 12:08 AM posted to microsoft.public.access.forms
Jim Bunton[_2_]
external usenet poster
 
Posts: 52
Default Find Specific Data

Try putting in appropriate stop statements in your code to catch the point
where you can the sql that's being run at the point where your forms put up
the request for a parameter.

It may be you need to know the form recordsouce ( or the row source of a
control within the form) that's being triggered. When the code stops go int
immediate more and type ? me.recordsource or whatever or use debug.print . .
.. to do it.

Copy the sql then paste it into a new query and try running it. It then may
be clearer what the problem is - you can play about with the query 'til it
works for example.

Jim Bunton

"Corporate IS Solutions" Corporate IS Solutions @discussions.microsoft.com
wrote in message ...
I created a database in Access 2000 where it has a form that shows data on
a
business. There are command buttons on that form; Contacts, Addidtional
Information, ect. When you click the Contacts command button the Contacts
form opens showing only contacts whose works for that business (there is a
business text field on the Customers table with a drop down box to the
business name from the Business table). The same is for the Additional
information button and other buttons. This feature works just fine with
Access 2000 and Access 2003. I put that database on a workstation with
Access
2007 and that feature does not work. Even if I recreate the command button
from within Access 2007. When the buttons are clicked it opens a window
which
is titles "Enter Parameter Value" and no matter what information I put in
it
will not show specific data (which would be Contacts just for that
business
which is shown in the current form). When any informaiton in put in the
"Enter Parameter Value" it displays every contact (not limiting it to the
current displayed business).

Again, in all previous verions this works just fine. Any help would be
greatly appreciated.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.