Search results

Please excuse my ignorance. Where would I put that function in at?

So would I do a DLookup to find records by license plate and then a DMax to narrown down to highest Odometer value?

I would say the most recent would be the one with the highest value. Odometer never goes down so that's probably a safe bet.

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...

Having an issue. It worked at first, but as soon as I start to fill out the form, the VendorNo goes to 0.

It worked great! Thank you both for the help!

Hate to be a pain, but I'm very green when it comes to coding. Would you be willing to spell that out a bit more for me? Thank you!

That worked great to bring up the proper vendor but it autofilled the rest of the form with the last record. Is there a way to have it open to a new record while diplaying the VendorNo?

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...

Ah, good idea. I'll give it a go. Thanks!

Figured it out. May be a bit sloppy but I put this code into the forms Resize event. Dim intID As Integer Dim rs As Object intID = Me.VendorID Me.FilterOn = False Set rs = Me.RecordsetClone With rs .FindFirst "[VendorID]=" & intID Me.Bookmark = .Bookmark End With rs.Close Removed the filter...

Is there a way to build that command into the openform command?

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", , ...

Hmmm ok. I guess I need to reevaluate how I'm going about this. Very new to Access and Queries just confuse me.

So if I wanted to auto populate multiple fields, the correct way of going about it is by having separate tables for each field? Like a table for just company names, and another for departments and so forth?

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...

Nz(Me![ContactID],0) did the trick. I should've caught that. It is numeric so I was thinking the same. Thanks for the help! Much appreciated.

I thought about starting my own, but I wanted to give credit to who gave me my answer :) thought this might be the best place to do that. I tried DoCmd.OpenForm "Contact Edit", , , "[ContactID2]=" & Nz(Me![ContactID]) Got the same error.

This worked like a charm for me! Is there something I can add to the code to ignore blank fields? I have this set up in a datasheet as a hyperlink to edit a record, but I would also like to use the same hyperlink to create a new record and I keep getting the error: Syntax error...