Search results for query: *

Hi Jennpen1 Sorry to be such a flake. Yep the TransferSpreadsheet works fine. It is actually kind of cool since you can create and Excel spreadsheet ahead of time and the TransferSpreadsheet action will export to it and create a target sheet in the workbook with the same name as the query...

Jennpen1 The concept is fairly simple though it is not obvious or optimal IMHO. You build the SQL statement by cycling through the selected items in your list box and then concatenating them into whatever your SQL statement needs to be. Use the SQL statement from the SQL view in the query...

Been running in circles as well living with it more or less for over four months. Had luck using 'Windows XP can ping but not browse' as a search term . Also found the winsockFix.zip by doing a Google search using winsockFix.zip. I am running SP2 so it didn't have any effect. I did...

Thanks Stephen Perhaps I did not describe my situation clearly. I was actually wanting to use an event that fired when they selected a tab. I was unaware that one could refer to a page on a tab control directly like that. Times before I would create stacked forms to emulate the tabed control...

Dreamboat Any specific references, resources, FAQs on this technique?. Someone mentioned 2002 Desktop Developer's Handbook which I have not yet ordered. Would appreciate any more pointers esp on-line resources. Why "textbox,yuk." ?

I have a tabbed control with three tabbed pages. I want to use the same subform on each tabbed page and just filter the recordset through a reference in the underlying query criterion. I know I could do it with an option group but I'd like to do it with selected tab -- either directly on the...

Or since you said it was a report you could also lauch the report since the underlying query is already now filtered by your combo box value. Or just filter the report with the same value The help file on DoCmd Open Report has some info: OpenReport Method Example The following example...

It can be a bit confusiing. I'm no expert but I have done this a few times exactly what you are trying to do... Given that you are only selecting one value to use in the criterion you would reference the full name of the combo control -- [Forms]![your form name that has the...

Thanks Duane I used your suggestion to achieve what was wanted. Worthy of a separate write up IMHO. Still, seems like going to Brooklyn from Chicago by way of Miami Too bad there isn't some simple function call like eval() to preserve the operators in a constructed parameter string. Again...

Thanks all for your help; however, I still seem to be at square one. I thought about just building the SQL statement dynamically as ugly as it is, but came to realize Transferspreadsheet will not accept a sql statement as an argument. As I said at the beginning, I had used the strategy in...

Yep I can take either the contents of the control that displays the result of my selections or retrieve the value through the Immediate window. Either way if I simply copy and paste that into the design grid either as an additional OR criterion or replacing the...

Leslie I meant the quote charachter depending if it is a single or double quote. Thanks PHV thanks for your comment. May I assume this is a SQL thing or idiosyncratic of Access? Does SQL act like and interpreter and that is why it distinguishes between a string passed as a parameter and a...

Belay my last -- the only way it works on single select with the In() operator is if i don't try to put any kind of punctuation around the selected value Sorry for the confusion

Oddly enough single quotes breaks even a single selected value. The only way it works is if I use " or chr(34) or nothing

I actually use a - 2 to get rid of the space as well from the ",

Yep Leslie that's what is happening

Darn...not fair

Sorry You would lauch the query DoCmd OpenQuery from the AfterUpdate event of the combo box

Yas Instead of "Like[Enter program name]" use "Like {name of a combo box control on a form] then create the combo box control either on an existing form or a little popup stand-alone form that can go invisible once the code is selected (it has to stay loaded so the control remains available for...

Thanks lespaul. I had already tried the In() approach before but did it again just to be sure. I even tried variations of quote marks around each selected value i.e. "'", " " ", and Chr(34). Every example for teh In operator shows the values with single quotes. None of them worked on...