Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Set default value for a field - via VBA
Posted on 2012-12-21
Is it possible to change the deafult value of a field (within a table), via VBA?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
4 Comments
Active today
Something like this:
Dim dbs As Database
Dim fld As DAO.Field
Set dbs = CurrentDb
Set fld = dbs.TableDefs("YourTableNa
fld.DefaultValue = 0
Set fld = Nothing
Set dbs = Nothing
mx
Dim dbs As Database
Dim fld As DAO.Field
Set dbs = CurrentDb
Set fld = dbs.TableDefs("YourTableNa
fld.DefaultValue = 0
Set fld = Nothing
Set dbs = Nothing
mx
Active today
Short version:
CurrentDb("YourTableName")
mx
CurrentDb("YourTableName")
mx
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month4 days, 3 hours left to enroll
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.