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
"Mike" <(E-Mail Removed)> wrote in message
news:1cb4f01c3887b$711348b0$(E-Mail Removed)...
> 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
> >-----Original Message-----
> >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
> >
> >"Mike" <(E-Mail Removed)> wrote in message
> >news:11b501c386e1$f98432e0$(E-Mail Removed)...
> >> 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
> >>
> >>
> >
> >
> >.
> >
|
Similar Threads
