Pop up på dato

Just to get you on the right track as the solution could be mad in a number of ways.
If it is only a date you are concerned with then you can do it in a form when you open the application. If it is also the time then you will need to use a timer even which checks your table at specific intervals.

You could start by making a query with the criteria for the date field = Date() This will only show records with date = days date.

Héj igen Terry - Kan du uddybe det lidt for så er du kanon!!

Maria, is it just the date or do you want to take the time into concideration too?

Something else you should look at!
In Access 2000 and XP it is possible to use something called conditional formatting! If for example you have a form showing a number of detail records then you could get Access to change the colour of the date field IF it is todays date.

In design view select the date field and then on th eformatting menu you should be able to find Conditional Formatting.

Hmm ja det vil jeg næsten hellere - HVor lægger den der hedder called conditional formatting!!

in the menu under formatting!

Ok Terry jeg har fundet det der hedder betinget formatering - men jeg ved ikke helt hvordan jeg bruger det - Har prøvet lidt frem og tilbage

maks sure your date field is selected (in design view)
Then in the "betinget formatering" menu for teh first condition (Condition 1) your combo boxes/field should be
Field Value is equal to Date()

Then choose the Format (colour font etc.) you want to use when the condition is true.

Hej Terry - JEg kan godt bruge dit sidste svar - Men jeg vil gerne have uddybet første mulihed - Så formularen kun viser dem jeg skal opfølge på dages dato - Jeg forhøjer med 50 hvis du kan hjælpe mig - For Conditional Formatting løser ikke helt mit problem. DEt skal fungere mere som en huske liste for hvem jeg skal ringe til den pågældende dato!!! 1000 tak for alt din hjælp indtil videre..

Make a query and set the criteria field for the date column to
date()
this will only select the records which have the date = today.
You can then use this query to make a form which will then show the records for today.
You could also have a Yes/no field in the table and in the form this will be a checkbox. You can use this to mark those which you have taken action on. Then in the query you need to set the Yes/no columns criteria to False , so that only those which are NOT checked will be shown.

In the form you will then need to requery when you change the value of the yes/no field.

In the forms AFTER UPDATE event

me.requery

Hope you understand, if not you can send it to eksperten@santhell.dk and I will take a look when I get time.

you may also be able to use this
http://www.mvps.org/access/modules/mdl0042.htm

nillebis > er dit problem blevet løst? Hvis ikke vil jeg gerne senere på dagen lave nogle eksempler til dig m.h.t kriterier på datoer.
Du kan blot lægge din e-mail samt evt. uddybende forklaringer.

Hi mugs, I'm still here, hard to get away, afraid I might get caught :o)
I have sent an example so I think its under control!

Ok terry :o)

Hej Mugs Terry har løst det for mig - Ellers tak, men i ved jo begge at jeg sikkert vender frygtlig tilbage;_) - Tak for hjælpen endnu engang Terry

selv tak :o)