Search results for query: *

Perfect! Thanks so much.

But alas,the data is output from our financial software so I have to deal with it after the fact. Is there nothing I can do programmatically to fix it?

Right, so that does work, if I do it manually one by one. But since this will be a report we are running regularly, I need to fix the problem programmatically. And even if I do something like mystring = myworksheet.Columns(1).NumberFormat = "@" I still get the datamismatch error, and the...

Thanks, SkipVought. I tried that already and the #Name error remains and I still get the VBA error also.

All, I have an excel spreadsheet that I am trying to work with that is output from our organization's financial system. When I open the source file in excel, excel tries to read some of the text as formulas. The text in one cell is "-Room and Board"; I'm assuming excel sees the dash as a...

Thanks for the post. Parameters were the problem with my code. Collen

Hi All, To open a recordset based on a table I typically use: Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "Select * from [my_tbl]", CurrentProject.Connection, adOpenKeyset, adLockOptimistic How do I do something similar if I need to pull records from an existing query in my...

Thanks, Skip for responding. I actually just figured it out. I had problems in one of my expense queries that was causing the error when I tried to join it with another table. Best, CM

All, Suppose I have two tables: My Budget Table has the following fields: Program#, Year, Acct#, BudgetAmount. My Expense Table has the following fields: Program#, Year, Acct#, ActualAmount. Account Numbers (for telephone, salary, etc.) and Program Numbers (for case management, camp, etc.)...