Results 1 to 3 of 3
  1. #1
    NextGen is offline Novice
    Windows 8 Access 2007
    Join Date
    Apr 2019
    Posts
    4

    Create reliable and redundant reminder on Access 2007

    Hi,



    I have a clients access database (Office 2007) with the renew date for some particular products. My problem is that I need to find a way to set reliable (and redundant) reminders to some time before the renew dates.

    Ideally it should create a reminder on the database and send it to my Google Calendar account (which will then synchronize with my phone, of course).
    That way, even if I don't open the database, I will get a reminder on my phone.

    Another way could be something that would automatically (awake and) run database in background so I could get reminders on my windows desktop..?

    Now, I don't know if this is possible if MS Access is reliable enough.

    I also don't know where to start, but I'm open to anything that might help-me to achieve this...

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Can use VBScript (or some other batch file) to execute a VBA procedure in Access db. Use Windows TaskScheduler to run the VBScript.

    Example script:

    Set accessApp = CreateObject("Access.Application")
    accessApp.OpenCurrentDataBase "C:\Users\Owner\June\LL\Umpires.accdb"
    accessApp.UserControl = True
    accessApp.Visible = False
    accessApp.Run "TestVBA"
    accessApp.DoCmd.RunMacro "TestMacro"
    accessApp.Quit

    and this:

    Set cn = CreateObject("ADODB.Connection")
    cn.open = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\Users\June\LL\Umpires.accdb"
    cn.execute "INSERT INTO Rates(RateID,RateLevel) VALUES('zz','zz')"
    cn.Close
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I would also use Task Scheduler to run the database at set times but would use it to send an email from Access to yourself using CDO (Collaborative Data Objects)
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. create MS Access 2007 report
    By k_mohsen in forum Reports
    Replies: 1
    Last Post: 10-27-2013, 11:24 AM
  2. Create line chart in ms access 2007
    By bubu77 in forum Access
    Replies: 1
    Last Post: 02-16-2013, 10:07 AM
  3. Replies: 20
    Last Post: 06-27-2012, 02:19 PM
  4. How do I create a list? Access 2007
    By shabbaranks in forum Access
    Replies: 1
    Last Post: 10-14-2011, 06:01 AM
  5. Create a query in VBA, Access 2007
    By laavista in forum Access
    Replies: 3
    Last Post: 06-22-2010, 07:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums