Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cmayer10

    #Name Error in source data

    Perfect! Thanks so much.
  2. cmayer10

    #Name Error in source data

    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?
  3. cmayer10

    #Name Error in source data

    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...
  4. cmayer10

    #Name Error in source data

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

    #Name Error in source data

    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...
  6. cmayer10

    ADO Recordset based on query

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

    ADO Recordset based on query

    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...
  8. cmayer10

    Using Joins Right/Left Joins

    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
  9. cmayer10

    Using Joins Right/Left Joins

    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.)...

Part and Inventory Search

Back
Top