I have ud 4 db acces 2000

Is there a way to do solf my prob

I lett users update an empty cel in my database (this is no prob )

No i want that the users of my site only can update a cel that is empty so that the users cant overwrite cels another user has filt in

For example you have a table : table 1
With 2 fields 1 unique ID and one remarks
i let them do a querry on unique id an leth them update the cel of remark but i want that they only can update a cel of field remark if its empty

Greets DarKPsyChO

Use WHERE to filter only empty fields. Something like:
WHERE Remark <> ''

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I have ud 4 db acces 2000
Is there a way to do solf my prob
I lett users update an empty cel in my database (this is no prob )
No i want that the users of my site only can update a cel that is empty so that the users cant overwrite cels another user has filt in
For example you have a table : table 1
With 2 fields 1 unique ID and one remarks
i let them do a querry on unique id an leth them update the cel of remark but i want that they only can update a cel of field remark if its empty
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I tried it in the advanced menu of the recordset but it gives errors can you be more specific please

my sql statement:
SELECT *
FROM Kalender
WHERE Dag LIKE 'varDag' AND Maand LIKE 'varMaand'

Variabels are:
varDag % Request.QueryString("dag"
varMaand % Request.QueryString("maand"

It should be something like this:

SELECT *
FROM Kalender
WHERE Dag LIKE 'varDag' AND Maand LIKE 'varMaand' AND Remark &lt;&gt; ''

Variabels:
varDag % Request.QueryString("dag"
varMaand % Request.QueryString("maand"

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I tried it in the advanced menu of the recordset but it gives errors can you be more specific please

my sql statement:
SELECT *
FROM Kalender
WHERE Dag LIKE 'varDag' AND Maand LIKE 'varMaand'

Variabels are:
varDag % Request.QueryString("dag"
varMaand % Request.QueryString("maand"


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>



Edited by - vfarcic on 06/27/2001 16:29:06

It still gives errors is it possible it has to do with the name of my fields the are:
8u tot 8u30
8u30 tot 9u
9u tot 9u30
and so one till 18u 30 tot 19u

(i am making an Organizer )
The point is if someone makes an apointment he can directly fill it in the organizer
But the field for example 18u30 tot 19u has to be empty Because otherwise other peole can overwrite it
I tried the sql statement mey times putted it in other places and think it is ='' in stead of &lt;&gt;'' but he always give the same error : Syntax errror missing opperatorin querry expression Where .......... (whole te where statement)