Search results

That works, thanks! However it is a little confusing that the user has to dirty the form for the CustID to show up. I added the code in both the on dirty event and the load event and it seems to work. Is that ok? If I wanted to I want to automatically display the corresponding Lat/Long...

May I ask where you are suggesting I use this? Or clarify what this code will implement? I was able to get help in setting up some filters for my well (author's table) and that has been implemented (see first thread I made on this site). I was very unsuccessful in exporting a filtered well...

HEY!!!! It took a while but I found something that was misspelled and corrected it! THANK YOU for suggesting! At this point, I am successfully going to a blank review form after clicking a hyperlink WellID. I need to figure out how to autopopulate the Well ID number on the review form. I also...

Hi Mr. Hartman, You are very correct, I am working with a one to many relationship (one being the wells and many being the "many" reviews associated to one well). For most of these wells, no "review" exist yet, but the goal is build something to store the multiple "reviews". I built the review...

Hi Arnelgp, You bring up a very very good point! I made the change but I was still prompted for a well ID number. I did go back and check my tblWells (which technically is a query using ODBC) and I found the the table from where the Well ID is pulled from for the query tblWells, the data type...

First, I want to say thank you to everyone/anyone who has read or responded to my past post. So helpful! Along the same lines, I’m very thankful for those who have answered other post as I am reading as much as I can. I think I need help finding an example using pass through acFormEdit (I hope...

Another duplicate thread, I apologize. I've read through as many examples as I could find. Even though the task seems very similar for most users, the approach seems inconsistent. So this command works if I want to export the entire table! DoCmd.TransferSpreadsheet acExport...

Closing out this thread with a few comments in case anyone reviews this! 1) I ended up using "I want the combo box to get the values from another table or query" and using a SELECT DISTINCT statement under properties>row source so that the combo box was limited to values existing in the table...

Wowza! I'm working my way through Access 2019 Programming right now. You may be right that some of the vba language will still be above my head a little bit, but I'll definitely put in some time! This is so awesome! I've found 3 different versions of the same exercise (6 combo boxes applied to...

The And/Or function is super interesting! I love love that it builds the SQL string on the bottom. I will study the script closer in detail tomorrow. Quick question, any reason why you chose to display the table within a subform rather than the general detail form? I started the project...

With respect to question 1. I want the options available on the combo boxes to be limited to the unique options available on the table. The example I reviewed online used option 2, but I think this person may have been implementing a different filter approach to implement on his form. I think...

Hello, new to VBA. I apologize for starting what seems like an infinitely duplicate thread, but the forum rules seem to indicate this is ok. I have the standard challenge of filtering a form based on multiple combo boxes. I’ve watched a few tutorials and I’ve managed to get myself a little...

Hello, also new. Regular user of access for querying through ODBC, new to VBA. Looking forward to collaborating and learning!