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 TouchToneTommy 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: *

  • Users: cmayer10
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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