Online access database that i want to be interactive

[ninefoureight]

hi, i have a database that i want people to be able to add to in an online enviroment however i want any records they add to be highlighted as unratified records. The way i was considering doing this was having a checkbox field for each record which is only editable by myself the administrator .. if the checkbox is ticked the record is ratified and the whol field is in black text however if the checkbox is unticked then the record is unratified and will appear in red writing when browsing the database. Is there a way to do such a thing and if so would some1 be be able to point me in the direction of some reading or solution on the matter. Thanks any help appreciated.

-nfe.

 

[Robert Dunstan]

Hi there,

Well your part way there by adding a check box field which only you can edit. Once you have that you can browse the database using a form and can either display the non ratified records where your check box = False i.e. no tick or you can display all and use some code to test the value of your check box ans set the fore colour accordingly:

If myCheck = False Then
Me.ForeColor = vbRed
End if

Also search this forum, you may find what your looking for.

HTH
Rob

 

[ninefoureight]

thanks rob for such a prompt answer, im currently searching and learning as i go. Cheers ;]

 

[ninefoureight]

hi rob where do i enter the expression ?

 

[Robert Dunstan]

Can you give me some more details like what it is you've done so far and what expression you are trying to do.

Rob

 

[mission2java_78]

hi rob where do i enter the expression ?

below you select al ratified records
SELECT * FROM YourRecords WHERE Ratified = True

and to select unratified records the opposite
SELECT * FROM YourRecords WHERE Ratified = False

You can use this in a query in SQL Mode.

Your choice though

Jon