[giorgospsk]

Hello
. I am working on an Access 2010 WEB-enabled database.
I have a table that stores dates, names (of the students) and courses (that the particular student missed, because of apcence) i created a query, so i can recall specific dates' apcence. i choose the available dates from a combobox, but the only thing i dont want is the duplicate values in that combobox. for example if,
on 12/23 there where 3 students not present, the combobox will show three times 12/23.

To avoid duplicates i have to use the SELECT DISTINCT and this is what i do. It actually works locally, but when i publish the database on my sharepoint site, it returns the following:
Access was unable to convert the query for use on the Web because it uses an unsupported query type, unsupported expressions, unsupported criteria, or other features that are not supported on the Web.

There is obviously something wrong about the SELECT DISTINCT, while working on sharepoint (web)

can you advice me??
thank you

[Ionut]

Can you post the query?

[giorgospsk]

Yes ofcourse.

i am posting you a very simple db, as an exmaple.
you will see instruction IN the form.
it is very easy..

just check out "search combobox" form..

the name of the db is database21 and the compression is done with WinZip.



thank you in advance

[giorgospsk]

i think i didnt attach it before..sorry

Attached File(s)

•  Database21.zip (53.42K)
  Number of downloads: 21

[Ionut]

I looked into your database and it seems that indeed Access has some problems with "Distinct" keyword. After a small research, I cannot give you any other piece of advice than trying to populate that combobox through a web macro and VBA. A google search will bring you some useful tips and code examples on this topic.

[giorgospsk]

thank you ofcourse for your time.

The problem is i know nothing about VB or macros (except the ones access 2010 contains)
so i dont really know where to look for the solution you descrribed me before

i also want to tell you that i have another simple webDB, that was made, as an example to solve a similar problem.

Should i post it so you check it?

[Ionut]

Quote

The problem is i know nothing about VB or macros (except the ones access 2010 contains)
so i dont really know where to look for the solution you descrribed me before

Unfortunetely, I don't have any other solution.

Quote

i also want to tell you that i have another simple webDB, that was made, as an example to solve a similar problem.

Should i post it so you check it?

Yes

[giorgospsk]

Soory for posting it with latancy..

Attached File(s)

•  SelectDistinctWebExample.zip (65.71K)
  Number of downloads: 47