Quick Queries #71
By Richard Rost
26 days ago
Why Access Suddenly Asks for Unexpected Parameter
In this video, we'll talk about a wide range of Microsoft Access and general tech questions submitted by viewers, including how to troubleshoot the unexpected "Enter Parameter Value" prompt in Access, managing app settings and user customization, tips for handling comments in code, and advice on choosing a new laptop. We'll also cover topics like recurring tasks in Access, YouTube translations, circular references in Microsoft Excel, and whether it's still worthwhile to learn Access. Other highlights include using AI for database tasks, questions about Office menus, and upcoming plans for SQL Server training and Access events.
Prerequisites
Links
Recommended Courses
Up Next
Keywords
TechHelp Access, Enter Parameter Value, query spelling error, table name not found, field name not found, app settings table, user settings, recurring tasks, task management template, Excel circular reference, OpenAI for data extraction, WhatsApp report integration, Access Day 2026, using AI with databases, Access to SQL Server upgrade
Intro
In this video, we'll talk about a wide range of Microsoft Access and general tech questions submitted by viewers, including how to troubleshoot the unexpected "Enter Parameter Value" prompt in Access, managing app settings and user customization, tips for handling comments in code, and advice on choosing a new laptop. We'll also cover topics like recurring tasks in Access, YouTube translations, circular references in Microsoft Excel, and whether it's still worthwhile to learn Access. Other highlights include using AI for database tasks, questions about Office menus, and upcoming plans for SQL Server training and Access events.
Transcript
Normally, I try to do these Quick Queries videos on Friday, but it's the holidays, folks. I had a busy Friday and Saturday, so it's Sunday, but that doesn't mean that the Quick Queries aren't any quicker or slower.
Today, we're going to start off by talking about why Access suddenly asks for a parameter you never created. Yes, that "Enter Parameter Value" strikes again. Are you ready? We've got that and lots more. Here we go.
Alrighty, first we're going to start off with a question from Susan, who says, "When I reopen the customer list after I do connect with query, the list gives nothing. And then what I did wrong, I don't know. And then I always have, when I open the query, a box message: Enter Parameter. I think this is the problem. How can I get rid of it?"
At first, I was going to say that you didn't give me anywhere near enough information to help you, and that happens a lot. People post like, "It's not working," but they're not telling me what it's doing or what it's not doing. Just, "It's not working." But you saved yourself toward the end there. That "Enter Parameter" is key. That's the clue that told me probably what's wrong, and I've got a TechHelp video that explains exactly what causes that and how to fix it. It's this video. Watch this. I'll put a link down below. Chances are you got something spelled wrong, and that's 99 percent of the time what it is - either a table name or a field name or something. Access is basically saying, "I've got no idea what you're asking me for. I can't find this field or this table. So I need you to type it in."
This also underscores why YouTube comments really aren't the best place to get help. I can't see your database or your query or how your form is built. There's usually not enough information here for me to diagnose it. I'm not a mind reader, so I can't see your file from here. I can't read inside your head. This is one of the reasons why my website forums are a much better place for getting help like this.
And yeah, I just recently made this new header for it. You like that? Anyways, there are lots of different forums on my website. If you need help with Access or Excel or whatever. If you're not a member, you can come down here and post in the visitor forum. That's open to anyone; anybody can post in there.
Burial is talking about my App Settings extended cut. He says, how will you handle the same settings for each user? Well, that's covered in the extended cut. We add a user field, we get the user name from the system environment, and then we can check it against each user. Go watch the video.
And also, why am I just a gold member on my own website? I don't know. I've got a special admin override, so no matter what settings, because sometimes I'll set myself as different things just to test features, but I got an admin override so it doesn't matter if I'm gold, silver, or whatever.
Next up, Didilev? Am I pronouncing that right? Didilev says, I learned the value of comments back in college with IBM assembler studies and coding. Wow, yeah, that's going back. I mentioned in that video for those of you who missed it that I've always been a solo developer my entire life, and so I always, when I was younger, thought that comments were for other people to be able to read your code and understand it. But no, other people is sometimes you. You are sometimes the other programmer, and it's for you five years from now trying to not have to figure out everything you wrote five years ago.
I've got code in my database that I'm using that I started when I created 599 CD back in like 2000, and it's like, what was I thinking? I should have commented it, especially when you're talking about a language like assembler that doesn't really read like English, like you can pretty much sit down and read VBA or any BASIC, for example, even languages like C. You can sit down and pretty easily read them as if you're reading an English sentence, but not assembler. Nope. You're basically decoding ancient runes at that time. But the comments really aren't there to explain what the code does; they're there to explain why you did it that way. Yeah, future self will thank you for writing them.
Especially in VBA, I like it because they're green, whereas the rest of the code is black or blue, and it's just easy to scan down a big page of code and just see the green stuff. So that's what I kind of do.
Next up, I love to acknowledge when people write nice things in my comments. I get so many people who want to help, and there's nothing wrong with that. But once in a while, it's nice when someone takes the time to write. So I just want to say thank you, Paulo. I really appreciate the kind words. I'm glad my videos have been helpful. Comments like this genuinely mean a lot to me, and they remind me why I love doing what I do. So sending a warm Florida hello right back to Portugal, and thanks again for taking the time to write.
Jade Dragon says, "Don't set the colors hex color to FF plus one. Oh, you run into that level 256 Pac-Man problem." For those of you who don't know, the original Pac-Man arcade game, the level counter was stored in a single byte. We're going back to when computer memory was insanely expensive, so who's ever going to get to level 256 of Pac-Man? I never did. I think the highest I got was probably still in the double digits.
I'm glad you appreciated the Deep Space Nine scene. For those of you who missed it, there it is - my little holiday Deep Space Nine thing. Your comments about letting users customize and tweak the UI, the colors and all that - it can be a powerful thing, but it can cause problems. Yes, I like your suggestion to have a button to revert to a preset default. That's not a bad idea.
Fun in the Rain 13 asks, "What's happened with the fitness series? It seems to have died." It hasn't died. It's still alive. I've just been extremely busy with the holidays and all that. I have a whole bunch of notes for stuff I want to do.
Lots of people came to support the fitness series after I said that one user canceled his membership because he wasn't happy with it, that it was all the fitness database, even though it's not just about fitness. I've gone through this a million times. But yes, it will be continuing. I might do one more this week and one more next week, but definitely after the first we'll be digging back into it. I have a lot of great ideas.
We still have to do the whole weights section, the whole workout part, which is the part that I want to build for myself too because I've got the diet tracking down. I've been using that beautifully for months now, but I also want to do it so I can track my workouts in the gym. I want to be able to say, "Okay, I did this weight, this many reps," and that kind of stuff. So it's coming. Don't worry. I got lots of ideas.
Next up, Michelle says, "Hello, why are you publishing videos without YouTube translations, specifically Italian translations? There are only subtitles and YouTube translations are very useful for following your tutorials."
Yes, I think they're awesome. It's not something that I turned off. I have YouTube's auto translation and auto dubbing enabled on my channel, but that process is handled entirely by YouTube, not me. The subtitles appear fairly quickly, usually within hours, but the translated captions and the audio dubs can take a few days after a video is published, depending on the language. There's nothing that I can do to manually restore or turn them on. They are on, and once YouTube finishes processing them, they should show up automatically.
So I would suggest if there's a video you want to watch that isn't dubbed in your language yet, just come back in a day or two and check; maybe by then it'll be done. If it's an older video and you want to watch it and you don't see the translations, let me know which video it is and I'll go back and check, because I have noticed that some of my old videos from years ago don't have translations on. I don't know why. I thought I went through and turned them on for everybody, but you never know. Let me know specifically and I'll look into it. For new videos, you might have to wait a couple of days. That's all YouTube.
Mlucle 7 says, "Though I love the idea, I'm old school. So my users will use whatever color I set and they'll like it. It's the Henry Ford rule: you can have any color you want as long as it's black." I get it. I've found that with a lot of beginners, fewer customization options actually makes support easier. So when I say, "Go to the order screen - the green one," they know exactly what I mean. Once you start changing colors and can rename button captions and form titles, that shared reference goes right out the window. It's still a nice option to have, but yeah, you don't want to give it to everybody.
What I have found is that something like that works best for the developer or the manager, so that they can go in and change the colors for the system, not necessarily on a per-user level. But again, my job is just to show you the Lego pieces; you can put them together however you want.
ShadowDragIn, also about the app settings, says: "I've been hard coding paths to folders in my databases, so when I reuse the code, I have to remember to track down each use and update to new paths." In that particular case, if you're going to hard code stuff, I like to do it in a separate module, just a database-level module, and all it has in it are all the constants that I use. Those could be folder paths, passwords, API keys, settings like max order number, or whatever settings you want. So they're all in one spot - you don't have to go track them all down throughout your code.
But yes, an app settings table like that makes perfect sense. Hard coding paths works until something moves. Change a folder where the images are stored, and now you're changing that path all over the database. You have to chase it down. Storing these things in a settings table lets you change it once and be done. Glad the technique helped, and glad for the comment as always.
Next up, Zia says, "Awesome sir, love you again." I love you too, and thank you for the comment.
Next up, Flants is talking about my Tasks video. He says, "Can you please show us how you do recurring tasks? I'm lost where to begin creating a recurring task that stores the old and creates the new." Okay, I think I see what you're talking about. That's a great question, by the way. In this Tasks video, the recurring task approach I show keeps the same task record and just moves the due date forward. This works well for simple reminders. But you're absolutely right that sometimes you want to keep the old task and create a new one, especially if you want to preserve notes, history, completion details, original dates, that kind of stuff. You're not the only one that's asked for this, so I've added it to my to-do list for a future video.
It's going to be basically the same version of this database, but it'll copy the task, carry forward the selected fields like your description or whatever, and allow you to keep a history of all the ones that have been completed in the past. Thanks for the suggestion. Glad you enjoyed the video, and yes, I've added this to my list, so keep an eye out for it.
Also, while I'm at it, I do have a Task Management template that I've built that does behave that way. When you have a task, when you mark it completed, it will keep the old one and just make a new one for the next date. That way, you can keep all the history and stuff. So check that out. That's my Task Management template. It's on my website. I'll put a link down below.
Next up, I don't get asked a lot about hardware, but Bruce from the UK, one of my Gold members, says, "I'm thinking about buying a new laptop. Do you have any recommendations?"
Well, that's a tough question. It's like asking what kind of car should I get? It really depends on what you want to use it for. Do you want speed, comfort, luxury, great fuel economy? It's the same with laptops or computers in general. Are you looking for a real workhorse that can replace a desktop, something thin and lightweight, or inexpensive for travel or casual use on the couch? Different needs call for different machines.
Personally, I've always had really good luck with Lenovo. I don't even own desktop PCs anymore. I've been buying all laptops for like the last 10 years. My daily laptop is a Lenovo Legion. It's technically a gaming laptop, so it's got plenty of horsepower and strong graphics. It makes it really good for video recording, AI work, and resource-heavy tasks.
My last big one was close to $2,000, but you definitely don't need to spend that much to get something solid. Just a quick look on Amazon, here's a really good one for $900. I think this would be just fine for most people. I'll put a link to this one down below. Yes, click my link. I get a little Amazon commission if you guys buy stuff from my links, so I'll get like $2, but it's something. I think this one here is a little closer to the specs for what I bought.
My first advice is to nail down what matters most to you: Is it weight, performance, battery life, budget? Once you have that figured out, shopping gets much easier if you narrow it down to a couple of choices. And honestly, ask ChatGPT. Say this is what I want, what do you recommend? It'll do a search based on your preferences and find something good for you.
Picking a laptop today really isn't like it was back in the 90s when I started building PCs. Back then, you obsessed over every component. You needed this video card because it ran that game better or this processor because it shaved a few seconds off compile time. Everything was a trade-off and the wrong choice actually mattered. But today, things are way more standardized. For most people, I think buying a laptop is just like buying a toaster or a new TV. You pick the size you like, make sure it's got enough RAM and storage, and you're done. Performance differences exist, but they're nowhere near as dramatic as they used to be, especially for everyday work.
If you're surfing the web or browsing documents or even building Access databases, it's not a huge deal unless you're playing high-end games or doing really cutting-edge AI work or video processing. Then it really does make a difference. I can tell - compiling videos is probably the most resource-intensive thing I do because I record in short segments and then I piece them all together. That processing time from my last laptop, which is now about four years old, to the current one that I have, which is a year and a half old, is twice as fast. So it would take 10 minutes before to compile a video; now it's done in four minutes, which is a huge deal for me.
As far as reliability goes, I've had very good luck with Lenovo overall. My only real complaint is the space bar. I'm a pretty rough typist. My right thumb tends to really hammer on that space bar. My last few Lenovo laptops, that space bar eventually got a little wonky even though the rest of the machine was still fine. The space bar, you could tell, was just not right. I love how their keyboards feel overall, but that space bar seems to have about a one-year lifespan. Other than that, no major complaints.
So I hope that helped.
Next up, Leslie: "Is there a value in learning Access in 2025?" Well, 2025's almost gone. But is there value in learning Access in 2026? Absolutely.
First of all, Access has not been discontinued. I hear that one every couple of months. It's still actively supported and updated by Microsoft. Millions of businesses use it every day. Access is great for building real working business tools quickly - that's the important part, quickly. Customers, orders, inventory, tasks, all that stuff, customized reports, without needing a full dev team. It sits in that sweet spot between Excel and a full-blown enterprise system.
Maybe most importantly, and this often gets overlooked, learning Access teaches you database thinking: tables, relationships, queries, forms, and logic. Those skills transfer directly to SQL Server or MySQL or just about every other database platform out there. So if Access solves your problem, then yes, there's definitely value in learning it. Especially if you have a small business or a small team, you know, 5-10 users, Access fits that sweet spot where you can build something yourself quickly and easily. You don't need to pay a monthly fee for these enterprise systems or cloud-based tools. No, Access is perfectly fine.
I got a video that talks all about it in detail. I haven't updated the video itself since 2023, but I post some additional notes here every year. It's probably about time to redo this video, but no, Access shows no signs of slowing down. It's still doing well.
Does Microsoft devote as much energy, resources, and budget to Access as I'd like them to? No. Should they? Yes. It's a fantastic tool, but it's still alive and still being actively supported. So yes, learn it. Watch my videos.
Next up, Soumuch says, "Thanks for sharing, but the video quality is not clear." Thanks for letting me know, but the video itself is playing fine for me and for most viewers. The day that I release a video, it gets at least 1,500 views. If there's a problem with the video, I get 300 comments the next day saying, "Hey, there's a problem with the video." That has not happened a lot. I think in the past 10 years, maybe once or twice I posted a video with a problem in it.
It's probably a buffering or caching issue on your end, maybe your internet connection. I'd recommend trying to refresh the page, check your playback resolution, clear your browser cache, and reload the video. Try an incognito window, too; sometimes that'll fix any browser cache problems. Once a video stream gets partially corrupted during download, your browser can keep replaying the bad cached copy, so clearing your browser cache (say that 10 times fast) usually helps. Try a different browser or a different device. Try your phone or something else to watch it. If you need to learn how to clear your browser cache, I have instructions here. I think I cover Chrome. Chrome and Edge are pretty much the same thing. I'll put a link to that page down below.
All right, next up, Easy Speak. Trying to paraphrase what you wrote there. You built an Excel spreadsheet that generates an infinite calendar and it worked fine for years. Then, after opening it in OpenOffice, then converting it back to an older Excel format, one sheet now shows a circular reference error, while another sheet still calculates dates correctly. Copying and pasting seems to make things worse. Why would converting or copying the file cause circular references and what's likely going on?
If I'm reading that correctly, it definitely sounds like a circular reference caused by the conversion and the copy-paste process. Different spreadsheets - Excel, OpenOffice, older Excel formats, even Google Sheets - handle formulas and calculation order differently. So when you paste or convert sheets, references can shift in ways that aren't always obvious, and you can't easily see the things that are different. That's especially true with date formats and infinite calendar logic.
So my guess is that sheet two ended up referencing itself indirectly after the conversion, which is why you're seeing circular references. Even though sheet one still looks correct, it might not be. I'd start by checking Excel's circular reference warnings and stepping through the formulas to see what changed during the paste. These kinds of conversions can definitely produce some bizarre results. I don't like copying from one sheet format to another because it's going to be more work than it's worth to just rewrite the formulas themselves. Of course, if you need more help, I cover circular references in my Microsoft Excel 231 class, so I'll put a link to that down below as well.
Jay Dragon, once again talking about Fitness Database 3, says, "I need a coffee cup that says 'Save it, close it, open it.'" Guess what? I've got one. It's in the merch store. I'll put a link down below. There's your link, put it down below in the description and click on it, too.
He also says, "That's pretty clever how you use OpenAI to get the info from the foods you were missing data for." Yeah, that's something that I'm finding a lot. One thing that I'm really loving using AI for in my database is stuff like that. I don't want to have to try to find a nutrition database online, program for its API, figure out its fields, and maybe get an API key. I can just say to GPT, "Hey, get me the protein, the calories, the fat from a bag of potato chips," whatever, and it just does it.
Another thing that I find that it helps with, and I don't mean to insult anyone with this, but sometimes I get some long, rambling customer emails. They go on for 15 paragraphs about the background of the database and so on, and then the question is buried at the end. The first thing I do when I get a big giant email like that and it comes into my Access database for customer service, I click on a Summarize button. I told the bot, I said, "Look, I need to remove any filler, any information that I don't need, and just get to the point." That saves me so much time every day - identify things I need to address, and if there's a question buried in here, tell me what it is. Then I can answer it quickly.
That's those are the things that I love. You can do a basic spelling and grammar check with what's built into Access, but looking at the context of the email, that's where the AI comes in. I've got a lot more planned with merging Access and AI, so stay tuned for that.
Next up, this is an interesting one. Don says, "I have Excel 2007. At the top, it doesn't list File. It only shows Home, Insert, Page Layout, Formulas, Data, and so on. What do I do?" So back in the old style of Excel, we're talking like Excel 2003 and earlier, we had this classic old File, Edit, View menu. Then along comes Office 2007, and they completely redid it and created this thing called the Ribbon. Notice, no File, right? Then in Office 2010, they put the File tab back.
If you've got 2007, you're just stuck in this middle version where that big round Office button up there - that's your File menu. Click on this guy, and there you see they had it like that. Then they changed it and everybody complained because it was too confusing, which it was. I hated the Ribbon when it first came out, but now I love it. At the time, I really fought against it because everyone was used to this. This was fine. This was perfect. This worked great, but this does actually work better. The Ribbon is actually better, except from a developer standpoint it's harder to customize. I really miss the customizable menu bars. I'm getting off on a tangent now.
That big round button right there, that's your File button. Just click on that.
It's pretty cool when I can do searches for images on Google and my own site shows up. I love that.
Next up, Equeral. He translated it for me, too, so I appreciate that; you prevented me from having to use Google Translate. He says, "I don't understand how you don't have a couple of million subscribers." Yeah, I don't understand it either. I want that million subscriber plug. I got the 100,000 subscriber button. YouTube sends you a button, which is pretty cool, but there's one for a million, too. I did the math. I figure I'll have about a million subscribers by the time I'm 146 years old at the current growth rate. We're gaining about a thousand subscribers a month, so it'll take me a while.
No, I do appreciate that. If I were making cat videos or chasing trends or buzzwordy titles, I probably would have a lot more subscribers, but Microsoft Access is a much smaller niche, so I'm kind of like the big fish in a small pond. Honestly, I'm perfectly happy with that. I love this community. I love Access. It's been my passion since I started working with it in version 2.0, so we're talking like 1994, I think. I will always focus on Access. But if you look at my channel, the number one video I have with the all-time highest number of views is a Microsoft Word video, and Excel makes two of the top 10. So even though my focus is primarily Access, there are still a lot of those people out there.
I'm definitely adding some more Word and Excel content moving forward in the future, and also I've got some SQL Server content coming too. That's going to be specifically with taking your Access database and upgrading it into SQL Server. That's coming up soon in the new year.
Thank you very much for the comment. Muchisimas gracias, and keep the comments coming.
Next up, Sani says, "I'd like to see your video on sending reports to WhatsApp." I know WhatsApp is hugely popular in Europe, Africa, and parts of Asia. I installed it on my phone when I took a trip to Europe a while back, but once I got home, I stopped using it. No one here in the States really uses it. So it's not something that I personally work with day to day. That said, if enough people are interested in seeing WhatsApp integration, let me know. Post a comment down below. If there's enough demand, I'm always open to revisiting ideas. Squeaky wheel gets the grease. It's not something I use, but it can't be that hard.
Finally today, we have one from Jose, who says, "How's it coming on the course on SQL Server?" I just mentioned this a few minutes ago. It's still in development. It's moving along. It's a little bit slower right now because this time of year is always busy for me with the holidays. My plan is to start releasing stuff after the first of the year, but I try not to give hard timelines because I'm terrible at keeping them. In the meantime, there are literally thousands of hours of other content on my website, so there's plenty there if you're looking for some holiday season binge watching.
Just a reminder, Access Day 2026 is officially on the calendar, so save the date. It's happening Friday, March 27th, 2026 in the Redmond, Washington area. I went to last year's event. I had a great time. Lots of solid presentations, great conversation, and even some folks from the Microsoft Access team at Microsoft showed up to talk about and demo some of the stuff they were working on. Just to be clear, I'm not presenting. I'm just attending like everyone else, there to hang out, learn some stuff, and talk Access with you guys. They're still finalizing the speaker list, and they're also planning an optional dinner afterward so everyone can get together and talk nerdy Access stuff. So if you're in the area or can make the trip, definitely mark your calendar, and I'll share more details as I get them.
Before you go, don't forget to stop by my website, 599cd.com. Check out the What's New page. I'm always working on new videos, updates, templates, and random bits of Access goodness. So it's worth a look to see what you might have missed.
I'm still running my holiday sale. I do one sale a year, guys. I don't have a Memorial Day sale, Presidents Day sale, Fourth of July sale - I don't do all that. I do one holiday sale. It starts usually Black Friday and goes to the end of the year, that's it, so you can get 50 percent off all of my courses, seminars, templates, and if you sign up for one of my annual memberships, you get an extra month free. That's running until the end of the year. January 2nd, I cut it off, so that's it. So check it out. There's a link; I'll put a link down below.
Don't forget to check out my Captain's Log, where I post my thoughts about whatever I happen to be thinking about that day - sometimes about Access, sometimes science, sometimes sales, sometimes how my wife's little red light mask makes her look like the master control program from the original Tron movie, but you know, whatever. Remember to stop by the merch store, get your merch, including yes, the "Save it, Close it, Open it" mug and t-shirt. I actually have this one on my desk because it's my favorite.
Pick up my Access Beginner Book on Amazon. Makes a great holiday gift, folks.
And don't forget to subscribe to my mailing list. You'll get a notification every time I post a new video. I know YouTube is great, but they don't always notify everybody every time I release something new. So if you want to get notified, get on my mailing list.
That's going to do it for your Quick Queries video for today. Hope you learned something. Live long and prosper, my friends. I'll see you next time.
Quiz
Q1. What is the most common cause of the "Enter Parameter Value" prompt appearing unexpectedly in Microsoft Access?
A. Typing errors in table or field names within a query
B. Using too many queries in a single database
C. Not compacting and repairing the database regularly
D. Having too many users connected at once
Q2. According to the video, why are YouTube comments not the best place to ask for detailed tech support?
A. The comments are not visible to the creator
B. There is usually not enough information provided for proper diagnosis
C. The creator does not read any comments
D. YouTube automatically deletes most comments
Q3. What is the main recommendation for organizing constant values like folder paths in a database?
A. Hardcode them throughout the database wherever needed
B. Store them in a single, separate module or in a settings table
C. Save them as properties of each form
D. Keep them in an external text file
Q4. Why are comments important in programming, according to the video?
A. To allow compilers to better process your code
B. To make the code run faster
C. To help future readers (including yourself) understand why a particular approach was taken
D. They are required by most programming languages
Q5. What is a potential downside of giving users too many options to customize the user interface, such as colors, in an Access application?
A. It increases database corruption risk
B. It makes technical support and communication more difficult
C. It doubles the file size of the database
D. It disables VBA code from running
Q6. What is one advantage of using an app settings table instead of hardcoded values in Access?
A. It allows all users to view the VBA code
B. It avoids security issues by storing passwords in plain text
C. It makes updating settings easier since changes only need to be made in one place
D. It prevents users from opening the database
Q7. How does the Excel 2007 "File" menu differ from earlier and later versions?
A. It does not have any menu for file-related tasks
B. File operations are performed via a circular reference
C. It uses a round Office button instead of a "File" tab
D. It only allows printing but no saving
Q8. What is likely the cause of a circular reference error after converting an Excel file between different spreadsheet programs?
A. A virus infecting the file
B. The conversion or copy-paste process changed formula references
C. An Excel setting turned off by the user
D. Excel automatically deletes empty rows
Q9. What is a best practice if you want to preserve notes and completion dates for recurring tasks in a database?
A. Overwrite the same record each time
B. Keep the same task record and only update its due date
C. Copy the task record, creating a new one for each occurrence
D. Store all data on a separate spreadsheet
Q10. What should you do if YouTube auto-translated subtitles or audio dubs are missing for a tutorial?
A. Unsubscribe from the channel
B. Contact YouTube support immediately
C. Wait a few days for YouTube to process them, and if still missing, notify the content creator
D. Refresh your device firmware
Q11. How does learning Access benefit someone beyond using Access itself?
A. It only helps with learning Excel
B. Access teaches general database skills that transfer to systems like SQL Server or MySQL
C. It prevents the need to ever learn any other software
D. It is only useful for desktop databases
Q12. What factor was highlighted as making laptop purchasing today easier than it was in the 1990s?
A. All laptops now have the same performance
B. Components are more standardized, making choices less critical for most users
C. Every laptop is now customizable by the user
D. No laptops overheat anymore
Q13. What is a practical tip for troubleshooting video playback quality issues on YouTube?
A. Only use Internet Explorer
B. Clear your browser cache and try reloading the video
C. Reduce your monitor brightness
D. Upgrade to a 4K monitor
Q14. In the video, what is the creator's approach to handling long customer service emails in his Access database?
A. Assigning them to assistants
B. Deleting emails longer than one paragraph
C. Using AI to summarize and extract key points
D. Copying them into Word for manual summary
Q15. What is the general wisdom about hard deadlines for new course releases, according to the video?
A. Never announce new content in advance
B. Set specific dates and always meet them
C. Avoid hard timelines because production can be unpredictable
D. Only release content after Access Day
Q16. What is Access Day and what type of event is it?
A. An official Microsoft conference exclusively for Excel
B. A user-focused event with presentations and opportunities to talk with Microsoft Access team members
C. An online-only Access training seminar
D. A recurring holiday sale
Answers: 1-A; 2-B; 3-B; 4-C; 5-B; 6-C; 7-C; 8-B; 9-C; 10-C; 11-B; 12-B; 13-B; 14-C; 15-C; 16-B
DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.
Summary
In today's Quick Queries video, I'm coming to you a little later than usual, thanks to the holiday weekend, but the quick questions and answers are still as timely as ever. Let's go through some of the great questions and comments that came in this week.
Our first topic deals with a very familiar issue in Access: the sudden appearance of that "Enter Parameter Value" dialog. If you ever see Access asking you for a parameter you didn't set up, it's usually a sign that a field or table name is misspelled in your query or form. Ninety-nine percent of the time, that's the underlying problem. Access prompts you because it can't find the object you're referencing. I've got a comprehensive TechHelp video on this topic, which I'll link for you. Remember, offering enough information is essential when asking for troubleshooting help, and YouTube comments usually aren't detailed enough for diagnosing problems. For deeper queries or more complex issues, my website forums are a more effective way to get support.
Next, a question about handling user-specific settings in an Access database, especially as discussed in my App Settings extended cut. We handle this by creating a user field, retrieving the user name from the system, and checking settings accordingly. That ensures each user can have their own configurations.
Some folks noticed that my membership on my own website appears as Gold level. I do this because I have an admin override, allowing me to set different levels for testing, but it truly doesn't impact my actual access.
A comment from Didilev brought up the importance of writing comments in your code. Even if you're developing solo, those notes will help your future self understand the reasoning behind decisions you might not remember years later. Languages like assembler make this especially vital since they aren't as easy to read as VBA or even C. Comments aren't just about what the code does, but why you did it that way.
Acknowledging some kind words, Paulo wrote a very thoughtful comment that made my day. Thank you, Paulo. Messages like that inspire me to keep producing more content.
Jade Dragon pointed out an issue with assigning colors and referenced the notorious level 256 bug in the original Pac-Man arcade game. Hardware limitations caused quirks like these, which links nicely to database UI customization. Allowing users to freely modify the interface can be empowering, but keeping a default or reset option is a smart move.
Fun in the Rain 13 asked about my fitness series. The series is still active, but it's on a temporary slowdown for the holidays. There's a backlog of new topics I want to cover, especially around integrating workout and weight tracking, so there's plenty more coming up.
Michelle inquired about the lack of Italian YouTube translations on my videos. The translation and dubbing features are managed entirely by YouTube, not me. Subtitles show up within hours, while translations and audio dubs may take a few days. For older videos, if translations are missing, let me know the specific one, and I'll check on it. For new content, just be patient—a couple of days should do the trick.
Mlucle 7 shared the classic view that users should accept whatever interface they're given, which definitely simplifies support. Limiting customization does help when giving instructions, as visual cues remain consistent.
ShadowDragIn brought up the trouble with hardcoding paths in databases. If you have all your configuration constants in a module, it's easier to update, but using a settings table is even better. That way, changing a folder location or other key setting is done in one place, not scattered everywhere in your code.
A quick thanks to Zia for the positive comment—much appreciated.
Flants asked about recurring tasks in my Tasks video. The current system simply moves the due date forward on completion, but sometimes you want an archive of all past tasks. That way, you can reference previous notes, completion details, and so on. This is a great suggestion and I've added it to my list for a future video. Meanwhile, my Task Management template on the website already maintains that historical record for recurring tasks.
Bruce from the UK asked about laptop recommendations. The answer depends entirely on what you need the computer for. For myself, I've had great experiences with Lenovo laptops, particularly their Legion series. My advice is to decide what matters most—price, size, weight, performance—and work from there. For general Access development or daily office tasks, most modern laptops are more than up to the job. Only if you're doing serious gaming, AI work, or video processing will you need the upper-tier machines.
Leslie asked if there's still value in learning Access going into 2026. Absolutely. Microsoft Access is still fully supported by Microsoft and widely used, especially among small businesses. It's perfect for quickly building customized business solutions, and working with Access develops essential database skills that transfer to enterprise platforms. I have a video that explores this in more detail, and I do update its notes annually.
Soumuch mentioned having trouble with video quality on YouTube. Typically, playback or display issues are related to your local internet, browser cache, or device. Try clearing the cache or using another browser or device to see if that improves streaming quality. I've also got a help page on this topic available on my website.
An interesting Excel question came in from Easy Speak, describing a circular reference error that showed up after opening a spreadsheet in OpenOffice and converting it back to Excel. File conversions between different spreadsheet programs can introduce odd errors, especially with formulas or references, due to different handling of calculation orders. Check for hidden self-references and circular dependencies after any such conversion, and be prepared to reconstruct formulas if necessary. For a detailed overview on circular references, refer to my Microsoft Excel 231 class.
Jay Dragon mentioned the "Save it, close it, open it" mantra from my Fitness Database 3 video—fittingly, we now have mugs with that phrase in the merch store. He also liked the way I use OpenAI to fill in gaps for missing food data and to summarize lengthy customer emails. Integrating AI with Access for both quick data retrieval and efficient customer service has made my workflow much easier.
Don asked about the missing File menu in Excel 2007. That version replaced the classic menu with the Ribbon and introduced the round Office button in place of "File." In Office 2010 and later, File returns as a tab. While the change was hotly debated, the Ribbon has proven itself over time as a more organized interface.
Equeral asked why my channel doesn't have millions of subscribers. The main reason is that Microsoft Access is a niche area, but I appreciate every supporter. Word and Excel videos remain my most popular, so there will be more content on those topics as well as upcoming tutorials on migrating Access databases to SQL Server.
Sani suggested making a video on sending reports to WhatsApp. While WhatsApp is not widely used in my local area and I don't use it daily, I am open to suggestions if enough viewers are interested. Just let me know in the comments.
Jose checked in about the SQL Server course. Progress continues, albeit a bit slowly because of the holiday rush, but look for new releases after the start of the year. In the meantime, there are plenty of other tutorials available on my site if you want to binge over the holidays.
A reminder—Access Day 2026 is set for Friday, March 27, 2026, in Redmond, Washington. I'll be attending (not presenting), so if you're in the area, I recommend joining for a day of presentations and networking with Access enthusiasts and even some Microsoft staff.
Be sure to stop by my website, 599cd.com, check the What's New page, and take advantage of the annual holiday sale. Course discounts are available until January 2. Also, check out the Captain's Log blog and the merch store for mugs, t-shirts, and my Access Beginner Book. Don't forget to sign up for the mailing list to stay updated since YouTube doesn't always send notifications for new videos.
That wraps up today's Quick Queries. I hope you found the answers helpful. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below.
Live long and prosper, my friends.
Topic List
This is a casual Q&A/community update video discussing database troubleshooting tips, community questions, and general advice for Access, Excel, and related topics.
Article
If you have spent any time building queries or forms in Microsoft Access, you may have encountered a popup that says "Enter Parameter Value" when you try to run something. This message can be confusing, especially if you never created or set up any parameters yourself. Let me explain what is happening, why Access asks for a parameter, and how to fix it, as well as touching on some related questions and tips from users in the community.
When you see the "Enter Parameter Value" prompt, it almost always means that Access cannot find a field or object you referenced in your query, form, or report. For example, suppose you build a query that uses the field CustomerName, but in your table the field is actually called CustName. Access looks for CustomerName, cannot find it, and so it asks you to supply a value. The same thing can happen with table names, control names, or objects you might have renamed or deleted. In 99 percent of these cases, the issue is simply a spelling error or a reference to something that no longer exists.
Let us say you create a query in Access like this:
SELECT CustomerID, CustomerName FROM Customers WHERE State = "NY";
If your Customers table does not contain CustomerName (maybe it is called CustName), then Access will prompt you for "CustomerName" because it does not know where to get it. If you see that parameter prompt, review your query design and check every field and table name very carefully. Double-clicking names from the field list, rather than typing them, helps avoid this type of mistake. The solution is always to fix your spelling or update the query to use the correct field names.
This principle applies across different areas of Access. If you are building forms or reports and you bind a control to a field that does not exist, you will get a similar parameter prompt. Always check your field list and be aware any time you rename or remove fields, you must update your queries, forms, and reports as well.
Another topic that often comes up is when and where to seek help for Access issues. While YouTube comments can be a good place to ask quick questions, it can be hard to get detailed help if you do not give enough information. If you need specific advice, join a forum where you can post screenshots, describe your problem in detail, or even upload your database for someone to review. The more information you provide, the easier it will be for others to help you.
Moving on to another common point: the importance of adding comments to your VBA code. Comments are not just for other people. They are for your future self as well. Code you wrote five years ago will make much more sense if you left yourself notes about why you made certain decisions. In VBA, comments start with an apostrophe and turn green in the code window, which makes them easy to spot if you are scanning through a lot of code. For example:
' This section calculates the total price with sales tax included
TotalPrice = SubTotal * 1.07
You do not have to explain every single line, but a brief note on anything that is not obvious or where you made a choice for a specific reason will save you frustration in the future.
On the topic of application settings and paths, many users ask about storing folder paths, file names, or other settings. If you hard code paths in your VBA code, updating them when you change computers or move files can be a pain. A better approach is to put all your settings, like folder paths or API keys, either in a dedicated VBA module as constants or, even better, in an app settings table in your database. Then you can change the setting in one place and all your code can refer to it dynamically. For example, you might have a settings table with fields for setting name and setting value. In your code, you read the value out as needed. No more chasing down paths throughout your modules.
Let us also talk about laptop recommendations, since many people ask about what kind of computer is best for Access development. In general, most modern laptops with a decent amount of RAM (8 GB or more), a recent processor, and a solid state drive will run Access and typical Office apps smoothly. Unless you work with very large datasets or do heavy video editing, most new machines are more than enough. Your specific needs such as weight, performance, or battery life may guide your choice. I have had good luck with Lenovo laptops, especially their Legion series for higher performance. However, reliability, price, and keyboard feel can be deciding factors for many people. For everyday Access development, you do not need a high-end machine, but do not skimp too much on memory or storage if you expect to use it for several years.
A question I often hear is whether it is still worthwhile to learn Access in the current year or the next. Despite rumors you may have heard, Microsoft Access is still supported and widely used in business environments around the world. If you need to quickly build custom solutions for tracking customers, orders, tasks, or inventory, Access allows you to do so much faster than with many other platforms. Learning Access also gives you a foundation in database concepts like tables, relationships, and queries that transfer directly to other databases like SQL Server or MySQL. For small to medium businesses or teams, Access often sits in the sweet spot between Excel and more expensive enterprise solutions. Do not be deterred by people claiming it is outdated; it remains a strong choice for many scenarios.
If you deal with recurring tasks and want to build a system that keeps track of completed tasks and automatically creates new ones while archiving the old, that is a common scenario in task management databases. One approach is to have a button or VBA code that, when you mark a task as completed, copies the relevant fields to create a new record with a new due date while leaving the history of past tasks intact. Many task management templates can do this, and if you are building your own, plan on copying the current task record, changing the due date, and marking the old one as complete. That way, you always keep a clear record of what has been done in the past.
If you need to store code or settings in your database, consider the following pattern in VBA:
' Example: Global Settings Module (modAppSettings)
Public Const IMAGE_FOLDER_PATH As String = "C:\\MyImages\\"
Public Const MAX_RECORDS As Integer = 1000
Now, whenever you need to refer to those paths or settings, you use the constant rather than typing the folder path in multiple places. For dynamic values that might change, use a settings table and VBA function to retrieve the value:
Function GetAppSetting(strSettingName As String) As String
GetAppSetting = DLookup("SettingValue", "AppSettings", "SettingName='" & strSettingName & "'")
End Function
Then you can call GetAppSetting("IMAGE_FOLDER_PATH") wherever you need that path in your code.
Some users also ask about converting files between different Excel versions or alternative spreadsheet programs like OpenOffice. If your Excel file suddenly starts showing circular reference errors after being opened and saved in another program or format, it is likely that some formulas now reference themselves due to how different programs interpret the layout or calculation order. Always check formulas for self-references after converting, and be especially careful with complex sheets like calendars. Sometimes, rewriting the formulas from scratch is easier than chasing down subtle changes introduced by the conversion.
Finally, quick answers to other common questions. If you are using Excel 2007 and cannot find the File menu, look for the big round Office button in the top left—that is your File menu. In later versions, Microsoft restored the File tab to the ribbon, but in 2007, the Office button is what you use.
If you are interested in integrating Access with WhatsApp or other messaging tools, it is certainly possible. While WhatsApp itself is not as popular in the US, there are APIs and workarounds for sending messages or reports to WhatsApp contacts from your Access database. Let me know if that is an area you want more tutorials on.
Events like Access Day are a great way to meet others in the community, see presentations, and talk with both users and Microsoft developers about the future of Access. Watch for announcements if you can attend.
For more resources, you can always check my website for new tutorials, templates, and community forums where you can ask questions and get help from other users. If you want to keep up with new lessons and updates, be sure to subscribe to my mailing list. And if you are still learning, my Access Beginner Book makes a thoughtful gift for anyone starting out.
To sum up, Access is still a relevant, robust tool for business data solutions. When you get an "Enter Parameter Value" prompt, review your field and table names carefully to spot typos or missing references. Store your settings and paths in one place to make maintenance easier. Keep code comments clear and use them liberally to help your future self. Do not be afraid to ask detailed questions in forums if you get stuck, and always back up your work before making big changes. Stay engaged with the community and keep an eye out for new videos, templates, and events.
Happy holidays, good luck with your databases, and keep learning!
|
