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 Mike Lewis 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. awarmplace

    odbc-call failed error

    I am getting an 'ODBC-Call Failed' error when trying to run an Access query that is pulling from a linked table in access that is linked to an SQL Server DB via ODBC Connection, can anyone help?
  2. awarmplace

    Trying to add row and complete Sequence

    I have an excel list that has an incomplete sequence and I want excel to evaluate each row and where there is a number missing in the sequence I want excel to add a row and the missing number. Example 8185 8214 8216 8217 8220 I need for excel to take the the out of sequence list above and add...
  3. awarmplace

    Union Query Not working

    I am trying to run a Union Query that will pull multiple Queries together from Multiple Access Databases. The fields in each access query are the same for all of the queries I am trying to pull together. I am getting an error message stating the the second query path. I have checked the path and...
  4. awarmplace

    Form Not found in Macro Condition

    I have a macro condition that is looking at the value in a combo box on a form and when I run the macro it errors saying form not found. Can anyone advise on how I correct the problem?
  5. awarmplace

    Open Excel workbook from button on access form

    I need to open an excel workbook by clicking on a button in an access form, how do I do this?
  6. awarmplace

    Passing Form Criteria to Crosstab Query

    I have a cross tab query that doesn't like the combo boxes that I have on a form passing criteria. How do you create a cross-tab query that will let you use a combo box for criteria? I am getting the msg box 'microsoft jet databse engine doesn't recognize 'form!formname![combobox] as a valid...
  7. awarmplace

    Creating CrossTab Qry passing Form Criteria

    I have a cross tab query that doesn't like the combo boxes that I have on a form passing criteria. How do you create a cross-tab query that will let you use a combo box for criteria?
  8. awarmplace

    Sending Pivot Table to Excel

    I have a Pivot Table Form in Access that I am trying to send to Excel using a button. I would like for the user to be able to click a button and have the Pivot table itself export to excel not just the data.
  9. awarmplace

    Query with Combo boxes as criteria

    Hi Duane, I am using the form to pass criteria to a query. I would like for the user to be able to select one or both drop down boxes. Example: Combo1 = Locations, Combo2 = Edit types....... As it is right now if a user picks a location and not an Edit the Query returns nothing, they have to...
  10. awarmplace

    Query with Combo boxes as criteria

    I have a form that has two combo boxes. I would like for a user to be able to select both or one of the combo boxes to run a query.

Part and Inventory Search

Back
Top