Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-06-2008, 12:59 PM   #1
rnickels
Registered User
 
Join Date: Dec 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
rnickels is on a distinguished road
How on earth do I do this?????

I would like to know if it is possible to have a query automatically run on the first day of each month. I want to be able to enter data into a table automatically using a query on the first day. I would prefer not to use Windows Task Scheduler as I will be distributing this database and want Access itself to automate the process

This would help me so much.

Rob

rnickels is offline   Reply With Quote
Old 03-06-2008, 01:07 PM   #2
ajetrumpet
Banned
 
Join Date: Jun 2007
Location: Universe - Local Group - Milky Way Galaxy - Orion Arm
Posts: 5,640
Thanks: 0
Thanked 99 Times in 46 Posts
ajetrumpet has a spectacular aura about ajetrumpet has a spectacular aura about
Send a message via MSN to ajetrumpet Send a message via Yahoo to ajetrumpet
You could write a simple IF, THEN statement in an AutoExec Macro to check the current date. That would work if you are wanting this process to run when you start the program.
ajetrumpet is offline   Reply With Quote
Old 03-06-2008, 01:09 PM   #3
pdx_man
Just trying to help
 
pdx_man's Avatar
 
Join Date: Jan 2001
Location: Portland, OR USA
Posts: 1,347
Thanks: 0
Thanked 3 Times in 3 Posts
pdx_man is on a distinguished road
If you don't have a scheduled Windows task, then how can you ensure the database is open and working on the first day of the month?

Basically you need to ensure a form is open and have the timer event set to check if Day(Date()) = 1

pdx_man is offline   Reply With Quote
Old 03-06-2008, 01:16 PM   #4
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,822 Times in 1,577 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
And then you have to set a flag, or something, in a table that would let you know it has already run for that month so it wouldn't do it every time.

Plus, what if you don't open it on the first (for example if it were a holiday or a weekend)? You would need the logic for it to check to see if it has run yet this month, regardless of what day it was. If it was, say Monday the 2nd, then it could run and then set the flag and not run again until it was the next month. But you would need to tell it how to determine what is next month.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 03-07-2008, 06:14 AM   #5
Guus2005
AWF VIP
 
Guus2005's Avatar
 
Join Date: Jun 2007
Location: The Netherlands
Posts: 2,498
Thanks: 48
Thanked 80 Times in 75 Posts
Guus2005 has a spectacular aura about Guus2005 has a spectacular aura about Guus2005 has a spectacular aura about
Seeing the subject of the thread i thought : "Hey i know that!"
Only to find that three other guys also knew that...

Good luck!

Guus2005 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Lets Stop George Bush before he Destroys the Whole Planet Earth. Bart Fishermans Politics & Current Events 748 09-27-2017 11:24 AM
Mile-O's Book Reviews Mile-O The Watercooler 30 08-14-2006 03:31 AM
Earth Policy Institute jsanders Politics & Current Events 27 03-06-2006 08:47 AM
What on earth did I do? DLFrye General 2 07-24-2002 01:02 PM




All times are GMT -8. The time now is 08:14 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World