How to make dropdown list navigate records in a data access page?

O

onibara

I have built a database in Microsoft Access, but the default navigation
controls are unwieldy for the size of the database I have created. I have
made a dropdown list, but I have been so far unable to figure out how to make
it navigate the records.

Thanks for your help.
 
T

Tom Wickerath

Hi Onibara,

You're very welcome. I had a mini panic attack when I noticed the full
subject in the automatic notification message that I received. When I looked
at your question in the web user interface, I could not see the entire
subject text. I only saw this much:

How to make dropdown list navigate records...

I just assumed you were dealing with a form. However, I saw the entire
subject line of "How to make dropdown list navigate records in a data access
page?" in the Community Notification message I received. Are you telling me
that these instructions worked for a data access page? If so, I had no idea;
I wrote my document with normal forms in mind.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
O

onibara

Well, a form works just as well. This is for a small store, not a huge
office, and only three people will have access to the data, so I am going
with the form instead of the data access page. Of course, I would prefer the
data access page since it is better looking, but hey, as long as it works, I
am happy. Oh, and no, that method does not seem to work in the data access
page, but I could have been blind and not found the right button. (Oh, the
joys of being a power-user and not a coder.)
 
J

Juan

Hi,

actually i am trying to achieve this with a data access page, i would
appreciate it if someone can tell me how to do this.

thank you
 
J

Juan

tom,
sorry but this wasnt very helpful, in fact, it deleted all of the fields on
the page
 
J

Juan

Tom,

I guess you were right, i redid the page and this time it worked fine. But
now i have another problem, maybe u can help, the combo box displays all the
records out of order, how do i sort them out alphabetically?
 
T

Tom Wickerath

Hi Juan,

I just worked through this example KB article. The experience, which was not
a pleasant one, reminds me of why I have avoided Data Access Pages like the
plague. Personally, I wouldn't become too attached to them. DAP's are being
depricated in the next version of Access.

Try the following for the Northwind sample:
Create a new query. Add the Customers table. Add the CustomerID and
CustomerName fields to the QBE grid. Apply an ascending sort to the
CustomerName field. If you view the SQL statement, it should look like this:

SELECT Customers.CustomerID, Customers.CompanyName
FROM Customers
ORDER BY Customers.CompanyName;

Save the query as: qryCustomers

Open the DAP in design view. Click on View > Properties (if required to
display the properties dialog). Select the Data tab for the combo box. Change
the ListRowSource to your new qryCustomers query. Change the ListBoundField
to CompanyName. This seems to work in my tests.

Good Luck,

Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
J

Juan

Tom,

That works beautifully!!

thanks!

Tom Wickerath said:
Hi Juan,

I just worked through this example KB article. The experience, which was not
a pleasant one, reminds me of why I have avoided Data Access Pages like the
plague. Personally, I wouldn't become too attached to them. DAP's are being
depricated in the next version of Access.

Try the following for the Northwind sample:
Create a new query. Add the Customers table. Add the CustomerID and
CustomerName fields to the QBE grid. Apply an ascending sort to the
CustomerName field. If you view the SQL statement, it should look like this:

SELECT Customers.CustomerID, Customers.CompanyName
FROM Customers
ORDER BY Customers.CompanyName;

Save the query as: qryCustomers

Open the DAP in design view. Click on View > Properties (if required to
display the properties dialog). Select the Data tab for the combo box. Change
the ListRowSource to your new qryCustomers query. Change the ListBoundField
to CompanyName. This seems to work in my tests.

Good Luck,

Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
Click to expand...
 
T

Tom Wickerath

Hi RJ,
This solution is not working for me in Access 2003. (The articles provided
cover only 2000 and 2002.)
Click to expand...

The link I provided on May 3, 2006 pointed to the Access 2000 version. It
includes a link to the Access 2002 version, as you indicated. However, if you
scroll to the bottom of this page (http://support.microsoft.com/kb/285353),
you should see the following:

APPLIES TO
Microsoft Office Access 2003
Microsoft Access 2002 Standard Edition


My guess is that you did not implement the code as intended, but you didn't
say if you were getting any errors, or exactly what was happening on your
end.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
R

rjreilly

This solution is not working for me in Access 2003. (The articles provided
cover only 2000 and 2002.)

I've tried repeatedly paying careful attention to instruction in article. I
receive an error: item can not be found in the collection corresponding to
the requested name or ordinal.

I am on a network and when creating the DAP receive an error re specifying
absolute path in connection string of a page. I am uncertain where the
connection string may be found.
 
Top