Search results

  1. P

    INSERT INTO via SELECT in vb.net oledb

    I am using OLEDB to connect to a Microsoft Access Database. There are three temp tables (Temp1, Temp2, Temp3) and a Properties table. I want to insert all results from a search of the Properties table where PropertyCode has a specific value. In MS Access I can do this with INSERT INTO Temp1...
  2. P

    Selecting two items from a single field

    I was able to do the AND query using three queries ... Query 1 selected PropertyDescriptionIndex of 15 Query 2 selected PropertyDescriptionIndex of 80 Query 3 I linked the HerbOilNameLink fields together Now, can I do this all in 1 query? Query Property15 SELECT Properties.PropertyIndex...
  3. P

    Selecting two items from a single field

    I want to be able to perform an AND search on a field where both specified values must be present for an item to be selected. I have a table with some properties of items. Each record in the table is for a specific item and one of its properties. Say for instance that I want to list the items...
  4. P

    select with join into a dataset

    If you know of a message with an example of this please provide a link or message number.
  5. P

    select with join into a dataset

    I have a database with multipe tables in Access. I am using VB.NET to create a front end to the database. I need to be able to do a select on one or more tables. Here is a select statement that I created in MS Access to show all the alternate names for the herb "clove". SELECT...
  6. P

    Create checkboxes during form open based on query

    I am working on a database that tracks products. The products are divided into groups (Bath Salt, Stick Incense, Candle, etc.) and these are store in a table. The products themselves are stored in another table. When a new scent is created, it can belong to multiple groups ... for instance...
Top Bottom