Recent content by cyberbob2

Hello, I am sending a value from an input form to a database/e-mail processing page which works fine, but I need to parse the value: TEST,TEST2 What I need to do is before the value even submits, parse out the text before the first comma, along with the comma itself, so I am left with: TEST2...

Skip, The rows of data being returned will vary each time. A PivotTable is something I never thought of, but I like the idea of simply querying the sheet to return another resultset with what I need. Could you show me an example of this or point me in the direction of where I might be able to...

Hello, I am using MS Query to pull external data conditionally which is working fine. I have a field where the user enters an order number, and associated fields for that order number (row) from the Orders table (SQL Server 2000) populate the cells as I have them mapped. Now I am trying to...

Hello, I have an Excel sheet using the MS Query tool (QBE grid) for pulling data from a SQL Server db into the sheet, works great. My question is, do the intended users ALSO need to have MS Query or can this sheet be distributed as a normal Excel sheet. Thanks in advance, CB

OK, I got it. Thanks for being patient with me. I'm a java guy, not used to their Microsoft stuff.

OK, so if I want to have a hidden sheet with all my populated cells and reference those cells, then I can do something like: =Sheet2!A1 Would this be correct?

I know this might seem strange, but I'm not sure how

Yes it does, but I cannot get those cells to map over to the cells I need populated. I tried copying the formulas from the populated by query cells to the cells where I need the data to display, (Copy-->Paste-->All), but the cells I need to update don't update when the value in the criteria cell...

SELECT Orders.order_name, Orders.order_number, Orders.order_status, Orders.dept, Orders.division, Orders.start_date FROM TESTDB.dbo.Orders Orders WHERE (Orders.order_number=?)

Hi PHV, Thanks, I can get all the table fields returned to one cell, but I can't figure out how to break them up so each field maps to a different cell on my hidden sheet. Once I get this I know I can simply copy the cells with formulas over to wherever I need them in the workbook. The hard...

Hi Skip, Thanks again. Once more question on this though. I have this working with one field being returned to one cell, but what I need to do is return several fields from one table and have them mapped to several cells throughout the sheet. Can't seem to get this to happen. Hope this makes...

Hello, sorry if I didn't explain it very well before. Actaully, what I'm trying to do is populate other fields on the form based on the value from a combo box which displays the id number, but the other fields are from different fields in the table. I'm populating the order_ids into the combo...

cool, thanks Skip :D

Hello, below I am populating a combo box using ADO/SQL Server connection. Could someone show me an example of how to populate other cells on the Excel sheet based on the value selected from the combo box? My code module: Public Sub PopulateControl() Dim cnRetailData As ADODB.Connection...

Hello, I have an Excel 2000 sheet I am able to bring data into and map to certain fields via the Query Wizard, no problem. But, it seems that I could do this through VBA automation and/or macro which might be better. Could someone show me an example of how to do this with VBA automation? My...