Search results

Ok, I've worked through this. The solution was in setting a variable to the recordset value (rs!Formula) and using that in the following line: wbk.Worksheets("Formulas").Range(rs!Column & j).Formula = strFormula instead of directly using the recordset value like this...

Thanks to both of you for replying. chergh, you're right, the code you put in your reply does in fact work. I was using late binding in my code, so I tried setting it up like yours with early binding and my procedure still doesn't work. I need to use late binding because not all of my users...

Hi Bob, thanks for your reply. I was using: .Range("A1") = "=Sum(B2:B7)" Now, even with: .Range("A1").Formula = "=Sum(B2:B7)" The spreadsheet shows: =Sum(B2:B7) instead of the actual sum of B2:B7. It's like Excel sees the formula as text and doesn't actually process the formula unless I...

I've been searching the forums for some time now and have not found an answer to this question: When I write a formula to Excel using Access VBA, why does Excel show the formula syntax as the value of the cell instead of the result of the formula? How do I write my procedure to force Excel to...

Is there a property that I can use to change the datasheet for a chart from Series By Row to Series By Column?

Thank you very much for your time. I've figured it out. I was setting a couple of variables to the values in certain columns of the Product combo box on the subform and I had referenced them incorrectly. For some reason it was locking a table that is created by the main form when I select a...

It seems like it'd be easier for me to go jump off a bridge and end it all than to strip down this database. ;-) It's a front end for an Oracle data warehouse. The tables are created at run-time, so I'm not sure how to deal with the relationships. I can edit data on the subform and then change...

As best as I can tell, the links are set up correctly. If they weren't, I wouldn't think I'd be able to edit a product record on the subform and then successfully select a different customer on the main form. Again, it seems that the problem occurs when I use the Product combo box on the...

I'm very thankful to you for replying. However, I knew I ran the risk of miscommunicating by way oversimplifying the issue. I can edit the current record on the main form as much as I want and still successfully select a different customer from the customer combo box without having to create a...

I have a form with a combo box that contains a list of customers. Select a customer from the combo box and the form fields populate with general customer info. The form has a subform on it with a combo box where you can select products. Select a product from the combo box and the subform...

I'm not exactly sure what you mean. I suspect, however, that it's just a limitation of ADO because when I swapped the SQL with a simpler query, it worked fine. The DAO is working great. I feel I need a better understanding of the difference between the two. Anybody have any info? Thanks again.

I set the DAO reference, plugged in the code, and it's working. Thank you very much.

Thanks for your time. I meant "ADODB", not "ADO". Sorry. Could it be as you said, ADO is just freaking out on the nested query(s)? Thanks again.

Here's the code: Dim cnn as New ADO.Connection Dim rst as New ADO.Recordset strSQL = "SELECT qryChargeback.Sort, qryChargeback.[Process Level], qryChargeback.PLDesc, qryChargeback.ProdLineDesc, qryChargeback.Year, qryChargeback.[Reason Code 2], qryChargeback.Desc...

DAO.Database Gives me the "User-defined type not defined." error.

Here's the query: SELECT tblPlant.Sort, qryChargebackData.[Process Level], tblPlant.PLDesc, tblPlant.ProdLineDesc, qryChargebackData.Year, qryChargebackData.Month, qryChargebackData.[Reason Code 2], qryChargebackData.Desc, Sum(qryChargebackData.Amount) AS ChargebackAmount...

Even though the query works just fine on it's own?

Recordset.Open returns no records when I use a query with a join in it as the source. If I change the source to a simpler query (with no join), I get records. What's going on???!!!

Thank you. John, Once I weaved it in with the rest of my code (SQL-building loop, etc.), it works perfectly. Wish I could buy you lunch. Good on you. Pan

Thank you for your reply. Perhaps I should add some background information: An unbound form has a list box where you can select from a list of fields. When you click ‘Ok” on this form, it opens a query-bound form (frm1) in datasheet view that contains all the possible fields from the query (and...