How to Create a Dialog Form in Microsoft Access

[@JevVan]

Thank you thank you thank you! I have spent the last three days scouring the internet trying to figure out how to make my program stop in the middle of the loop to wait for data coming in from forms. I knew there had to be a way I tried all kinds of crazy stuff like turning my subroutines into functions and waiting for the response and yada yada yada. Anyways you're a lifesaver it's a simple five, one word solution to my problems. I have subs to your account and hope you continue to make such great informative videos!

[@royalmaxey9217]

Thank you so much for posting this video! I found it highly useful and very easy to follow. Well done!

[@davegoodo3603]

Hi Phil, thanks for the video, I got a lot more 2nd time round. I didn’t know you could use the file dialog like that, thanks again, Dave.

[@johndavy3820]

I loved your video. I would like to see the import routine as part of this video. Thanks John

[@codekabinettcomen]

Thank you, John! I'm afraid I don't understand what you mean regarding the import routine.

Klasse Video. Danke

[@monkeywarhol]

Hi Phil! Nice video... thanks for including my track "Lunar Orbit"!

[@RonaldMaxseiner]

Great video. Thanks so much.

[@jonikauhane9587]

Thank you for these videos! Very helpful! However, I can't figure out how to run the Import command from the Import button. I've watched all the videos (I think)... but I haven't seen the piece that ties them together. Any help you can provide will be most appreciated! Thank you!

[@codekabinettcomen]

I'll check if I can provide the sample project.

[@alencepoudel6446]

Help Needed: It highlights " If Len(Me.txtFileName.Value) > 0 Then: and gives the error message Compile error: Method or data member not found.

[@codekabinettcomen]

Check the name of your textbox control for the file name. It should be txtFileName. If it isn't change either the name of the control or the code.

[@jimaiello750]

Excellent video. I detest globals, which most of the other 'solutions' are using.

[@rebeccadudek1367]

Thank you! One thing I realized though, is that I'm unable to populate the form fields through vba when the form is opened in acdialog mode. Ideally, the form would open in acHidden, my code would populate the needed fields, and then the form window mode would change to acDialog. Do you know of any way to do this?

[@codekabinettcomen]

I would rather pass the data to the form in OpenArgs as a delimited string and then fill the form controls in Form_Load. If it's more/complex data the form could read it from the database.

[@shafiulamin4128]

Hi Philip, can you do a vedio on how to implement sumifs in access queries please. Great videos . Cheers

[@codekabinettcomen]

Thank you. I'm not sure about a video on SumIf. You could solve this using Sum(Iif(Condition=True,[FieldToSum],0))

[@rskipworth]

Very clever using me.visable = False; efficient, clean - and readable programming.

[@dieken310]

I got a question! You have to run the code and import the file via the dialog right? That means i can't open the normal form and import from there. Is there an option that it would work with the form?

[@codekabinettcomen]

Of course, you can put the code into any form (or module) and run the import from anywhere in your application.

[@DanielJStahl]

Good video, thank you.

[@jaiveersingh9055]

can you explain more throuhly

[@codekabinettcomen]

What do you want explained?