Recent content by hijfte

THANK YOU SO MUCH!! That worked perfectly!!

Attaching a zipped file of my database. Thanks!

I tried playing around with the link you gave me, but it would take a very long time to add all 1000 images manually using the interface provided and I believe that was a similar interface to what I was using to display my pictures. I have hundreds of hours invested in adding the data to this...

So, are you saying I can't filter my form because of something in the macro I'm currently using? And if I use the linked example, I won't have this problem?

I'm happy with the pictures displaying in the form. I'm just looking for help with why my filter doesn't work with the form. Is there any way to get the filter working on the form?

Noob needs help, please. I have a database to catalog a crown cap collection. The form I am using shows a picture of each cap and has a bunch of fields (breweryName, City, State, Country, CapDescription, Color, etc). I was originally attaching each picture to the form, which I quickly found...

I have fields in my form (frmPicture) called Name, City, State, Country, Color, and backgroundColor. Many of these values will be used multiple times, and I don't want to type them out every time. I don't know all the values at the beginning of the project, so can't just create a list. I...

Yes!! When I change the RecordSource to grab some fields from tblCaps and some from tblPicture, it appears to be pulling from the specific tables rather than just tblPicture. However, I have a couple problems now. 1)none of the fields are incrementing. There are 1045506 records (should only...

When I try clicking the gray square and then clicking Alt + Enter, I get the properties. However, I don't see Record Source... only Control Source. Is it possible my form is setup incorrectly? I've attached the zipped db.

is the record source the same as the properties Control Source? So, for txtPicture, I would replace "Picture" with SELECT TileLocation, TileNumber, CapPosition, [FilePath] & "\" & [FileName] & "." & [FileExt] AS Picture FROM Caps; ??

I have a bunch of other fields on my form that are also on tblPictures. I thought I needed one row on tblPictures per record on the form. Otherwise, if I just have a picture path on tblCaps, how does that link up to my form. As far as your explaination to change my form's recordsource to a...

There is no relationship between Caps and Picture tables and I don't know how to setup a relationship b/w the two. The reason I want to move data from one table to the other is my current form (which is setup with macros to display the pictures) is pulling all the fields from the Picture...

Thank you so much for your help. Now, I have this how I want it. What happens as the Caps table grows? If I rerun this query, it just adds all 1022 rows again. I need it to only add new rows. Is there an easy way to only add new rows?

I just figured it out. We needed Len - 3, Len - 2, and Len - 1 instead of 4,3, and 2. Now it works correctly.

Verified FileName in Caps table is text Ran with and without 'CStr()' added. Both times got the same error and null. Tried your most recent example INSERT INTO (TileLocation, TileNumber, CapPosition, Picture) SELECT Mid([FileName], Len([FileName])-4, 1) AS TileLocation, Mid([FileName]...