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.
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.
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
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
