Search results

I wish I'd known that when I started. It's so easy to do and would make the page look less cluttered. I've already got the controls 'grouped' on the main Form and copy/paste and a little bit of moving/resizing won't take long. I could standardise all of the tab control pages allowing room for...

After several tries I figured out what you were saying and how to accomplish it. I now have the subform as a single, high & wide enough to accommodate an image with the control above and the subforms navigation buttons showing so moving through the records I can see the first associated image...

It doesn't have to be a pop up form, any from as long as it only shows the images belonging to the current record displayed on the finds form. There can be zero to 4 images per record (but the odd record could have more). The biggest problem with that method is viewing space. If I make the...

I've been trying and although I can get an image to display in a new form as a pop up form it always goes to image 1 from the first record. regardless of what record I'm viewing or which one of the 2 I wish to see. ie, if I'm on record 10 and want to view image 2 of that record, how would I pass...

I need the photo to display in the frmFinds form and as there is normally 2 and could be 3 or 4 for each record and I only want photos relevant to the displayed record showing one at a time. preferably when an icon is clicked. I had experimented with the image control but I couldn't see the...

Going to try again. It would appear that my DB was over the 2 meg limit. I've now got it down in size and uploaded it.

Misread the error, it's missing a SECURITY TOKEN and I need to contact an admin.

Sorry it took so long. Not sure why but I couldn't delete a lot of the records so have just cleared the controls. I would like to view the images from the 'Finds Details' form. There is a space on the form that can be used or display in a pop up form (second choice) At the moment the files are...

When I navigate to the next record the files shown in that combobox/subform automatically update to to the images associated with the new record. I appreciate you trying to help me but I'm not that familiar with access to work out how to do what you are saying to do it myself. Unfortunately I...

Here is an image of the subform as is.

I do have a table with all the images as an individual record and shown on the main form in subform combobox/list. clicking the viewer icon opens the file via an external viewer. Displaying dynamically in a subform or on the main form would be better than viewing externally. What code does that?

That looks good but how would I use the code to be able to add up to 4 images to an existing form for each record in the DB so only the images associated with the record were in a list on the form and moving to the next record would change to available images? I'm getting more used to working...

Previously I was adding the images as an attachment but even with reduced quality images the size of the DB was getting big & bloated. I was given the code to get & store the link to the file on my local drive. It all works great except for when I click the 'view icon', it brings up the windows...

Mike has edited the DB to make the combo boxes to cascade correctly. Thanks to everyone for their help and suggestions and especially to Mike.

OK, I'll upload. Thanks for the info. Just trying to but vBulletin Message Security Token Missing?

Done as per PM

I need to store the value Either as the ID number or as Text. I'm not bothered which. I could make both the Category & SubCatergory data unique.

Thanks for your reply, Your postcode builder works perfectly but having looked at the AfterUpdate event code I've no idea how to convert it to my need as I don't understand some of it. I've also looked at the FMS example (have looked at it before but not actually downloaded it till today) and...

It's when I use select [SubCat] from SubCategory where [FindCat]=forms!Finds!Fcatcbo in the row source the 2nd combo box shows empty

I have the requery code in the afterupdates event and it doesn't work. Tried this instead SELECT [SCatT].[ID], [SubCategory].[SCat] FROM SubCategory ORDER BY [SCat]; I think that made combobox2 come up empty