How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.
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
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month8 days, 1 hour left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.