Search results

  1. T

    Word product catalog from Access data

    I would like to make a Word product catalog from product data stored in an Access 2007 database. How do I make the connection with the text data and how do I make the images display in the word document with the attribute right aligned and anchored with the text paragraph (how to set the Word...
  2. T

    Listbox SQL

    How do I make a listbox on a form to list all recommended customers? The form, named "Customer Form", is based on a simple table named "Customers" with the fields ID,Name,Recommended_by. The field "Recommended_by" has the datatype Long Integer and just stores another custromers ID number. On...
  3. T

    Junction table "lookup"

    I have three tables: 1. PRODUCTS ProductID ProductName 2. PRODUCT_CATEGORY Product_CategoryID ProductID CategoryID 3. CATEGORIES CategoryID CategoryName I want to make a Form where I can edit one product at the time and on that form have a subform where I can add categories to that...
  4. T

    Many-to-Many lookup

    In Access 2007 I have a Many-To-Many relation set up between Products and Categories (with a Products_Categories_Spec junctiontable between), so one product can have many categories and one category can belong to many products. I'd like to make a Form where I can easily set the categories for...
  5. T

    Merging 2 tables

    I have an Access 2007 table with two fields, ProductName and ProductSort: ProductName / ProductSort juice / cool juice / tropical juice / natural cola / cool cola / artificial And I want it to become like this: ProductSum juice, cool, tropical, natural cola, cool, artificial ..etc In other...
Back
Top Bottom