By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Date Manipulation in a Scheduler for Access

P: 1
OK, here's the quirk I have.

I'm building a scheduler for a Fire Truck Manufacturing company. They have like 8 date fields per truck to be built. If they have to squeeze in a truck between dates, they were wondering if they could have the dates of all the trucks post squeeze automatically be updated or not.

Say like they know that a rush truck job is going to put every other project behind by 6 days, I was going to have them go into a quick form, choose the truck ticket number, start/squeeze date, number of days delayed and a button that would run some VB code that would choose all date fields and truck numbers after the start/squeeze date and move them up by 6 days.

Any hints on where to start?
Sep 17 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
OK, here's the quirk I have.

I'm building a scheduler for a Fire Truck Manufacturing company. They have like 8 date fields per truck to be built. If they have to squeeze in a truck between dates, they were wondering if they could have the dates of all the trucks post squeeze automatically be updated or not.

Say like they know that a rush truck job is going to put every other project behind by 6 days, I was going to have them go into a quick form, choose the truck ticket number, start/squeeze date, number of days delayed and a button that would run some VB code that would choose all date fields and truck numbers after the start/squeeze date and move them up by 6 days.

Any hints on where to start?
Start with working on a backup copy of the working database :-)

What kind of table structure do you have? Is this in a Truck table?

You might be able to do this all in an Update query. That's probably where I'd start, anyway. Do up a nice stable SELECT query that pulls every date field for every truck that will be affected by the squeeze date. This will help you refine your selection criteria.

The standard syntax for an update query is as follows:
Expand|Select|Wrap|Line Numbers
  1. UPDATE [TableName] SET [ColumnName] = [Value], [ColumnName2] = [Value]
  2. (WHERE [UpdateCriteria]
Run this in vb code under your command button, etc.

This is a general overview, ask any questions you like for more specifics.

Regards,
Scott
Sep 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.