Search results for query: *

Remou, I *guess* I could create an invisible text box that simply stores the PATIENT_ID that a user implicitly picks when they highlight a patient record in the subform. However, I'd prefer to understand WHY the reference to the subform's PATIENT_ID gets reset upon a (seemingly) unrelated...

Shirley, the answer to your question is yes.

No, I haven't. I suppose I can always turn to that, but I've got a sneaking suspicion that there's some method or property I just haven't considered yet. I'm stumped why a complete unrelated subform's current record would be affected by deleting a transaction in a different subform. I haven't...

It's not as crazy as you think. If I select patient "John Doe" in my Patient Search subform, I can click on the Transactions tab and see all transactions for John Doe in a different subform. If, for whatever reason, I want to delete one of Doe's transactions, after the acCmdDeleteRecord...

Thanks for the post, Shirley. I'm not sure my previous post was clear enough, so I'll try this: I've got Patient Search, Patient Edit, and Trasaction Edit tabs. In the Search tab, when a user literally clicks on the row in the Patient subform corresponding to the patient they "want", I want...

I've got a tab control that drives several things, and I'm running into a problem. The user searches for a particular patient using unbound controls, and a patient subform displays the associated results. When the user selects the patient they want in the sub form datasheet, this selection...

You're the man, Tony - your suggestion worked great. Thanks for your help.

Hi, I've got an ASK field that prompts for a simple string, and the result is stored in a bookmark. I want to be able to use the bookmark in both a document heading and page footer of my document. My footer font size is, say, 11, while the heading is bold and size 14. The problem is, when...

To sum up the scenario: I have a loop that moves through a recordset of field values, of text data type, that I'm attempting to assign to a field in another table bound to my form. For example, consider the following column: SOURCE_VALUE ----------- Now str_user_ID ----------- Now, in my...

I actually discovered the culprit shortly after posting the note - the form was initialized for Me.DataEntry = True, which prevented the controls from being bound to an underlying recordsource. After setting the DataEntry property to False, it worked like a charm. Of course, I ran into some...

To be brief, my situation is this: I have a main form with several text and combo boxes, as well as a subform, and the form's operations are driven by a binary option group, as follows: If option 1 is selected, all controls are programmatically unbound, the form's recordset is dumped, and the...

Allan, I haven't had a chance yet to implement your suggestion, but your solution is pretty slick, and you've taught me a couple of things I wasn't familiar with in Orace - aliasing the same table multiple times, and using TRIM, which I surmise is the same function as that in Office products...

All, I'm querying a table that, for the sake of discussion, has the following data: MODEL DESC_LINE DESCRIPTION ***** ********* *********** X 1 Super high-efficiency X 2 unit with widgets and X 3 gizmos. Y 1...

Yeah, I realized that last night after your post. Thanks for your great help. Shaun

That sounds like a great idea, but how can I pass all of the values assigned to a given row-dimension of vParameters? In other words, vParameters(y, 1) and (y, 2) might correspond to "1/1/2003" and "1/31/2003", but if my .Run line only refers to vParameters(y), I get a...

Rob, Sure thing. The first snippet of code below is in the module of my main workbook, which calls functions in other workbooks: For y = 1 To nRows If vArray(y, 1) = "Y" Then bActivity = False Application.Workbooks.Open (vArray(y, 3) & vArray(y, 4))...

Hi, I have the following line in a master workbook that passes certain variables to a given function in other workbooks: bActivity = ActiveWorkbook.Application.Run(vArray(y, 4) & "!" & _ vArray(y, 6), vArray(y, 3), vArray(y, 5), vParameters(y)) All of my vArray()...

Jeremy, Well, I don't have code set up yet in the Switchboard form, but for instance, if I have clicked on "Checking" (a label right now), I will need something in the On_Click event to assign the label name "Checking" to a variable. Right now, the On_Click opens my dummy...

Hi, I have a "switchboard" form that opens up several accounts in a personal finance database I'm trying to write. Whenever I click on an account label in the switchboard, I have a dummy transaction form that comes up, for which I'd like to display a recordset of all transactions...

Thanks Jeremy - that was easy enough. Shaun