Pop-up reminder from within access

[urfriend]

hello everybody,
being a non-expert in access is really killing me. i have this access assignment that i have to accomplish in a week time period and i'm pretty doubtful about getting it done the way i want it...
enough with the whining

i'd like to know how to implement a pop-reminder that runs reminding the user of the database of :
1. some to-do actions for the current day or, for example, a week ahead of a certain event, that is related to some date previously entered in a table.
2. this should be within the access database.
3. i saw something like that in the "databasedev.co.uk" website, but actually couldn't understand it.
i'd appreciate being as detailed as possible as i'm taking my first steps in ms access...

THANKS IN ADVANCE FOR YOUR HELP

 

[KenHigg]

Hint: Search 'form ontimer event'.

 

[AccessMSSQL]

Do you know how to create a query that will give you the records you need for your reminder? If you do you can create that query first. You can create a form based on your query. You will probably need to write a little bit of code to open the new form as a pop up form or dialog. You will need to check the query to see if records exist in it and if they do open the form. If not, don't open the form.

 

[urfriend]

thanks all for your reply, but apparently i either haven't made my request clear or haven't understood what you guys mean..

let me be more descriptive about my request:

suppose there are some members in a store who need to renew their discount membership. i need the access database of that store to tell the admin once he/she opens it that the member "so and so" needs to renew the membership, and this should be a pop-up message that appears once the admin opens the database.
it's like a reminder that pops up to tell that the time appointed for the membership of that particular customer is about to expire.

 

[Sketchin]

I think the guys (and girls!) meant to say they weren't going to do your homework, but were willing to steer you in the right direction.

 

[AccessMSSQL]

Thanks Sketchin. That's exactly right. @urFriend: the post I gave you gives you the steps you need to take to acheive your goal. The query you write will be how you check to see if a renewal is due. The form you create from that query will actually serve as your pop-up reminder. You will still need to write some code or Dcount function to check first to see if the query has any renewals due. If it does, you can then open the form - which will actually look like a pop-up reminder. These are one in the same. I don't know what the extent of your knowledge is. If you can write a query and create a form you are that much closer.

Here's a link that might provide more:

http://www.databasedev.co.uk/reminders.html

 

[urfriend]

I think the guys (and girls!) meant to say they weren't going to do your homework, but were willing to steer you in the right direction.

OMG!!
I'm just new to all this and this is far beyond my "access capabilities". I don't want or need anyone to do my homework; I just need some help on how to do it. I'm neither a developer nor a programmer, so, whatever is going on in access is like chinese to me. I'm exerting a lot of mental effort to get it. I do appreciate your patience, but it looks like I should have gotten a personal trainer rather than seeking youtube lessons before I begin working in access.
Anyway, I don't have enough time to look for and get that trainer, so I think I'm stuck with you guys (and girls)!!
Thanks... and again: I do appreciate your time and help

 

[KenHigg]

You might try buying a good book and using access's built in help

 

[urfriend]

Thanks Sketchin. That's exactly right. @urFriend: the post I gave you gives you the steps you need to take to acheive your goal. The query you write will be how you check to see if a renewal is due. The form you create from that query will actually serve as your pop-up reminder. You will still need to write some code or Dcount function to check first to see if the query has any renewals due. If it does, you can then open the form - which will actually look like a pop-up reminder. These are one in the same. I don't know what the extent of your knowledge is. If you can write a query and create a form you are that much closer.

Here's a link that might provide more:

http :/ /ww w.dat abase dev.c o.u k/r eminders. html

I tried the code in this link but it didn't work for me; whenever i enter it and try to open the database, it still opens the form and not the reminder first.
My trials though are restricted to my surface-knowledge of code building or vb

Is there any chance you can help me?? Apparently this code needs to be revised or rebuilt.
Thanks

 

[pr2-eugin]

This is not really a good way urfriend.. People have been helping you here on this thread.. and you have posted the same question, by creating two other thread..

http://access-programmers.co.uk/forums/showthread.php?t=236101
http://access-programmers.co.uk/forums/showthread.php?t=236103

People are trying to help you in their free time.. No one here is paid to do your work.. This is ridiculous..

All suggestions given perfectly apply to your scenario.. We can only give support; you have to do the research on the given input..

 

[urfriend]

This is not really a good way urfriend.. People have been helping you here on this thread.. and you have posted the same question, by creating two other thread..

http://access-programmers.co.uk/forums/showthread.php?t=236101
http://access-programmers.co.uk/forums/showthread.php?t=236103

. This is ridiculous..

All suggestions given perfectly apply to your scenario.. We can only give support; you have to do the research on the given input..

PLEASE:

I totally understand that "People are trying to help you in their free time.. No one here is paid to do your work."

The only problem is I sought help in different ways and form different people.
That's all.
I don't mind if no one answers me, not at all.
I'm very grateful for everyone who helped or even tried to help me.
Sometimes, though, somethings are beyond your capabilities, and thus seeking help in such things is not a shame...

 

[pr2-eugin]

Sometimes, though, somethings are beyond your capabilities..

Yes you are right.. Not everyone knows everything.. Not me (that's for sure).. I have been trying to help you in another thread.. taking some of my valuable time.. When I find that you have already found help here, it only makes things miserable.. for me.. I find it a waste of my time..

...and thus seeking help in such things is not a shame...

I agree there is no shame is asking help, that is the main point of this forum.. But triple posting the same requirement is not gonna help you in anyway.. People will only be annoyed.. Just like I am right now.. Am sorry if I am being rude.. but I am really not happy with your posting etiquette..

 

[urfriend]

@pr2-eugin:
Thanks, and sorry.
All what I received of help so far is putting me on the way- the right way-and I'm very grateful about it, but still I can't see through the dark.
I know nothing about codes, and that is why I'm stuck.