Search results

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

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...

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...

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?

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...

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.

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...

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...

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

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...

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...

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...

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...

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...

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

I already have a subreport created with a relationship existing between the child and master fields. Is that what you meant by linking them together?

Hello, I have done a search on this forum and found all the postings relating to printing only the current record for a report. I have a command button and have followed what these posts say. The report prints the current record but leaves out the data from the subform. The database is a...

Thanks for all your help. On microsoft's site, I found part of a chapter on security that discussed securing the database without a password and converting to the mde version that I think I will try. Maybe down the road I can afford the developer version.

I did include the workgroup file in my first attempt to transfer the file. But I did discover that I am not using a shortcut to point to the correct mdw file. I understand what I need to do now but still have a question. I know this has to do with programming and writing code which is were I...

Thank you for sending the thread. Unfortunately it won't solve my problem. I need to have more security so that the files can't be imported into another database and changes can't be made other than working with the data through the Form I have created. I was going to post my database but all...