Popup Reminder

[atticus1802]

Good Morning

I have posted on here numerous times and would like to thank everyone for their help. I have had an ongoing project at work to create a database showing employee details. This grew and became ever more complicated for a begineer who had never used access before.

Each employee now has a health and safety profile with various renewal dates these are all in the same table (health and safety) which is linked to the employee details table via a relationship of the employee number.

My question is:- I currently have a popup box which shows the expiration date via a query using "Between Date()-3 And Date()+7" as the criteria, however I cannot get this to work with more than one field. i.e. "DSE renewal date", "expectant mother renewal date"

I am a bit ashamed of posting my database as it is quite messy and I have broken basic rules, any experts would probably be ashamed to look at it however it was a project that grew and got a bit out of control.

Any help people can give would be greatly appreciated, ideally I would like each renewal date to be automaitcally added to an outlook calender and not being very good with VBA code im a bit stumped.

 

[Guus2005]

if i were an aussie i'd say: no worries mate. but i am not. i am dutch and i'd say: maak je niet druk.

Can you show us the query (or a part of it) with the problem?

Rereading your question something hit me.

Try this:

Select * from table1
where [DSE renewal date] between Date()-3 and Date()+7
or [expectant mother renewal date] between Date()-3 and Date()+7

HTH

 

[atticus1802]

Sorry about the late reply unfortunatly due to other work load this comes and goes as I have time.

I have tried using the 'or' function however this doesnt work and neither will show up in the query

 

[Guus2005]

A small tip b4 we continue: don't use spaces in fieldnames.

Could you post a sample database describing the problem?

HTH