Search results

Because I reopen Form2 later and want the visibility of the two buttons reversed. I'll see what happens.

Form1 has a command button that opens Form2. Form2 has two buttons on it, I want one of the buttons to be invisible when Form2 opens. Here's the code: DoCmd.OpenForm "frmLineStop", acNormal, , , acFormEdit, acDialog, Me.txtInspectionEvent_PK...

That and it's late on Friday and I'm still at work.

Thanks. Yeah - I was not clear that the WhereCondition was asking for field name form the underlying table. I wish I used some of these procedures more often so I could remember things like that. :-)

So I got that worked out. Replaced txtInspectionEvent_ID witht he field name InspecitonEvent_PKfrom tblInspecitonEvent and Form2 opens as I expected it too with the original user-entered text in a textbox. great so far. I didn't understand the MS Access help page.

Hey DBGuy - A subform would be great and make it much easier but I continue to be bound to this all going on a rugged tablet and screen real estate is expensive. I just tried using the WhereCondition method of OpenForm and of course I have done or understand something incorrectly. Even after...

Too close to the forest.................and still QUITE inexperienced - - - yet the moment you mention I totally get it and remember that there even was/is a WhereCondition :) Excellent! Thank You! Yet another little gem that I shan't forget.

Hi all - I have a table, tblInspectionEvent, that has many fields - one of which is Notes. The PK for this table is InspectionEvent_ID. I have a form used for data entry for Notes. It is opened twice - always - at the beginning and end of an event that may take a few minutes or a few days...

We have alphanumeric job numbers that all start with an uppercase letter - currently "A". Typical job number looks like: A732802001. Only the first character is a letter and I want it stored as uppercase. I have lazy typing sidekick coworker who routinely types a lower case "a." Aside from...

I do now. :)

Many MsgBoxes later..................I was like.................duh

global variable name typo. :cool:

Hi Guys - This post would likely be better placed in a new post but - especially you jdraw - are already super familiar with what I'm about to ask relevant to the rest of the prior discussion. Following the model you helped me work out in the CampingTrip mockup db, I've moved on to the Select...

That's a good model for me to follow. It's literally how one would write a list of things in a sentence. Won't forget that one. :-)

Sometimes...................sometimes Google is my friend...................... :) Other times?............................................... one wonders

I see now that there should not be a comma before the WHERE statement in the Immediate window. So much to learn.

<sigh> :) so many commas. I changed the line to read: " CoatingStopLine = '" & Me.cboCoatingIssueLineStop & "' " & _ .......and yes - it works! Ach du lieber. :) Thanks guys! I was going blind trying to figure that one out. I have learned an enormous amount with this "little"...

Thanks Jdraw. That's a great explanation. And I meant to tell you that the videos you shared earlier were also super helpful. The Immediate window and I are becoming well acquainted. So I've tried migrating the concept over to the real db ad truly thought I had it down but I'm stymied. I'm...

And if that is the case then why are there double quote around Me.txtMiscThoughts outside of the ampersands in this line: " SET MiscThoughts = '" & Me.txtMiscThoughts & "' , " & _ instead of reading like this: " SET MiscThoughts = " & " Me.txtMiscThoughts " & " , " & _ I'm just curious how the...

One more question - because I am beginning to see that the quotes aren't actually around the Me.tempCampingTrip_ID but rather around " WHERE CampingTrip_ID = " - so I get that part. But just so I understand: the ampersands are ONLY concatentating correct? They have no bearing whatsoever on data...