Web Data Entry for Microsoft Access

Поделиться
HTML-код
  • Опубликовано: 9 янв 2025

Комментарии • 24

  • @seanmackenziedataengineering
    @seanmackenziedataengineering  3 месяца назад

    Make sure to check out the previous episode to get started with Streamlit ruclips.net/video/TbAECDT7FFU/видео.html and the next episode showing two ways to get your app on the web: ruclips.net/video/K1b5ju08XBg/видео.html Also download the files to play with: mackenziemackenzie.com/downloads

  • @manishkashikar9154
    @manishkashikar9154 3 месяца назад +1

    Mr. Sean MacKenzie thank you so much. What a nice way of teaching!

  • @romeus2012
    @romeus2012 3 месяца назад +1

    ¡ Magnifico maestro !, a estudiar se ha dicho
    Saludos desde Lima-Perú
    Gracias

  • @wowjunjun
    @wowjunjun 4 месяца назад +1

    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  3 месяца назад

      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!

  • @jamesmartinez9069
    @jamesmartinez9069 4 месяца назад +1

    Muchas gracias ingeniero, es invaluable su conocimiento sobre el tema

  • @Muslimtap
    @Muslimtap 4 месяца назад +1

    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  4 месяца назад +1

      You can indeed! You can see how I do a similar project with an Excel sheet here: ruclips.net/video/ITypGJXT48k/видео.html Flask will be more geared toward high scalable production, but it is a little harder.

  • @simonmaersk
    @simonmaersk 4 месяца назад +1

    Thank you for the video!

  • @bumpersmith
    @bumpersmith 4 месяца назад +1

    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  4 месяца назад

      You bet, please watch the previous episode where I demonstrate this: ruclips.net/video/TbAECDT7FFU/видео.html Watch how I load the selectboxes using a query on Access.

  • @simonmaersk
    @simonmaersk 4 месяца назад +1

    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  4 месяца назад

      That will be pretty easy with streamlit. I'll be doing edits in an upcoming episode 🛠

    • @simonmaersk
      @simonmaersk 4 месяца назад

      @@seanmackenziedataengineering Thank you, looking forward to it!

  • @ayeikh1867
    @ayeikh1867 3 месяца назад +1

    hello
    my operating system windows 64 bit
    my ms office 32 bit--already engine 32 bit
    my python 64 bit
    What do I need to do to be able to connect to the Access database via sreamlit?.
    I have a lot of trouble downloading Docker on my device because the download requirements do not match my device. I tried downloading an old version but it did not work.

    • @seanmackenziedataengineering
      @seanmackenziedataengineering  3 месяца назад

      You don't have to use Docker, you can use method #1 from this week's video: ruclips.net/video/K1b5ju08XBg/видео.html
      Also make sure to watch the preceding video as it talks about bit versions and some prerequisites: ruclips.net/video/TbAECDT7FFU/видео.html

  • @tuffley2175
    @tuffley2175 4 месяца назад +1

    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 😢

  • @SAMYTAHER
    @SAMYTAHER 4 месяца назад

    √√√