Joseph, you know I need the exact error message to tell you what the problem is. "I get an error" tells me nothing.

I just checked the link for the ZIP file and it downloaded fine for me.

The code provided is a 32 bit function, so if you're using 64 bit Office then you need to add PtrSafe to it.

Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _

Becomes

Private Declare PtrSafe Function GetOpenFileName Lib "comdlg32.dll" Alias _

HI Richard:

    Sorry I forgot to send the error message please see attached screen short

OK and which URL (page) gives you this error?

I'm on the Access imaging seminar page and when i go to click on the link to download the sample database files for thaty seminar I get that errror

here is the link for the page I was on so you can see what page I was talking trying to download the sample database files for the iimaging semoinar.

https://599cd.com/site/courselist/seminars/access-imaging/

Hi Richard:

  iI got it to work.  I got it to download.

Told ya the link was good. :)

Remember, the Internet isn't perfect. In the future, if you try to visit a page or download a file and you get an error message, wait 5 minutes and try again. It could have been a glitch. Web servers go down all the time. I was frustrated by Microsoft's site the other day because I was trying to download something and it was erroring out. Waited a few minutes and it worked.

Ok thsnk you for letting me know.  I use google chrome gor my browser and for office.  I hzve 64 bit.

I got the download to come up like you said wait 5 minutes an dgot the dlownload popup and I clicked the link to open and got a error message saying only 32 bit,  please see screenshot

I have 64 bit on my computer and laptop.

Yep. The SAMPLE databases for people who have NOT purchased the seminar are 32-bit. That seminar is OLD. The FULL database for people who HAVE purchased the seminar (that's you) should work just fine under 64-bit. You may need that PtrSafe command I gave you above. See the Student Databases page.

The fact that the line is in red means you have a syntax error. I can see your quotes are wrong. I'll make it a learning experience for you. Figure out which quote shouldn't be there. :)

Ok Thank you for letting me know.

I know i'm still learning and on expert level.  I'm watching the open programs lesson and watching the code you are doing to open the programs.  I been playing around with the quotes and trying to figure it out what ones that shouldn't be in the code on the adobe.  All the other files I have for word excel and etc open with no problem I have those right.  I just opened up a file in excel and worked.  I want to be able to this for my SCAT database.  I just wan to have it right so when i put in the code the programs will open. It just the adobe line i need help with.  Can you p[lease just help me with this one.  I promise i will learn with more with the rest of the lessons.  I'm doing what you saying to figure it out what qoutes that shouldn't be there.  Just bothering me that I'm trying to figure out the quotes that shouldn't be there and not working.  I know i learned not to have actual attachments in the database it seldf that why i'm doing this video to have the table and the form.

Take one quote off the front of the line. :(

I took one quote off front of the line and still getting same message.  I understand you are very busy.  is there someone i can that can look at my database for me?  really bothering me that not working.

I use Adobe Pro DC.

I meant to write my comment I copied the file location for adobe acrobat.  and put the rest of the line in the code qwith the quotes.  Here is the file location for the aboe acrobat.

"C:\Program Files (x86)\Adobe\Acrobat DC\Acrobat\Acrobat.exe"

I don't see how that line of code is giving you an error about 32 bit Access.

I haave 64 bit

I went to account in access and it is 64 bit.  I checked the info

Did you change the code like I said first with the PtrSafe option?

Where do I put that line in the code?  

Is the code you are talking about

Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _

Becomes

Private Declare PtrSafe Function GetOpenFileName Lib "comdlg32.dll" Alias

Do I do that code in the actual vba code or module?

Find it. You want to learn, right? Figure it out. :)

Ye I do want to learn.  I try to figure it out.

Good boy. Here's a hint: you can do a search in the VBA window with CTRL-F (find) and if you select "Current Project" it will look for code in your entire database.

ok Thank you for letting me know that.  I have awsome news.   I did have to do that code.  I figured it out. I fixed the quotes.  Now when I look a contact in my database and double click on a pdf file of theirs it bow opens the file.  I'm learning.

Now i can do the code in my SCAT database and take out the attachment field and replace it with the table and form and do the code.  You are definitely an awsome instructor!

Sweet! So glad to hear that. And see... isn't it a lot more rewarding since you figured most of it out on your own? I just gave you a little nudge. You'll learn so much better that way. It's much better for YOU than me just telling you the answer.

I truly understand.  You are right!.  I believe you.  Yes, it is a lot more more rewarding since I figured out most of it on my own.

hi Richard:

   I want to send you screen shots of my SCAT database.  I have 4 tabs in the database have tab control on it.  I saved screen shots of the tabs so I can show you what my database looks like and want to also show you on the document tab what I did.  I know i can upload screen shots on here.  But, i have 4 screen shots want to show you.  Do I have to send them individually or what can I do so I can swend them to you?

You can post them here if you like. Yes, sorry, you have to upload them one at a time. I wrote this image upload routine myself so it's not as sophisticated as a site like Crapbook. :)

Ok than you fo letting me know.  I'm going to send them now.  Let me know what you think about the database.

Looks real good.

Thank u.

Hi Richard:

   I want to thank you so very much for the amazing videos and lessons.  I'm so glad that yiou did  lesson and video on not storing attachments in a database in access and creating a tyable with the files and creating a form.  I did it  with my contact database and my SCAT database.  I have question for you.  Is there way I can upload the file into the form so i don't have to keep on copying and pasting the file location and what ever file I'm putting into a record?  I'm not sure if you covered that in the open programs lesson.  I don't remeber if I saw that.

Hi Richard:

I cannot thank you enough for the amazing lessons and techhelp videos.  I did the lesson with creating a table and form to have files in my database and removed the attachment field and that i can double click on the file to open it in the program I have the file in.  I understand if you been very busy.  I want to know if you covered in the open programs in Access in any of the lessons to click on a button to browse and pick file to put in the dstabase like what you have with the images.  I want to be able to do this with files and documents so I don't have keep keep on adding the file into the subform in my contact form.  Can you please let me know.  I'm definitetly learning with your amazing lessons and techhelp videos.  So proud of myself that I was able to figure out the problem with the pdf and had to put the quotes in the write plsces for it to work.

Hi Richard:

   I meant to tell you I did the table and form to hav files and documents in my database.  I did it with my SCAT database and removed the attachment filed.   I like this way much better instead of the attachments.  Especially makes thwe database slow and I don't want any problems.

Did you watch all lessons of the Seninar?
Isn't there a lesson that runs through the OpenCD function that uses the picker?
It's been a while since I've seen it.

FileDialog Forum post

I have to go back and see.  Maybe did watched it and just don't remember if i saw it.  I will check.

Hi Alex:

   I'm so proud of myself.  I have a pprofile picture in my contact database and took the code from that button and when i did right click on the button did the code instead of saying Profgilepicture = PickFile()

I did

Attachment = PickFile()

Hi Richard:

  I'm so proud of myself.  I have a pprofile picture in my contact database and took the code from that button and when i did right click on the button did the code instead of saying Profgilepicture = PickFile()

I did

Attachment = PickFile()

So When I want to pick a file and upload it into my contact datasbase or my SCAT database.  I don't have copy the path into the form everytime just have to click the button to put it  into the form and just double click on the file when i want to open it.

Atta boy