Attebtrion Larry Linson and everyone else Please- Re-Post

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Larry,

Excuse me for the re-post.

Also, I cannot understand what you mean by the Ticket
Printed Feild when a report was printed and a second
query to be run. Let me explain further:

1- I will have a form to enter record of every Trcuck and
Compressors, etc into a table.

2- I will have a form that will contain information on a
piece of equipment to be serviced and on this form a
click command button that says "Create Ticket" and it
creates a report which is based on a query - in fact this
is what I do have currently. what we need to do is to
have the command button to also look for any other piece
of equipment that may need to be serviced based on a
criteria, i.e. 3000 miles for Trucks and 250 hours for
Compressors, generators , etc.

3- i also have anothe table and a form that act as a
catalouge of filters, brand, number, cost and its
association to a particular equipment (TRuck,
Compressors, etc.), so i also need the ticket to look for
the machine, look for filters for that machine, cost,
etc. and include it in the report.

I think I am making things to be complicated but the only
things that I haven 't been able to do so far is the
number 3. How to have the report created to also lookup
the filters associated with machines that matches the
criteria and include it in the report.

Thank you in advance for you help and patient to bearing
with me on this.

Regards,

Mike
 
You need to add such a field, and set it for the items printed after you
print them. Otherwise, you may print the same item over and over. You would
clear that field whenever you set the date that the service was completed.

Larry Linson
Microsoft Access MVP
 
Thanks Larry,

I guess, I will come back here when I have my filters
lookup or catalouge table completed. I'm sure I'll have
questions when I make the changes and created my new
tickting system.

By the way, I'm still not clear on this Ticket printed
feild, what is this feild? its function? what the control
be on the form for this feild?

I don't bother you at this time, I need to do more first.

Thanks again.

Mike
 
Because you'll be checking for the need to print tikets, by date, but I am
assuming that you'll check more than once a month, you need to skip the
equipment for which a maintenance ticket has already been printed, so you
don't print another ticket for them, each time you check... which might be
every day or more than once a day.

After you print the tickets, you'll run an Update Query using the same
criteria that you used to print, setting the Ticket Printed field to Yes,
and part of your Ticket Print criteria will be that this field is No.

Once you perform the maintenance and enter the Date Maintenance Last
Performed, in the same operation, you'll clear the Ticked Printed field to
No.

Am I just confusing the issue? If I am, ask some specific questions about
what you don't understand about it.

Larry Linson
Microsoft Access MVP
 
Back
Top