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: Sumnor
  • Content: Threads
  • Order by date
  1. Sumnor

    Expression to Split a String at First Number

    Hello. I am building a query in Access. One of the fields included in the query (Device_Name) has values such as: EE10000-1 PRS10004-2 MTR10018 DS20000-462 My goal is to split the string to the left of the first number so that I can have a column in the query that only houses the alphabetic...
  2. Sumnor

    Save After Query Export to Excel

    I have an Access database running on a Citrix server that allows users to successfully export query results to Microsoft Excel. I use the following line in a module: DoCmd.OutputTo acQuery, "CourseOpty", "MicrosoftExcel(*.xls)", "", True, "" The problem is my users do not want to save the file...
  3. Sumnor

    Reference to Form Field in Query: Searching for Like Values

    Hello. I have a query that references a form field as query criteria: [Forms]![Team]![Team] The Team field on the form allows the user to select one (1) name. An example of some of the form field values: Sandy John Jennifer The query successfully brings back all records that meet that...
  4. Sumnor

    Date Syntax on SQL Anywhere Pass-Through Query

    I have created an Access SQL Anywhere pass-through query that correctly brings back thousands of records. I would like to limit the number of records returned to only those created since 01/01/2003. For some reason I am getting an ODBC Driver Syntax Error regardless of the syntax I use. What is...
  5. Sumnor

    How do I append a form text field with values from a form list box?

    I am using a form to define criteria for a report. It works beautifully when selecting one (1) value, but I want to select more than one value. I thought that I could create a list box (named 'Status_Choices') that houses all of the choices for my end-user (Low, Medium, High, Closed). The user...
  6. Sumnor

    Sterling Pound Sign

    Using Microsoft Access 2000, I need to format a revenue field in a report to reflect the Sterling Pound. Any thoughts on how to do this easily?

Part and Inventory Search

Back
Top