Use a File Dialog in Microsoft Access

[@praetor7063]

I can't understand how you have only 4k subscribers. For me it's the BEST VBA channel.

[@davegoodo3603]

Thank you Phillipp, so nice to get good content from you. I don't know why I look anywhere else. Much appreciated.

[@sheepchild]

Got right to the end but doesn’t run the import bit just does the pop up message how do you do the final link to the import button? To make the import actually import and do the updates. Am I just missing something?

[@johandegraaf1458]

I'd really like a Video to tie this series together. Essentially a tutorial on using the dialogue box to execute an Update/Append from a CSV file

[@codekabinettcomen]

This is a good idea. However, I'm not sure if I will do that anytime soon.

[@stephenheusz3236]

Thanks Phillipp. Very clear and concise and explained very well. How about a video tutorial on how to use a file dialog box to save a file?

[@codekabinettcomen]

Thank you for the feedback! I'm not sure about doing a video on the save dialog. It will be either very similar to this one or I would need to do the WinApi dialog, which is challenging for many viewers.

[@rskipworth]

Thanks Phillipp - These are really great for an old guy trying to pick this up again!!! Danke!!

[@SilkeJuppenlatz]

Awesome, thank you. I'm trying to build a hobby database with multiple views of a model figurine, but didn't want to type in every single image path. Hoping I can get this to drop the value into a table, so I can use that table to call the images and display them on a form. :)

[@altunhasanoglu2863]

Thank you for clean expalantion. You give explanation of ties between codes and it helps us understand clearly

[@bumpersmith]

You have a great approach to the way you explain a topic and your topics as far as I know are unique and show the workings of VBA that I did not already consider. Thank you and I look forward to future videos from you.

[@johnclark851]

Another excellent video Philip. I shared this on an Access forum today for someone who was asking how to do something exactly like this. Have you considered doing one on text parsing? Maybe with the use of Regular Expressions?

[@adammitchell2265]

I think that person may have been me, John! Thanks for a very well explained series Philip; I've just subscribed now.

[@codekabinettcomen]

Thank you for sharing! I will think about String parsing.

[@Jason-gl7ny]

Just like Paul Knights comment; You forgot to mention 2 things: 1) how to connect the Import file to a button, and 2) how to change the import procedure to the actual import, not just showing the text box. Otherwise, excellent!

[@felipescherer6678]

Clear and simple explanations. Very usefull also. Thanks a lot for sharing!

[@PJTarver]

Genial! Klar und leicht zu verstehen. Sehr empfehlenswert.

[@mlaffey4026]

Thanks for video, i got the file dialog working.

[@Nairot]

Thank you and keep up the great work. You helped me so much.

[@seekknowledge2714]

Thanks Phil, that was awesome :) would love to see more of your videos

[@codekabinettcomen]

Thank you! I will record more as soon as I find the time.

[@leonshears6925]

Very good!!! And almost what I was looking for - but it is clearly an area in which you are very knowledgeable. I would like to know how to add a button (I can do that!) to a form which takes the user to a folder into which the user can paste an image. I can use "hyperlink" to get to the folder - but the folder is in read-only and will not allow the user to past an image. I know it must be "doable" and I keep trying but some of your magic would really help! Leon

[@dmitriydemidov9613]

Thank you very much Philipp

[@MrMeLaX]

Where is a previous video? Didn't found it...

[@apmastenbroek]

Thank you Philip for al your videos, the are quite clear and useful.

[@johndavy3820]

Thanks for a great video. You are amazing! John

[@thiruthiru1]

Great job. I like your video, very useful, precise and to the point.

[@ramprakashmaurya3236]

Very very nice

[@martinbrien9104]

Very good.. and clear, thanks..

[@sheepchild]

Or even better is there a finished, file with all this in and working?

[@CarlosPereira1973]

Thank you for the explanation

[@adammitchell2265]

Philip; If allowmultiselect = true what would then be the .selecteditems index to allow multiple filenames to be chosen?

[@codekabinettcomen]

SelectedItems is a collection, each item in the collection represents one of the selected files. You need to loop through the collection accessing all items from 1 to SelectedItems.Count to get all the selected file names.

[@seekknowledge2714]

Adam, in this dialog box you only have one text box to hold the chosen file name ( one file only)... So, you wont need multiple files to be selected file .. you only need one file.. in case of allowmultiselect = false you only have one file.. which index is always 1 so this is the one you need for the dialog box form example.... However, in case of allowmultiselect = true the user may select multiple files which all will inside the SelectedItems collection.. you will then need to choose only one of them.. That will be unnecessary and confusing .. so do not allow multisellect in this case where you only need one file.. *allowmultiselect = true* is used in other scenarios where you need to process many files, and in that case you use a loop to iterate through the SelectedItems collection items starting from index *1* until index *SelectedItems.count*

[@adihalili4953]

thanks Philipp I hate VBA and you saved the day

[@nickpapastefanou7741]

Very detailed video, but i cant find "MS office database engine..." I have 64bit (that must be the reason) Access 2016 , so i get an Error when trying to run it. Any suggestions?

[@codekabinettcomen]

This is one of Microsoft Access´ core libraries and it should be installed. Search for ACEDAO.DLL (It should bein C:\Program Files\Common Files\Microsoft Shared\OFFICE16\). If you can find it there must be something wrong with out installation. Try to repair the installation.

[@nickpapastefanou7741]

@@codekabinettcomen Thank you very much for your response! Vielen dank noch Einmal für das video!

[@zstudy1]

how can i keep alot of pdf files linked in database

[@metrosierra5718]

Thanx my dear, simple, clear and useful keep goin'

[@lokeshswarnkar3112]

Dear I also create the same one but not get me.txtfilename.value pls share the file

[@alencepoudel6446]

Check the name of the dialogue box, it should be sth different in yours. Replace that with txtFileName

[@akokohjoel9854]

Does it work in ms access 2010?

[@codekabinettcomen]

Yes. I think these new dialog was added with Access 2007.

[@chajri]

How to open crystal report 11 with form access. Thanks

[@codekabinettcomen]

I'm not sure if I understand this question. My knowledge of Crystal Reports is very limited. I think there is a Crystal Reports ActiveX Control, You could probably use this control to open CRs and display them on an Access Form.

[@jean-lucmelchior5350]

Merci Philipp, même en anglais j'y suis arrivé

[@SunilKumar-uv6zu]

hi are you uploading more videos? ?

[@codekabinettcomen]

Sunil Kumar, yes I will be uploading more videos. There is no fixed schedule though, yet.

[@vilastonape192]

Sir please create video unbound master detail form

[@codekabinettcomen]

Not sure about this. A detail form displaying multiple records unfortunately has to be data bound.