Recent content by NeuronRider

Thanks for the suggestions guys, and sorry for the delayed response. Ended up taking a screenshot and color sampling the area I wanted to match in Photoshop (not sure why I didn't think of this in the first place). I may not have explained myself adequately the first time around. I needed to...

Quick question here I hope. I've got a little box covering up a drop down arrow on a combo control that resides on a tab control. The problem is that, since the Back Color property isn't available for a tab control, I have no idea what color it is...which is what the color of my box object...

Yeah, it's essentially a multiple choice questionaire, with the questions randomly ordered each time. I am actually shooting for one question per page. The thing I was shooting to avoid with the instanced forms is making up 38 identical copies of a form (one for each question) as a sub for each...

Hopefully I've explained what I'm shooting for well enough for this question to make sense. Would I be better off simply using a static source object to the one form on all tabs and changing the filter thru the Tab_Change event handler? I suppose it might pretty much achieve the same basic...

hrm. I'll have to mess around with that idea Lag, thanks. The reasoning behind the tab control is as an entry to a table recording answers to randomized questions. Currently, each question generates its own record within the table, keyed to the session ID, and two different values associated...

I remember having this problem a while ago. I thought about doing the same thing you just came up with... If I remember correctly, you can set focus to a hidden control. I may be wrong, because when I did it, the control was also not enabled that I tried to use. I ended up just picking any...

Kind of a strange one here. I know how to create the instances, but I don't then know how to refer to them to set the new instance as the Source Object of a subform control. For example, I have a form with a tab control consisting of 19 different tabs. Each tab needs to display a different...

Aright folks, clearly I must just be doing something stupid. I can't see why this is happening. Please help point out my idiocy ;) Here's the code: x = RandomNumbers(intHowMany, , intHowMany) q = 1 For n = LBound(x) To UBound(x) Select Case strCapValue Case...

Alright, I boiled it down to the following (allowing for some changes to variable names) Public Sub AssignPic(frmName As Form) Dim intI, x, n As Integer x = RandomNumbers(2, , 2) intI = 1 For n = LBound(x) To UBound(x) Select Case x(n) Case 1...

One more Q :D Kind of curious why one would want to Dim the vars like this. As in, not using the shorthand for multiple vars of the same type.

couldn't agree with you more, modest. I made some modifications to it yesterday that resulted in it actually working right, but I like you method better. I was already leaning toward using a select...case structure intead. As for the variable diming. I've had problems before with assigning that...

There we go :D I knew i must have been addressing it wrong when i started. I was even able to pass Me.Form. Much appreciated :D Now I need to go through my (slightly modified) For loop to figure out why both of my tabs get the same caption value... Thanks much for the assistance. -NR

Thanks for the suggestions. Both seemed like valid methods to me, but the first still resulted in type mismatch, while the later resulted in an error later in the routine associated with trying to reference the object as a form. Apparently that type doesn't support the function where I set the...

I'm guessing this is a pretty dumb question, but I'm getting a data type mismatch when trying to pass my argument from a form to my module subroutine. Here's the subroutine (which is likely not very efficient, nor complete): Public Sub AssignQA(objForm As Form) Dim intI, intP, x, n As...