Search results

I reread jdraw's #22. I've tried multiple variations. The two variables in the SET clause are both strings. The variable in the WHERE clause (CampingTrip_ID) is a number. It is an autonumber in tblCamping trip. The number is passed from an originally and still open form via OpenArgs to the frm...

I am certain that this: "SET tblCampingTrip.MiscThoughts = 3" is not what the final code will look like. This update query is used to take user input from an unbound form with unbound controls and place them in a table filling in fields of a partially completed record. The Immediate window...

This part I do not understand. The Immediate window just shows me the SQL as I intended it. Which led me to believe I had it correctly. Can you give me an example of concatenating "your variables with the strings?" Does this line: " SET tblCampingTrip.MiscThoughts = Me.[txtMiscThoughts], " &...

Here's the code I put together: Dim strSQL As String strSQL = "UPDATE tblCampingTrip " & _ " SET tblCampingTrip.MiscThoughts = Me.[txtMiscThoughts], " & _ " tblCampingTrip.TravelMode = Me.[cboTravelMode] " & _ " WHERE tblCampingTrip.CampingTrip_ID =...

I caught that tip as well. Thank you. Makes a lot of sense.

Thank you for this - especially the links to the tutorial and IslaDog's page. Just finished them both. I learned a ton from Phil's video. Suddenly feel much more confident with the comma placement, ampersands, and such! Now I just need to try it. :) This afternoon.

So what would the syntax look like if I wanted to SET a value to a second field? In other words: SET IsAvailable = False SET MyFavoriteColor = Green ........before getting to the WHERE clause? Remembering that I am going to use the approach you describe of putting the SQL in a variable. And -...

Dim SQL As String SQL = "Update TutorAvailability SET IsAvailable = False " _ & "WHERE Name = '" & Me.ListAvail.Column(0) & "' AND " _ & " UniClassname ='" & Me.ListAvail.Column(2) & "' AND " _ & " IsAvailable = True " In the above example - what is happening in the...

Thanks. That really helps - especially considering the major minefield of songle and double quotations! That really helps. Thanks.

I'm working through it. Went down a bit of a rabbit hole with the "INNER JOIN" bit of your code above. I don't think that is pertinent to my situation as all of the various fields I'll be updating are all in the same table. So now I'm looking for examples of wrapping a SQL statement with a...

A spark has caught! :-) WIth this code: CurrentDb.Execute "Update tblCampingTrip Set MiscThoughts = '" & Me.txtMiscThoughts & "' where " _ & " CampingTrip_ID =" & Me.tempCampingTrip_ID & ";", dbFailOnError ...........if I wanted to update mutiple fields would I just repeat the entire...

And your and others on this forum independent sets of eyes are truly why this db is finally working properly for us! Thank you as always!

I should mention that the table bound to Form 1 is the same table where notes and photos from Form 3 are stored. My primary reasoning for this is that we have a few different ongoing material and process issues that present across multiple operations (e.g., oil canning may manifest during...

Sometimes - actually very often - we could go to form3 second - or even first. It is the outlier and unpredictable real world circumstances that make it necessary to go through the forms for data collection in the manner I described and that you helped me solve. In a typical non-eventful...

Thanks Jdraw - works exactly as I had hoped! Sorry its been a few days. Work scheduling with this virus deal is nuts. I was just off four days but back on now for four tens. So: learning for Tim: I'm now studying your "CurrentDB.Execute" statement and also SELECT CASE.

Here's a related question: I have added another table and form: tblDifferentStuff and frmDifferentStuff. frmDifferentStuff can be opened from frmCampingTrip as a choice to use instead of using frmTripDetails. And then the process is intended to be the same as you helped me with above. Namely...

Exactly. Operative phrase: "the ability." Not always required. But when it IS required needs to be immediately accessible. And it needs to relate to InspectionEvent_PK.

Thanks jdraw - - that works exactly as I had hoped. I always forget about that very useful line of code. :) What this represents is: frmCampingTrip = frmInspectionEvent frmTripDetails = any given type of inspection form (each bound to a different underlying table) frmGetMiscThoughts = a popup...

Thanks jdraw. A long time ago I thought about approaching this whole project with subforms but there were certain peculiarities in our real world workflow that precluded that idea. I just posted my new question about an hour ago and I am certain that form/subform would have made this particular...

Thanks for the advice Ranman. But that portion of the workflow already works really well. If I take frmGetMiscThoughts out of the equation datat from both the other forms is being recorded correctly to their underlying tables....so no problem there. The challenge is getting new data from...