I am designing a page where a staff member can review all the information that people have submitted on our website and I want the staff person to be able to mark these records as "downloaded" so that they will not re-appear the next time the page is loaded. I am using access and unfortunately I can not use stored procedures which would have been the easiest option!

The page is one long page listing every entry without a check in the "downloaded" field in my database. I have added two hidden fields, one called hdDownloaded that I set the value as "yes" and another called hdDatedownloaded that I set to <%= Date() %> for the current date.

I have searched through all the tutorials here and other posts but can't find an explination that works on this. I also am open to doing it differently, i.e. downloading a file. I have set up a macro in my databse to run a query giving me what I want and also running an update query to mark them as downloaded but as far as I can tell, I am out of luck because I am using access.

Any suggestions, pointers, advice would be greately appreciated. I have been working on this for several days and can't seem to figure it out.

Thanks so much in advance for the help. I am really stuck! <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Brian Milner

What you can do is put the UPDATE code in the repeat region, here's a link to an earlier post:

www.udzone.com/forum/topic.asp?TOPIC_ID=14287&FORUM_ID=3&CAT_ID=2&Topic_Title=multiple+inserts&Forum_Title=Dreamweaver+UltraDev

Rather than using UD's Update behavior select Command(Stored Procedure) from the server behaviours window, then select Update from the list/menu.

Update commnand is in the format:

UPDATE TableName SET FieldName1 = Value1, FieldName2 = Value2 WHERE RecordID = RecordIDValue

Also there is a way of setting up INSERT, UPDATE and DELETE queries in Access and then using them like SQL Server Stored Procedures, heres a link:

stardeveloper.com:8080/articles/010701-1.shtml

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Hi Owen,

I would be really grateful with some assistance

Edited by - GarethTnash on 18 Apr 2006 23:28:29