Recent content by GeekyGirl

  1. G

    How can I make this work?

    I reworked the entire database and used subforms instead of the multivalued combo boxes. Everything is working great now.
  2. G

    How can I make this work?

    Sorry, I'm a little over my head with this situation so I'm not very good at explaining the details very well. No, I need to export the Access table into a csv file so that I can upload it to my galley on-line. Here is an example of 1 record as it sits in the table with the colored text being...
  3. G

    How can I make this work?

    Here is the situation: I have thousands of images in an on-line gallery. It is very time consuming to add the image descriptions, keywords, etc. through the gallery and I found a script that I can use to proprogate the MySQL database from a csv file. I have been experimenting with both Excel...
  4. G

    FileDialog and New Attachments in 2007

    I was able to get the file name to show in my form by using the simple expression =image.Filename Unfortunately, it isn't saving that value in the corresponding table so what am I missing to get it to save to the table field?
  5. G

    FileDialog and New Attachments in 2007

    Now that the new Attachments feature exists in version 2007 and has a field for the filename, do you still need to use the FileDialog to get this information? My situation: I am attaching a single image file to each record and want to store the name of the image in a separate field. My...
  6. G

    Adding New Image Links Through A Form

    I didn't know about the module. So I went ahead and added that. Now I'm getting a new error. Download the database file from here It is the Images form that I am trying to get to work using the Add Picture button.
  7. G

    Adding New Image Links Through A Form

    After reading that people have problems calling up the Microsoft FileDialog, I retried the sample you posted. I get the error: Compile Error: User-defined type not defined with the following line highlighted in the debug mode: Dim OFN As OPENFILENAME I'm just about going nuts trying to get...
  8. G

    Adding New Image Links Through A Form

    I have looked at your sample prior to posting but couldn't get the adding of a picture to work right. That is when I found the microsoft knowledgebase article that gave me the code seen above. Now if I can just figure out the error, I think I'll be OK. I worked with Access for many years...
  9. G

    Adding New Image Links Through A Form

    This link takes you to a page that says "Sorry no matches found"
  10. G

    Adding New Image Links Through A Form

    I used the FileDialog method from a microsoft article but am now getting the following error: Compile Error: User-defined type not defined I have verified that the Microsoft Office 10.0 Object Library has been checked in the references. Here is my code with the error location marked in red...
  11. G

    Adding New Image Links Through A Form

    Hello, I have searched through this forum about images and forms but it seems what I need is the next step... I have an Image table where I store the location of the image file. In my form, I am able to view each picture with each record perfectly using the directions from the Microsoft...
  12. G

    Create Check Boxes From a Table

    hello, I am creating a form to hold information about sample images that relate to sections of a class I teach. I have two reference tables that contain a list of Categories and Subjects. Instead of a Combo Box, I want to have an option group of check boxes where the values of the list...
  13. G

    Selecting Multiple OLE Objects

    I have a database to organize pictures by a series of categories. Once the database has all the images in it, the focus then becomes one where users will look through the images and choose 2 to be printed out next to each other. Ideally, I need to have a form that shows the images sitting next...
  14. G

    Retrieve the file name of OLE Object

    I have a form set up where the user can add, delete and view sketches as well as assign categories to each picture. I need to have the file name of the picture show up on the form and then be printed in a report. I set up a field called FileName and have a field for the link of the OLE object...
  15. G

    Printing the current record which has a subform

    Please disregard my earlier post from today...I have it working now. Thanks. GeekyGirl
Back
Top Bottom