Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / January 2006

Tip: Looking for answers? Try searching our database.

pop up message

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jiji - 11 Jan 2006 13:55 GMT
I am looking for a way to have a pop up message saying that my clients are
due to pay their bill with 3 days. pls help, I am not too much familiar with
macro or any other programmation but i can catch fast if you explain to me
in details. thank you

jiji
Patrick Salsich - 12 Jan 2006 15:22 GMT
A popup message will most easily be triggered by an event on a form.  The
opening screen of your app can do it, or use the "on current" event of any
form that is used to view the clients.  You could write some code to do a
dlookup on a table or query that has as one of it's output columns the
number of days left for any due date.  That can be done by simple
subtraction such as:   Now() - [whateverdate]

Easiest of all would be a simple report that opens in preview mode whenever
you start the app or whenever you ask for it.

personally I think popups are overrated. It's kind of "bells and whistles"
stuff.  Just run the report regularly.....

> I am looking for a way to have a pop up message saying that my clients are
> due to pay their bill with 3 days. pls help, I am not too much familiar with
> macro or any other programmation but i can catch fast if you explain to me
> in details. thank you
>
> jiji
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.