How to Create File Dialog Box in Ms Access

[@altdel126]

Thank you so much❤
Could you help me to the command for searching the datas in list box

[@EdcelleJohnGulfan]

Listbox tutorial. th-cam.com/video/APQVs3FpebY/w-d-xo.html

[@EdcelleJohnGulfan]

By the way, thank you for watching my video.

[@yasminerasheed3601]

Life Saver Thank you sooo much you helped me alot

[@EdcelleJohnGulfan]

You're welcome and thanks for watching my videos

[@gentleman859]

Thank you very much for this wonderful effort, but can I add a condition that if the file extension is exclusively pdf, it will give me a pre-defined default image, and if the file extension is image, it will show this image?

[@EdcelleJohnGulfan]

Yes. Your criteria will be the file extension.

[@gentleman859]

I got a script in vba
If Right (Me.file_path, 4) = ".pdf" Then
Me.PIC_1.Picture = Me.pre_PDF
Else
Me.PIC_1.Picture = Me.file_path
End If
and this script is working correctly
thank you very much

[@josmaitconsult8913]

Thanks alot for your video. Can your please with how to transfer a report to a form on the same access database.

[@akokohjoel9854]

Thanks so much brother, but how can I copy/move file, eg excel or image photo from one folder to another? Pls help

[@lmarytheexplorer9796]

Thank you. Paano po kaya maprevent yung double import para di duplicated yung data. Thanks

[@EdcelleJohnGulfan]

Sa table property, set to no duplicate.
2nd option, Before Insert function + dcount function.

[@homekt05]

👍👍👍👍👍

[@EdcelleJohnGulfan]

Thanks

[@menkiz123]

Ok used this methodto seledct pdf files...nice... NOW can you help me to OPEN the pdf file

[@EdcelleJohnGulfan]

Try this. th-cam.com/video/OBhB4500Ka0/w-d-xo.html

[@fontie38]

Sir what is the VtrSelectItem?

[@EdcelleJohnGulfan]

That's a Temporary Variable for Selected item or item to select. The value of that variable will appear in the file dialog box after selecting a file.

[@KhalidAfridi1]

We can directly use Application.Filedialog without declaring as dim fd = Filedialog
With Application.Filedialog (...)
.
.
.
End with

[@EdcelleJohnGulfan]

Yes we have 2 options. The EARLY and LATE BINDING.

[@yasirkhan-mw1zr]

Sir in my database I can't found Microsoft Office 16.0 Object library, help me.

[@EdcelleJohnGulfan]

What version do you have? any number as long as Microsoft Office ## Object Library.

[@alnsd1466]

sir ano itsura ng excel file na inimport?

[@EdcelleJohnGulfan]

Sorry hindi ko napakita. Kung ano itsura sa table na UserAccount, yun din sa excel.