Тёмный

Web Data Entry for Microsoft Access 

Sean MacKenzie Data Engineering
Подписаться 13 тыс.
Просмотров 1,1 тыс.
50% 1

In this episode in our MS Access playlist, we show how to do a simple data-entry form that runs in the browser and populates the Access database on our computer. Most Access developers all have that one pesky bit of data that they need to collect from users who don't have Access on their workstations, or who are spread out on the internet. We'll use about 30 lines of Python, using Streamlit and ngrok to showcase how easy it is to set up a web data entry form for Microsoft Access. Let's go!
Block spammers from harassing your Remote Desktop, filling your Windows security logs with failed RDP attempts, and burning up your bandwidth with my BZ RDP Cloaker:
buy.billzone.c...
Check out my easy time entry system for your business:
system.billzon...
Join me on Patreon!
/ mackenziedataengineering
Check out some tech (and support my channel!):
www.amazon.ca/...
Want the code from this video?
mackenziemacken...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a RU-vid Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#msaccess #python #streamlit #ngrok

Опубликовано:

 

18 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 22   
@seanmackenziedataengineering
@seanmackenziedataengineering День назад
Make sure to check out the previous episode to get started with Streamlit ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TbAECDT7FFU.html and the next episode showing two ways to get your app on the web: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-K1b5ju08XBg.html Also download the files to play with: mackenziemackenzie.com/downloads
@manishkashikar9154
@manishkashikar9154 5 дней назад
Mr. Sean MacKenzie thank you so much. What a nice way of teaching!
@seanmackenziedataengineering
@seanmackenziedataengineering 5 дней назад
You're very welcome!
@romeus2012
@romeus2012 6 дней назад
¡ Magnifico maestro !, a estudiar se ha dicho Saludos desde Lima-Perú Gracias
@seanmackenziedataengineering
@seanmackenziedataengineering 6 дней назад
¡Pronto habrá más información! Me alegro de que hayas disfrutado del vídeo.
@jamesmartinez9069
@jamesmartinez9069 8 дней назад
Muchas gracias ingeniero, es invaluable su conocimiento sobre el tema
@seanmackenziedataengineering
@seanmackenziedataengineering 8 дней назад
Me alegro que te haya ayudado
@simonmaersk
@simonmaersk 8 дней назад
Thank you for the video!
@seanmackenziedataengineering
@seanmackenziedataengineering 8 дней назад
My pleasure!
@Muslimtap
@Muslimtap 8 дней назад
Waw that an eye 👀 opening tutorial sir thanks. I wan to know if Python flask framework can also be used to to build something like this.
@seanmackenziedataengineering
@seanmackenziedataengineering 7 дней назад
You can indeed! You can see how I do a similar project with an Excel sheet here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ITypGJXT48k.html Flask will be more geared toward high scalable production, but it is a little harder.
@tuffley2175
@tuffley2175 8 дней назад
Very valuable if you know python My hand are tied and permission is denied Too old to open the can of worms too Thank you 🐍 Only thing left is to CRY 😢
@seanmackenziedataengineering
@seanmackenziedataengineering 7 дней назад
Don't cry :-) you can try it! Similar in complexity to VBA (easier in some ways)
@nataliacarrillo843
@nataliacarrillo843 7 дней назад
Thank you so much for this video, could you explain a little bit more the minute 18:48, I got a little bit lost when you sir added the run_ngrok_app, I didnt see that coming, but thank you so much!
@seanmackenziedataengineering
@seanmackenziedataengineering 6 дней назад
ngrok is just a little free app that has one cool feature: reverse proxy. That means it gives you a real web address out in "the wild" and connects that to some port on your computer; in this case 8501 which is running streamlit. I'll be doing a video on installing it. Docker is another tech that allows you to run different kinds of apps on your computer in "containers". You can google it, get the installer and take all the defaults during installation. Then you can easily get ngrok and run it using the commands I showed in the video. That will connect the outside world to your streamlit MS Acces app!
@bumpersmith
@bumpersmith 8 дней назад
For the drop down's, can you load them with data that is in the Access database like the Access comboboxes instead of filling them with statice text?
@seanmackenziedataengineering
@seanmackenziedataengineering 8 дней назад
You bet, please watch the previous episode where I demonstrate this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TbAECDT7FFU.html Watch how I load the selectboxes using a query on Access.
@simonmaersk
@simonmaersk 8 дней назад
I don't want to get ahead of myself here, but is it possible to have the form open up an existing record? I am trying to build a web app with user logins where users can edit a specific record only, based on who logs in. Does this sound realistic and doable?
@seanmackenziedataengineering
@seanmackenziedataengineering 8 дней назад
That will be pretty easy with streamlit. I'll be doing edits in an upcoming episode 🛠
@simonmaersk
@simonmaersk 8 дней назад
@@seanmackenziedataengineering Thank you, looking forward to it!
@SAMYTAHER
@SAMYTAHER 7 дней назад
√√√
@seanmackenziedataengineering
@seanmackenziedataengineering 7 дней назад
🛠
Далее
How to Use Class Modules in Microsoft Access
26:35
Просмотров 1 тыс.
How to Use Streamlit with Microsoft Access
24:34
Просмотров 1,1 тыс.
БЕЛКА РОЖАЕТ? #cat
00:26
Просмотров 510 тыс.
Building and Deploying Python Code in Snowflake
1:02:21
AWS CEO - The End Of Programmers Is Near
28:08
Просмотров 463 тыс.
Postgres just got even faster
26:42
Просмотров 22 тыс.
TCP/IP for Programmers
3:03:31
Просмотров 55 тыс.
Coding Was HARD Until I Learned These 5 Things...
8:34