Refreshing and learning a lot thank you. When you say "put your stuff" where it says other stuff, what exactly to do you mean? I'm looking at using it to show the two imports and 3 queries in a macro, how do I represent those items in the code?
"Your stuff" is whatever you want to do. Run a query. Update the progress bar. Run another query. Update bar. Run a macro. Update bar. Make coffee. Update bar. Get it?
How about overlaying one text box over another. The back textbox being wider and a different color than the one on top. Then grow the one on top as the progress increases and you could also put the percentage completed in the top text box which would be right aligned. I haven't tried this but it seems reasonable that it could work. The top textbox could even change color at different intervals or post what's happening in another text box below with changing text at each step.
Absolutely! Have fun with it. I thought about the color changing thing too, but I didn't want to get too carried away. These are supposed to be SHORT lessons. LOL
Thank you so much Sir for sharing your knowledge, Me personally I have Learnt a lot from you, but I Have one Request, I work in a medical setting where I am required to create a system which tracks patients upcoming appointments and also notify you on the missed appointments like the day after. Thank you very much in advance.
I'm working on some barcode seminars right now. Unfortunately it will be for 1D barcodes. 2D barcodes (and QR codes) are difficult to create in Access without major programming, 3rd party plugins, or API calls to the web. I might cover this in a Developer course, but it's beyond the scope of a free TechHelp video.
Very nice video as always! I wonder... If you were paging through a long recordset, would you update the progress bar at the end of every individual iteration? Like saying PB1 (100*rs.AbsolutePosition)/(rs.RecordCount)
Depends on the size of the recordset. 100 records, sure. 100,000 records, maybe display every 1000. Also depends on how long each record takes to process. I like to try to update the display at least once every second. Lets the user know something is going on and the DB isn't frozen.
Well, not by itself. You could code it in your loop so that at some certain point a form could open. Something like: If PercentComplete > 80 then DoCmd.OpenForm "MyFormF"
Wish you would have said the best progress bar you've shown here is members only at the beginning of the video and not the end. Waste a lot of peoples time who have not seen your channel before. Will not support because of that. Best of luck.
Well... you know where the door is. Don't let it hit you on the way out. Aww, man... I just noticed that you've got Neil deGrasse Tyson as your profile picture. That means you can't be THAT much of an asshole. LOL
Thank you. I know that this was old content but it was helpful to me.
It's not THAT old.
Refreshing and learning a lot thank you. When you say "put your stuff" where it says other stuff, what exactly to do you mean? I'm looking at using it to show the two imports and 3 queries in a macro, how do I represent those items in the code?
"Your stuff" is whatever you want to do. Run a query. Update the progress bar. Run another query. Update bar. Run a macro. Update bar. Make coffee. Update bar. Get it?
@@599CD I'll have to research how to put in there the import macros and queries then. Not a programmer if you could tell. lol
Hey Richard, I was going to check out the activeX progress bar control, but it's not in the list. Did Microsoft nix it in Access 2016?
Still in my version of Access. MS 365 subscription.
How about overlaying one text box over another. The back textbox being wider and a different color than the one on top. Then grow the one on top as the progress increases and you could also put the percentage completed in the top text box which would be right aligned.
I haven't tried this but it seems reasonable that it could work. The top textbox could even change color at different intervals or post what's happening in another text box below with changing text at each step.
Absolutely! Have fun with it. I thought about the color changing thing too, but I didn't want to get too carried away. These are supposed to be SHORT lessons. LOL
Thank you so much Sir for sharing your knowledge, Me personally I have Learnt a lot from you, but I Have one Request, I work in a medical setting where I am required to create a system which tracks patients upcoming appointments and also notify you on the missed appointments like the day after. Thank you very much in advance.
Sounds like a fun project. Feel free to submit it: 599cd.com/TechHelp - give me as many details as you can.
Very nice dear sir
Thanks
So I’m green to access but I missed the part on how to integrate into the macro steps
Everything you need is shown in the video
amazing.well done
Thanks a lot!
Thank you Sir, for your video. Would like see a video on QR Code soon.
Thank a lot
Mr. Hossain from Bangladesh
I'm working on some barcode seminars right now. Unfortunately it will be for 1D barcodes. 2D barcodes (and QR codes) are difficult to create in Access without major programming, 3rd party plugins, or API calls to the web. I might cover this in a Developer course, but it's beyond the scope of a free TechHelp video.
Awesome.....💕💕
Thank you! Cheers!
Sir i have created the successful . but one problem is there . when ever i restart my access so it did not run
I don't understand.
Awsme sir. Thank you very much. 😁
Most welcome 😊
Very nice video as always! I wonder... If you were paging through a long recordset, would you update the progress bar at the end of every individual iteration? Like saying
PB1 (100*rs.AbsolutePosition)/(rs.RecordCount)
Depends on the size of the recordset. 100 records, sure. 100,000 records, maybe display every 1000. Also depends on how long each record takes to process. I like to try to update the display at least once every second. Lets the user know something is going on and the DB isn't frozen.
Your a very goog teacher!!
Thanks!
Hi sir . sir i have create loading form . when i restart access so why it didn't work .. Plz kindly solve my that problem
Without seeing your database, it's impossible for me to tell what's wrong. If you followed my instructions, step-by-step, it will work.
CAN THE PROGRESS BAR OPEN A FORM
Well, not by itself. You could code it in your loop so that at some certain point a form could open. Something like:
If PercentComplete > 80 then DoCmd.OpenForm "MyFormF"
@@599CD thanks 😊 it worked
I think MVP like u should shift to RPA tools like Kryon studio to do all such automation.
But still I liked this video.
Thanks for the feedback, but I'll stick with Access. Been using it for 26 years and I have no plans to switch to anything else.
WOW woow that good
Thanks!
Wish you would have said the best progress bar you've shown here is members only at the beginning of the video and not the end. Waste a lot of peoples time who have not seen your channel before. Will not support because of that. Best of luck.
Well... you know where the door is. Don't let it hit you on the way out. Aww, man... I just noticed that you've got Neil deGrasse Tyson as your profile picture. That means you can't be THAT much of an asshole. LOL