Sample microsoft access database for trucking inventory
![sample microsoft access database for trucking inventory sample microsoft access database for trucking inventory](https://images.template.net/wp-content/uploads/2017/02/20230140/Access-Invoice-Report-Template.jpg)
Creation of weekly/monthly Order List from different suppliers based on consumption.Track In/Out of Parts/Lubes tied to orders/deliveries/requests - Inventory to be used mainly for regular maintenance parts not repair items/tires.To include ability to specify which tires (Front Left, Rear Right etc) are changed, dates changed, tire price history per machine Tire Change - Requests, Approvals, & History.Repairs - Requests, Approvals, & History.Miscellaneous Maintenance Requests - Approvals, & History (Items excluded from regular service i.e A/C maintenance).Minor/Intermediate/Major Service - Requests, Approvals, & History.Weekly Vehicle Checkup Logs & Warn about upcoming service based on latest machine hours reading.I would like the core processes of my DB to help me do the following: This allows us to keep an updated vehicle reading in order to plan for upcoming minor/intermediate/major services. We conduct a weekly checkup for all equipment where they are greased and meter reading recorded. Note: One additional minor service is required between the intermediate and major service.Įach service routine involves changing different parts, listed in tblEquipmentParts (a junction table that links PartNumber from tblParts and VehicleSN from tblEquipment). We have 3 service routines for each piece of equipment, Minor (250 Hours), Intermediate (500 Hours), Major (1000 Hours). Every piece of equipment has a routine maintenance schedule that varies depending on the reading. I will base my explanation on the image below.Įquipment, unlike vehicles, have their usage measured in hours not miles/kilometers. Here is the relationship map that I have developed thus far. I am hoping that this exercise will provide me with the skills needed to start optimizing our data management in other departments such as HR & Procurement. I’ve decided to tackle our equipment maintenance first, just because I’m very familiar with the processes involved and I know I can create a robust database for this activity. I know Access probably won’t match a fully fledged ERP, however we are still a small company and I think we can address 90% of our problems using access. I’ve tried so hard to get them to invest in a proper ERP, however they don’t seem like they’re gonna get behind that idea anytime soon. Part of me hates it because I miss the site, but also because our company processes run mostly on emails and paperwork. only trucks do.I work for my family construction business, and after a few years of doing some site work and getting some experience, I’m back at the office. Note: If you enter in txtlocation from inventory to Joes flat fix the popup box should not come up because neither location has a tire position. The purpose of this is so that the popup form can launch for editing. What I want to do is add another feature to this code and make it remember the previous entry in txtlocation only if you are changing the txtlocation from a number to inventory. What I have now is that if the txtlocation changes from one truck to another or from inventory to a truck the popup form called frmTirePositions will come up for editing. Ok if you open the database and look at 's either numeric or text.
![sample microsoft access database for trucking inventory sample microsoft access database for trucking inventory](https://www.heritagechristiancollege.com/wp-content/uploads/2019/05/access-2007-database-templates-free-download-of-27-of-crm-template-of-access-2007-database-templates-free-download.jpg)
In txtlocation you can enter a six digit truck number or a place where the tire is.like inventory. On the main form there is a textbox called txtlocation. The main form is called frmTireCertificate, the popup form is called frmTirePosition. I still need help on this thread if anyone can, it will save me Testkitt2 RE: Just like "IsNumeric" is there an "IsText" cmd ? PHV (MIS) 9 Jan 07 17:24 StLinkCriteria = "=" & "'" & Me!.OldValue & "'"ĭoCmd.OpenForm stDocName,, , stLinkCriteria If Not IsNumeric(Me!) And IsNumeric(Me!.OldValue) Then 'After updating location text box, this commands triggers the FrmTire_Position in db.Īnswer = MsgBox(" Do You Want To Add or Remove Tire Positions ? !", vbQuestion + vbYesNo, "DB Admin") The problem I'm having is when there is a trk number already in the "Location" textbox and then changed to non numeric the popup box should come up with the old value (the trk number) so that I can change or remove the info from the popup box for that truck. It only does part of what I want it to do.
![sample microsoft access database for trucking inventory sample microsoft access database for trucking inventory](https://support.content.office.net/en-us/media/7d5f4147-6732-4cb4-be98-1224f1f84983.jpg)
I pasted the code I'm trying to work with.