Search results

Thank you for your help, Pat. I appreciate it and hope it can help others.

Hey, Big Jim here... I have table X and table Y table X has column A, B, C, D table Y has column E, F, G, H If X.A = Y.E and X.B = Y.F, I would like to place ABCDEFGH on the same line. If these criteria are not met, I would like the data to still populate, just on seperate rows (ABCD or...

Big Jim just has to let you know that you guys are great. Thanks for all of your help. Both ideas were excellent and worked perfectly.

Hey, Big Jim here, Does anyone know if Access keeps track of where focus was set previously? Say I clicked from combo box to list box to text box. Is there anyway for me to view the user's selected sequence? Thanks in advance, Big Jim

Big Jim here, I would like to be able to select an item from a combo box (based upon distinct rows of information) and have my form move to the particular record where this item is found. Is there an easy way to do this? If not, a hard way is just fine. Thanks in advance, Big Jim [This...

Ok, Big Jim went and solved his own silly question. Assuming your array was in vntBase: Dim vntName As Variant Dim intI As Integer For Each vntName In vntBase intI = intI + 1 'Returns count of vntBase Next vntName Maybe I this will help someone else. Jim

Hey, Big Jim here, Does anyone know how to determine the number of elements in a dynamic array? I am sure this is an easy one, so thanks in advance for all of your help. Jim

Thanks Guys! You were both a big help. Big Jim got everything to work fine.

Hey, Big Jim here! I am trying to take a value from a single-rowed table and place it in my report header in a text box. I try to reference it in the Control Source, but I am having no luck. I am told that my field could refer to more than one table in my database. Oh, and it is sighting my...

Hey, Big Jim here... I am looking to change the rows selected in a combo box based on criteria establised elsewhere. How can I tell Access which rows to highlight? (combo box is already set to Multi Select)

I wanted to thank everyone for their suggestions. You have all been a great help. Big Thanks from Big Jim!

Hey Chris! Thankyou for the advice, but it did not work. What could be preventing my subform from showing the current query? If I close out and reopen the form, the data is accurate. Thanks again, Jim [This message has been edited by BigJimSlade (edited 10-11-2000).]

I have a subform that is not bound to my form. However, the subform's source object is a query that is executed by my form combo box. I would like to refresh the subform while still in form view. I tried .requery for the subform, but it did not work. What should I do? Jim