Search results for query: *

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.

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

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

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

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

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

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

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

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

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?

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

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

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