I so want to know how to create a popup form in a NotInlist event where more data is needs (First Name, Last Name, Age etc)  to be entered and when closed it requery the listbox.  Please!

Richard, you're the first victim to have your comment moved. Sorry if the reply link from the notification emails sent you to the wrong place. I thought of making this list after I replied to you.

List Cleaning Example

Backing up your ACCDB and MDB files every night to a Google Drive backup

Backing up individual records from a remote database - can be either a different ACCDB file, or even a database on the web (SQL Server, MySQL) - anything you can attach to as a linked table. I used this for backing up data posted on my web site. Everything (including this post) stored in my web site's tables can be pulled down this way or POSTED this way to the web site. I make a change to a course, it gets pushed to the web site with this handy backup routine.

Hi Richard and Thank you for making a great come back, I love what all you are doing now.
I would like to see a course on using SQL Server with maybe Azure or AWS. I have over 6000 customers I need to setup a SQL Server
so that everyone can have the Front End on the computer and be able to log into there own data file on the server.
I don't know if I setup an database for every customer or is it one database but when they login it will only show there data. I have customers that are in different locations that need to log into the same account and do live data entry.
I show the customer how to set it up using Drop Box or Google Drive but you know how that can turn out with your data file,,,, Not good and it can get corrupted really fast and it's not live data entry like using a server.

Thanks Richard
Ray White
Fog Line Software LLC.

Playing a custom sound (WAV file) in your databases and changing the volume level of your system

Hi Ray. Thanks for the words of encouragement. Yeah, I get asked that a lot. I'm going to put together some lessons showing how to set up a quick and simple back-end on SQL Server. My web hosting provider is GoDaddy and they have a pretty easy interface to set up and modify your tables. But the techniques will work no matter who your provider is.

Request from a customer: obscuring credit card numbers on invoices so they can see:

PAID with Discover 6....3832

On their invoices instead of the whole CC number.

Request from a customer: A new ProperCase function for names that are supposed to have capitals and lowercase letters in them. We learned about the StrConv function to convert to ProperCase in Access Expert 13. This will turn "smith" or "SMITH" into "Smith". But if you have a name like "McDonald" it will turn it into "Mcdonald" and "D'Angelo" into "D'angelo" which isn't desirable. So I'll show you how to build a custom function to leave the casing alone if it detects both upper and lower case letters in the string already AND change common/known names to their appropriate casing (using a table, of course).

This might help with the sound idea:

Sound (Control Panel)
http://599cd.com/tips/access/140722-sound/

How about generating numbers specific to what other information is in the record.
For example generating a customer number or a custom reference number.

Kevin, what would your criteria be? Or are you looking for some kind of unique number OTHER THAN an Autonumber just for record-keeping purposes? I had a database I built for a client where they wanted the order number to be a mixup of the customer's ID and the order date, so I made it something like 1234-200512-01 where their customer ID was 1234, the date follows in YYMMDD format, and then the number of the order on that day, so if they had 3 orders it would be 03. Is this what you're looking for?

I actually have an event that generates a customer number, as follows:

Private Sub GenerateCustomerNumber()

    Dim FnStr As String, LnStr As String
    Dim RND1 As Long, RND2 As Long, RndTotal As Long
    Dim ID As String
    Dim MyCustomerNumber As String
    
    Randomize
    
    FnStr = Left(FirstName, 1)
    LnStr = Left(LastName, 1)
    
    RND1 = Int(Rnd * 9999999)
    RND2 = Int(Rnd * 9999999)
    
    RndTotal = RND1   RND2
    
    ID = CStr(CustomerID)
    
    If Len(ID) = 1 Then
        ID = "00"

You hit the MAXLEN for the comment field here, but I see where you're going with that. Is there something that you wanted to learn how to do with this, or were you just making a (very helpful) suggestion for a topic to include for other students?

I had a conversation I was having with someone in my Facebook Access Group about how he doesn't like using IDs because if the table gets corrupted or you lose records, it's very difficult to go back and re-add the customer, and then link back up all of his contacts, orders, etc. So maybe I'll address this in an upcoming class too.

Updated Not In List techniques. I've been asked a few times recently about this. You're entering, for example, an order and there's a product you haven't put in the product table. So now you have to exit out, go back to the product form, enter in the product, then go back to the order form and finish putting the order in. It will be nice to have a quick Add Product pop-up form we could enter just the basics like the product name price and then fill in the details later. I've covered the not in list event and Access 324 and of course there is the simple list items edit form which I don't recommend except for the simplest of databases. But I'm going to cover this again soon because I learned some new tips and techniques too.

My "Are You Sure?" delete button enhancement. It's short and cute, but you'll like this one.

My SystemMessage routine - instead of cluttering your database with MsgBox command that interrupt workflow, you can make a SystemMessage that logs the issue in the background and lets you keep working. This is especially handy if you automate parts of your database like I do where things run on Timer events, like pulling in orders. You can log things like "cannot delete a paid order." It will still pop up a message in a text box on your main menu AND log it to a log table so you can see everything in the morning, but it allows your database to continue running without waiting for your click a YES/NO option on a MsgBox. I also enhanced mine to play sounds based on the message. :)

IsCreditCard and IsValidCreditCard - two functions to determine if a number is a credit card or not (because sometime people store things like "Cash" or "Paypal" in a credit card number field - happens all the time. And then another function to tell whether or not that card number is valid. You want to check the number of digits (16 for Visa/MC/Discover, 15 for Amex) check the first digit of the card, and then there's something called a Luhn Check which is a mathematical formula to determine if the card number is good BEFORE trying to process it. This lesson won't cover actual credit card processing, but if anyone WANTS to see how that's done, I can show you. I use Payflow Link for my processing, which is all done thru a web browser.

If you haven't figured it out yet, this is where I'm going to be dropping all of my ideas, and questions that students ask me that I want to answer in upcoming classes. It's easier for me to have them all in one place AND it lets you see what kind of lessons are coming up. Please join in and post your ideas here too.

Email Seminar Part 2 - or at least an addendum - bringing email INTO Access from Gmail via Outlook. See this post.