Search results

  1. L

    Displaying a 'matching record' message when entering data

    Hello, I have a consultation database where users enter data from a variety of sources, that may lead to the same person being entered twice (under different IDs of course). Is it possible to display a message such as "one record with this name" when a first and surname has been entered onto a...
  2. L

    Import text from file into one field

    Hello, I am looking to create a command button that enables users to browse to a text/Word document and then import the contents of that file into a Memo field. Any help appreciated! Thanks :)
  3. L

    Checkbox instead of listbox on subform

    I am creating a database that logs responses to questions and each contact can answer any number of questions. I have created a contact, questions and LinktoQuestion table, where all responses are logged. I loaded a continuous subform into the contact form and I was presented with the option...
  4. L

    Multiple choice questions

    All, I am using Microsoft Access 2003 (due to workplace practices!) and I need to allow each contact to answer multiple questions. For example: Contact 1: Answered question 1, 2 and 3 Contact 2: Answered question 2 Contact 3: Answered question 1 and 3 Ultimately, I need to store this...
  5. L

    Creating a postcode/regional report

    All, I am attempting to create a report that shows a breakdown of customers in regions. I have created a customer table, where there is a postcode field. I have created a postcodes/regions table that contains the first parts of postcodes and a corresponding region. I have created a query...
  6. L

    Assigning postcodes to regions

    Hello all, This is my first post on this forum and I apologise if it is in the wrong place. I am trying to create a report of postcodes by region, by use of two (unrelated) tables. TABLE1 contains a customer’s details, including their full postcode. TABLE2 contains a list of the...
Back
Top Bottom