Search results
-
D
Look up most recent value from the most recent record
Hello all, I have a database that tracks mileage and fuel for our fleet of trucks. We have a paper trip report that gets entered into an access database. On the form "frm_TripReports" there is an "OdometerStart" and an "OdometerEnd". Each trip report is specific to each Vehicle. Vehicle is... -
D
Open form to New Record but with a specific value in text box.
I have a form called "frm_Vendors" that lets you select a vendor from a combobox and then displays the vendors details. I would like to open another form called "frm_NewPurchase" that opens to a new record, but autofills the "VendorNo" text box with the "VendorID" from the previous form. Can... -
D
Solved Open form to specific record but allow record navigation.
Hello all. I have a form called "EditVendor" that allows you to edit a vendors details and I have a button called "SaveAndClose" that closes the form and opens up another form and goes to the same record. Heres the code (I know my names are sloppy): DoCmd.OpenForm "frm_Vendors", , ... -
D
Auto populate a table with description
I have a database for contacts with 2 tables. One table (Companies) being a list of companies with "companyID", "companyName", "StreetAddress", etc. The other table (Contacts) is a list of contacts with "ContactID", ContactCompanyID", "ContactCompany", etc. The tables have a relationship...