Search results

Hi All - I have a mockup db attached. It represents our real world workflow needs. There are two tables: tblCampingTrip and tblTripDetails. tblCampingTrip has a field named MiscThoughts. How to populate that field from a 3rd open form is the subject of this post. There are three forms that...

Yep - adding Me.Dirty = False results in exactly what I expected to see. Now I can move on to my real question. :-)

Hi JDraw - yes - it s a mockup. In fact, it is a mockup for a different question. It is meant to be an anology for the structure I already have in place and that has been working as expected for a year. Thinking about how the real db works and specifically when a record is recorded to the...

HI all - super simple mockup attached. Two tables, two forms. Tables are related via the CampingTrip_ID field. The value of CampingTrip_ID is passed from one form to the other via OpenArgs and converted to a Long before being entered in the field control on the second form. The user opens...

Hi All - I have the following code that serves as the Record Source for a report: SELECT tblinspectionevent.datetime, [jobnumber] & [task] & [resource] AS Job, Operator.firstname AS Operator, tblinspectionevent.bundlenumber...

I'll try the SQL - AND YEAH - the not being able to close it is REALLY annoying - I forgot about code I have tied back to an Enabled/Disabled button on the main menu that I removed in order to make the uploaded db "easier" to navigate and clearly that was a mistake.

Honestly - I don't know. As I recall - I used the subform wizard to place all of the subforms into existing inspections forms. And they all work perfectly - checking the InspectionEventNotes table shows that the data is getting recorded. The above SQL: I opened frmInspectFab and copied it's SQL...

I changed it to this (taken and changed form one of the other inspection forms that is working correctly) and I'm still getting the parameter request for some reason: SELECT tblLineStop.*, tblinspectionevent.notes AS Notes_tblInspectionEvent FROM tblinspectionevent INNER JOIN...

Hi All - I have a main form that has a bunch of command buttons on it that open various types of data entry forms for various types of process inspections. The main form is bound to tblInspectionEvent. All of the various inspection forms each have an underlying table that is linked to...

JDraw - That did the trick! Thanks! I need to study DLOOKUP some more because I was confused about the final argument. (i.e., & Me.txtCoilNumber &...) I will look at OPTION EXPLICIT and try to wrap my mind around it.

The whole process starts at The Main Menu by clicking the "Inspections" button. When that button is clicked it opens frmInspectionEvent which is bound to tblInspectionEvent. The very first choice on that form is to choose a job number in the header. Job number is bound to tblJobs. There is a...

Hi jdraw - I am going to post an update to my other post because this question - as Micron correctly deduced - is an extension of my previous one which you helped with - which I found a solution for that - this is the next logical hurdle given the way I approached the other question.

Hi Arlen - and thank you. I tried your suggestion which makes perfect sense to me - but the form's Record Source is currently a query and the table I need to search is a lookup table and not the table that the final data will be recorded too so the recordset code is not returning anything...

Hi JDraw - Thanks (everybody) for sticking with me. I was off yesterday and it's been super busy with my regular task list at work today. I'm hoping to post something in a couple of hours because - yes - it is still a work in progress. Thanks! Tim

Hi Micron - you would be correct. This one is going the "other way" - but - - - - it's going to take some time to strip it down to where it isn't maddening for someone to just come in and check my specific question - because I do in fact have it working in the opposite direction where I capture...

I am receiving a runtime error 2471 "The expression you entered as a query parameter produced this error: 'the value i entered in txtUnbound' " Pounding my head on this one.

I just tried it to no avail. I have a DCount statement just before this line of code that tells me that the StringName is already in tblOfStrings which in my test it is but the zero disappeared from txtStringID and was replaced with nothing.

I've been looking at that but it appears that I need a string for the expression whereas - if I am understanding it correctly - I want a numeric value from an ID field. Would this be a matter of setting DLookup to search the ID field, grab the value as a string and then convert that back to a...

I know it sounds funny but it does work already in my situation under a different circumstance. When the form is opened it is for Data Entry and txtStringID is ready for a "New" value. Under a different circumstance where I enter a StringName into txtUnbound where my DCount does not find a...

Hi all, I have a form (frmGetAString) with an unbound textbox (txtUnbound) on it. That same form has a bound textbox on it named txtStringID which is bound to StringID in tblOfStrings. The user enters a 6-character alphanumeric string (StringName) from the real world into the unbound...