Form with call data functions

[Anugerah]

Hi..

I am quite familiar with basic access to input record to show in report and create form.
But, I need to make different new stuff i never tried before.

I am working to make maintenance job card for all equipment.
When the maintenance date comes, I have to prepare a worksheet containing all work to do (like change engine oil and change fuel filter, etc) and spare parts required.
Different equipment will have different work and spareparts to do. Different service type (service A, B, C) also has differnet worksheet

So, I need a form that will automatically call the worksheet depends on the equipment that will undergo maintenance and its service type.
I also have to record all the worksheet that I have generated to mechanics


Is it possible to do that in access?

[ranman256]

yes. the car would have a tMaintenance table with services and the DueDate.

veh, Maint, DueDate
123, Oil Chg, 10/1/18
333, Fuel Filter, 12/1/18

the query would pull items to do that day (or week, etc)
then make report, or export to XL.
perform the mainenance, then reset the date.

[Anugerah]

yes. the car would have a tMaintenance table with services and the DueDate.

veh, Maint, DueDate
123, Oil Chg, 10/1/18
333, Fuel Filter, 12/1/18

the query would pull items to do that day (or week, etc)
then make report, or export to XL.
perform the mainenance, then reset the date.

Thanks for your response

But could I have the record for every worksheet I generated in the table this way if I have to reset the date?
I need every worksheet recorded so it will get unique ID each.

I attached form containing maintenance history.

I would like to add only the inventory number (vehicle number) and code (service type: A1/A2/B etc)
And then all the works below (change oil, etc) and spare parts could appear automatically from separated table prepared beforehand.
This way, I don't need to type all the works everytime I need generate worksheet.
This worksheet is generated before maintenance. It will contain all the works the mechanic has to do for every maintenance job.