Search results

@Cronk This fixed it! Working perfectly now! I am so utterly grateful for your help! @jdraw and thank you so much for the demo! For anyone in the same situation: The explanations for each section helped tremendously and I would recommend anyone that has run into this issue (of not knowing...

Just to clarify.. am I calling the function correctly? Private Sub Command0_Click() Call SaveAttachmentsTest("") - saves ais folder and adds ais to photo name but not putting photos in folders End Sub Because when I put anything in between the quotes like Call SaveAttachmentsTest("Ventress") it...

Thank you guy so much for the help! I'm swamped as usual, but I should be able to test your suggestions out tonight. Again, really REALLY appreciate it and looking forward to trying it out! @jdraw @theDBguy @Cronk

@theDBguy See the images below for the output to the immediate window. It was the same result in front and after. @jdraw AIS = Think of it as just an employee ID number. And the rest of the database is comparable to an employees database with info on each employee as well as photos. Output:

Sure! Thank you for your response. So the files/attachments are all pictures (jpgs). The AIS field is the primary key field for the Persons table. I had an attachment field in the persons table that stored pictures for that record (associated with that AIS). I ultimately learned of the 2GB...

This is in reference to code posted in this post https://www.access-programmers.co.uk/forums/threads/export-attachments-to-folders.299345/ I didn't want to hijack that thread so I started a new one - please let me know if I need to move my questions over to that thread. So, the following code...

Thank you for your reply. I was afraid of this. Re-doing the relationships will be fun lol. I thought I was saving a headache by making it a numerical field, but I guess not. Thanks again for your response =D

In my table I have a numerical field for case numbers. Our case numbers are in the format of YYMM000000 (YY = 2 digit year, MM = 2 digit month, remaining 0's are consecutive case numbers). In order to properly list the case numbers in descending order, I have caseyr: Left([CaseNo],2) (which...

Thank you jdraw for your reply. Yes, I've searched and googled and been all over the place trying anything and everything. Most all of the posts I have found where people actually had success were much older versions of access. So I'm beginning to think that my best bet is just going to be to...

I have a program that stores data in FoxPro dbf files. There are multiple files that I would *like* to link to - then create tables based on the linked tables so that I can add additional necessary fields. The dbf files are updated daily, so I also need to be able to have my editable tables...

While searching for Filter info I actually came across a VERY helpful post that ended up working perfectly. So for anyone else in the same boat, try the post here (wouldn't let me post the link since I don't have the posting numbers) Search this forum for : "transferring data from one form to...

Yes. It stays open in the background.

Ok, essentially what I would like to happen here is the following: On the form: User enters first name, then last name. Upon updating the last name field, I would like another form to pop-up and display all the people with that same first name and last name that the user just entered. On the...

Thanks Byte for the reply! *Edited Byte... you are wonderful. It was my mistake thinking your query wasnt working... it works perfectly! When I checked the query I was looking at the wrong placing field. When I realized I was looking at the exhibitor's placing instead of the min value...

Grrr.... this has been a pain for a week now. Hopefully someone will be able to help. I want to have a query update table values based on the min values of a different query. Here's what I have (well, just the important stuff): Table: Exhibitors Field: mrkt_pts Table: Livestock Field...