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 Chriss Miller 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. ares13

    query w multiple criteria returned from function

    this works perfectly, interestingly after adding this into the querybuilder and running it, it no longer shows in the build view, but is there in the SQL view. Either way, it works! thank you for the help.
  2. ares13

    query w multiple criteria returned from function

    I have created an application that among other things includes a 'task' list... In the user maintenance section users are defined and can be added to 'groups'. When the user opens the app, a listbox shows the tasks assigned to that user, and should also show tasks assigned to any group the user...
  3. ares13

    another shrink grow form problem

    Looks like I have this working, thanks to both of you for your help!
  4. ares13

    another shrink grow form problem

    SuryaF thank you for taking the time to try and help me. I followed your instructions, and try and call the function when the form opens. I am get a type mismatch error on SCount = UBound(STops) I currently only have 4 items in the array. Looking at your code, maybe need to clarify some more...
  5. ares13

    another shrink grow form problem

    Thanks Eupher, yes, by lines I mean lines of text... your idea sounds interesting, I look forward to seeing what you figure out.
  6. ares13

    another shrink grow form problem

    First, thanks for your time on this. several things here; 1. using the function CautionMP provided, if the control doesnt have focus, it fails at Set objControl = Me.ActiveControl so that is why I first setfocus, then call the function. 2. The form is laid out in a specific order, section A...
  7. ares13

    another shrink grow form problem

    Thanks for the reply Eupher. I fear I may be in over my head here. This is the code I am using (it was provided here by CautionMP) to shrink currently...it may be close but every mod I have tried has just resulted in a blank form. Private Sub RepositionControlsRelative() Dim objControl As...
  8. ares13

    another shrink grow form problem

    I have a Mainform and a subform. The subform is a ‘summary’ form which contains about 30 textboxes with a label for each. Textboxes are arranged on the form as Label1 Textbox1 Label2 Textbox2 label 3 textbox3 Label4 Textbox4 etc Each textbox has a function as the controlsource, which...
  9. ares13

    form display problem

    I havent gotten that far yet, did initial testing in a simple test db, then started applying to mine. One thing I noticed trying this new method... I have buttons to the right of these text fields, using the array they did not move, using this method they do. I may just make a subform with...
  10. ares13

    form display problem

    OK, starting to work through this, and so far so good, works perfectly. I have about 80 objects on the form so it will be slow going to get it all worked out... pitfall?
  11. ares13

    form display problem

    hneal98, well, wouldnt say I totally understand but am making good progress :) CautionMP, wow, this works great! Doing exactly what I need. Couple of questions and I think I am there. In reference to your last sentence above, I actually have 2 controls on most lines, 4 on several. label_0 ...
  12. ares13

    form display problem

    Thank you both for the suggestions... hneal98, when I try this it says the object does not support that method...I would still be unable to format the headings as bold text if I understand correctly what you are suggesting and it did work. CautionMP, thanks for sharing that code. I have not...
  13. ares13

    form display problem

    hope someone can offer a suggestion. Have several input forms, and a 'summary' form with multiple unbound text boxes. The user starts on a mostly blank summary form, selects a button to go to an input form, returns to the summary form and sees the data they just entered. The control source...

Part and Inventory Search

Back
Top