automatic warning popup!!!

[Guest]

Hi
I have various tables (numerous) with different information such as one
table of 'travel documents' or 'vaccinations', etc. I have been asked to
create a query(?) where, when, for instance, a visa, or passport is nearing
expiration or a vaccination is due, an automatic warning would popup when the
database is opened which would alert the user that a specific employee has 3
months left on their passport and needs to renew it. It is vital for this
information as there are employees all over the world who need to be as
up-to-date as possible with their travel documents and vaccinations as
neccessary. how would i go about creating such a query and would this involve
creating a macro which would automatically alert the user upon opening the
database each morning?

You may all be getting tired of my postings, but without all of your help, I
would be nowhere near to completing this database as I am now. So, Thank you!
but, i still have problems.

Rigby

 

[Jeff Boyce]

Rigby

A generic approach might be to:
* add a form that opens automatically on startup (see Tools | Startup)
* add code to that form's Open event
* in your code, create a recordset based on the query
* test the recordset created to see if there's any records (see .BOF and
..EOF properties of the recordset)
* if there are, pop up your message(s) (?perhaps forms/lists?), using data
from the recordset.

 

[Guest]

Hi Jeff

Thanks for you help. My problem is that I am not very Educated with VB. I am
learning as i go. I was hoping you could maybe help me more with setting up a
type of query to perform this function of looking up the near-expiration date
first. Or maybe point me in the right direction.

Thank you
Rigby

 

[Jeff Boyce]

Rigby

I don't see an easy way (i.e., a simple query) to do this -- but others
might.

It may be that what you are trying to do requires that you learn a bit more
about VBA.

I'm not saying that there's only one way to get there, but my response
pointed out one way.

Perhaps one of the other newsgroup readers can volunteer more time than I
can afford to ...

Good luck!

Jeff Boyce
<Office/Access MVP>

 

[Guest]

Dear Jeff

I appreciate you rtime and effort. Thank you for trying. I will look into it
more and I am constantly looking up as much as I can in books and all over
the internet. This Discussion group has just proven to be the most help.
Thanks again
Kind regards
Rigby