If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Another MS Access Question

miju · 2004-08-02 14:15:13

Right quickie for ya'all I've done up a database in MS Access 2000 and basically want to publish the database to the internet to allow certain people I grant permission to. My problem is simple though (I think) When I'm using the web page creator and I put in a drop down box for counties when it appears on the web page it…

02-08-2004 2:15pm

#1

miju

Banned (with Prison Access) Posts: 8,486 ✭✭✭

Join Date: December 2002

Posts: 7957

Right quickie for ya'all

I've done up a database in MS Access 2000 and basically want to publish the database to the internet to allow certain people I grant permission to.

My problem is simple though (I think) When I'm using the web page creator and I put in a drop down box for counties when it appears on the web page it lists every single occurance of each county.

So my question is simply how do I put in a drop down box with just one occurance of a county (hope to god ya'll know what i'm waffling about)

0

Comments

#2 02-08-2004 2:31pm

PhilipMarlowe

Subscribers Posts: 4,419 ✭✭✭

Join Date: November 1999

Posts: 4178

http://www.w3schools.com/sql/sql_select.asp and read the bit about Select Distinct

0
#3 02-08-2004 2:38pm

miju

Banned (with Prison Access) Posts: 8,486 ✭✭✭

Join Date: December 2002

Posts: 7957

thanks very much

0