Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. shauntwo

    Losing subform current record after delete

    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...
  2. shauntwo

    Losing subform current record after delete

    Shirley, the answer to your question is yes.
  3. shauntwo

    Losing subform current record after delete

    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...
  4. shauntwo

    Losing subform current record after delete

    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...
  5. shauntwo

    Losing subform current record after delete

    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...
  6. shauntwo

    Losing subform current record after delete

    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...
  7. shauntwo

    Changing fonts with bookmarks

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

    Changing fonts with bookmarks

    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...
  9. shauntwo

    Using Eval() or other functions to reference string literals

    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...
  10. shauntwo

    Form controls won't bind to recordset - why?

    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...
  11. shauntwo

    Form controls won't bind to recordset - why?

    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...
  12. shauntwo

    How do I roll up a resultset?

    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...
  13. shauntwo

    How do I roll up a resultset?

    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...
  14. shauntwo

    Referencing an array value with Run method

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

    Referencing an array value with Run method

    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...
  16. shauntwo

    Referencing an array value with Run method

    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))...
  17. shauntwo

    Referencing an array value with Run method

    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()...
  18. shauntwo

    What's the best way to pass variables among forms?

    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...
  19. shauntwo

    What's the best way to pass variables among forms?

    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...
  20. shauntwo

    Auto-open a form or other Access object

    Thanks Jeremy - that was easy enough. Shaun

Part and Inventory Search

Back
Top