HELP! i need an answer!!

[Guest]

I have two tables. One is a list of vehicles, and the other is a list of
duties for the day. I was wondering if it is possible for Access to alocate
these vehicles to the duties, in a seperate table automatically. Can anyone
help me, as i am quite new to this program. Thanx

 

[Joseph Meehan]

I have two tables. One is a list of vehicles, and the other is a list
of duties for the day. I was wondering if it is possible for Access
to alocate these vehicles to the duties, in a seperate table
automatically. Can anyone help me, as i am quite new to this program.
Thanx

Sure, but I can see about 12,876 different ways of doing it depending on
exactly what you want to do.

Could you be more specific? For example how do you determine what
vehicle gets what duties?

 

[Guest]

Thankyou for taking the time to reply.
The vehicles all have a code to determine which type of vehicle they are.
The duties all use the same code to determine which type of vehicle they
require. However, i have more vehicles than duties, and vehicles are marked
as available, or off the road. I want the computer to allocate the vehicles
that are available to the duties.

 

[Joseph Meehan]

Thankyou for taking the time to reply.
The vehicles all have a code to determine which type of vehicle they
are. The duties all use the same code to determine which type of
vehicle they require. However, i have more vehicles than duties, and
vehicles are marked as available, or off the road. I want the
computer to allocate the vehicles that are available to the duties.

That helps, but I guess I am still not sure what is happening and when.
Do you want Access to assign once a day, anytime it runs or at some other
event?

As I understand it when it is run you want it to look for available
vehicles and assign them to available duties. Can there be more than one
duty assigned to a specific vehicle at a time? How about more than one
vehicle assigned to a duty? What happens to unmatched but available duties
or vehicles?

 

[Guest]

The allocation would run on a daily basis, and only one vehicle would be
required per duty.
Unmatched vehicles would need to be marked as 'spare vehicles'. The user
would need to be able to update the allocation during the day if, for
example, a vehicle breaks down. The spare vehicles could then be manually
assigned. Note it would also be possible that there may not be enough
vehicles available to work all duties, and the system would need to show this
to the user.
Thanks for your help.

 

[Joseph Meehan]

The allocation would run on a daily basis, and only one vehicle would
be required per duty.
Unmatched vehicles would need to be marked as 'spare vehicles'. The
user would need to be able to update the allocation during the day
if, for example, a vehicle breaks down. The spare vehicles could then
be manually assigned. Note it would also be possible that there may
not be enough vehicles available to work all duties, and the system
would need to show this to the user.
Thanks for your help.

If and that is a big if, I understand what your needs are, Access can do
what you want. However it will require some programming in VBA to do it
well, and maybe to do it at all. The how is a little beyond the capability
of a newsgroup environment. In order to build this so that it works as
intended and reliably will take a good Access developer and he or she will
need a solid understanding of the business needs.