Recent content by Guy_Philly

  1. G

    Select multiple items from dropdown list

    Thank you all for your help. Below is the final code that worked for my situation: Private Sub SelectExpertise_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strSQL As String Set db = CurrentDb() Set qdf =...
  2. G

    Select multiple items from dropdown list

    RG, That is an excellent resource. Unfortunately, I think I am still implementing the list box incorrectly. I have the following objects in my Access 2003 database: tblContacts: This holds a lot of different information about people (names, addresses, various contact info, and Expertise). I...
  3. G

    Select multiple items from dropdown list

    Thanks RG, Now that I have implemented the list box as you have suggested, it has a few quirks. The main thing is that after selecting multiple items from the form, I would like to be able to display all the selections made for a given record in a report. How would I do this? The other...
  4. G

    Limitations of using Access with multiple users on Intranet

    request for info implementing "Front end/back end" Thanks for your feedback. Can you give me a little more information about how to implement a "Front end/back end approach"? If you know of a good resource that I can get that explains this, that would be good too. Thanks again, Bruce
  5. G

    Adding pictures to forms and reports (Access 2000 vs 2003)

    I have successfully used the recommended way to display images from a folder in a form as posted on the microsoft website. http://support.microsoft.com/kb/210100/ These instructions were for Access 2000. I noticed that there are seperate instructions for doing this using Access 2003...
  6. G

    Limitations of using Access with multiple users on Intranet

    Hi, I would like to use an Access database over an Intranet. What are the limitations of doing this? I want multiple individuals to be able to open forms and enter data. I would also want others to be able to run queries and reports on the database. Would I need to upsize to an Oracle...
  7. G

    Select multiple items from dropdown list

    Hi, I would like to be able to select multiple items from a dropdown list like we often see on web forms. The kind where you hold down the control key to select up to 5 items. Is this possible on an access form? If so, how would do we implement, and how is such data be stored? Thanks! ~Bruce
  8. G

    Creating Multiple subforms

    I am trying to add multiple subforms (or subtables?) on an existing form. The underlying table is a very detailed descriptive table for art in a collection, I am already using one subtable to manage the movement in and out of inventory. When I look at the table in the datasheet view, I see the...
See more
Top Bottom