In this video, I will show you how to set a default value for new customers so you don't have to type in data that's the same for most of them. If most of your new clients are locals, for example, you don't have to keep typing in city, state, and ZIP code. I'll also show you how to set a default value for the date to equal today's date.
Joanna from Key West, Florida (a Gold Member) asks: About 99% of my customers are locals. Is there any way to make it so I don't have to type in the City, State, and ZIP Code every time I get a new customer?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to use a form footer to provide that default value. This way if you want to enter a bunch of new records from, say, Florida, and then a bunch of new records from New York, you can set the default value in the footer, enter those records, then set the next one, and so on.
MEMBERS VIDEO:
[ Ссылка ]
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
LEARN MORE:
Default Values: [ Ссылка ]
LINKS:
ZIP Code Lookup: [ Ссылка ]
Access Beginner 3: [ Ссылка ]
COURSES:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, what is default value, defaultvalue, set a field's default value, setting default values, now, date, today's date, default value based on another field, default value today, query default value, textbox default value
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Ещё видео!