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!

  • 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: Steck
  • Order by date
  1. Steck

    Exporting Text File from ODBC Extract

    I have created the ODBC link to an Oracle databasein Access, then created a Make Table query to create a local table and write an output file. When I used the Export Wizard to export a text file to a FoxPro database to run a series of edit checks, the process fails without creating the export...
  2. Steck

    Transferring Data from Fields in Repeated Rows to a Single Row

    I have used Access to extract data from an exterior relational database and put it in a table by using a make-table query. The table consists of duplicate rows of records for individuals who are recipients of varying numbers of funds. One person's data may reside in a single row or in multiple...
  3. Steck

    Value Not Displaying in Form Field

    I have table called Jobs, one of whose fields is called Department, which is a combo box (drop-down list) referencing a table of that same name, created using the Lookup wizard. The primary key (hidden field) is the Department's budget number, and the Department's name is the value that shows in...
  4. Steck

    Value Not Displaying in Form Field

    Row source type isTable/Query and row source is the underlying table.
  5. Steck

    Value Not Displaying in Form Field

    A form data field does not display the data from an underlying table field in form view. The field type is a combo box. I've set the Bound Column property to 2 and the Column Count value to 1, to pick up the correct value from the list, but it displays nothing. When I click on the field, it...
  6. Steck

    Append Query/Field Validation Issue

    I have created an Access append query that extracts data from an external database (ODBC connection to Sybase database). The table to which I want to append the records has a Y/N field for which I have written a data validation rule to accept text values of Y or N from a six-position text field...

Part and Inventory Search

Back
Top