How to create Auto filling forms in Ms access

The knowledge you learn from here can be applied to many scenarios in Access forms.

[@kentlindgrempyml704]

Delete the background music, irritating

[@fikaduelias3541]

Thank you so much for your help

[@quin100]

Happy to help

[@bumpersmith]

The music is very annoying.

[@quin100]

Thanks for the response I'll take that into consideration next time

[@Initial_Gain]

Yes, even I found the music annoying and the talk should be louder preferably with no reverb and background noise. Thank you nice tutorial.

[@quin100]

@@Initial_Gain thanks for the feedback.

[@Initial_Gain]

Please note the music is very annoying and the talk should be louder preferably with no reverb added and background noise. Thank you nice tutorial.

[@annahmickey7631]

Your work is admirable Quin..it does have a positive impact on us..keep up💯

[@alvinbarasa3172]

Owesome,,,,,, waiting for others more please 🙏

[@bzflowerbee]

Wonderful! But how do we input the data through the form to the table? Thank you.🙏

[@quin100]

Thanks for your question. Create an empty table with all the fields you want, then using form wizard you can create a form which fills the data directly to that table. Or you can also create an empty form then on the top right you'll find "add existing fields" click there expand the tables then add the fields you care about . Save and run the form. Any data you input in those fields will be saved in the table.
If it's confusing let me know and I'll consider creating a tutorial.

[@bzflowerbee]

@@quin100 Thank you for replying. I know how to create the form and table and the query auto filled some fields. For example, I have a table with 4 fields, a text box for date range I need to manually enter, 1 combo box for employees name, and text box for location and phone. I have a form for this table. I asked people how to do,they said need VB code. If you have time to do a video like this, that would be great! Thanks!

[@quin100]

@@bzflowerbee I think what I've heard is that you want to enter date range manually, then have a combo box to select an employee, then the others two fields will be automatically filled. If that's the case, I'll find time and make a video just to cover that topic if there is anything you want me to add just let me know. Thanks have a nice weekend.

[@bzflowerbee]

@@quin100 Yes, exactly! I found 1 video that did similar to this but very complicate and hard to understand. I found that your video is easier to understand for my level. If you could do something like this, that would be great. Thank you for your help.🙏

[@steevan29]

thank yo soo much :)

[@karmzkomy2047]

Very helpful thanks quin

[@michaelosiema8869]

Thanks for the video

[@wakeshonereah6190]

Really helpful thanks quin

[@abdulhamidalhaddadi2255]

Thank you

[@quin100]

You're very welcome

[@abdulhamidalhaddadi2255]

@@quin100 1 question coming now, how can I send this data by email with attached invoces?.

[@akokohjoel9854]

Pls show us how to connect ms access to dataverse in power app

[@quin100]

I'll get to you as soon as possible 😉

[@hilaryhazard1475]

Thanks man

[@carolynenyanchama8822]

thanks again❤

[@otienofestus3076]

I love your teachings thanks

[@wakeshonereah6190]

I found what I was lookin for