Add Record with Query – data from controls on unbound form ~ DataPig
This video demonstrates a technique to add records from a form with unbound textboxes to an underlying table with no code except to run a query that does the heavy lifting. This uses a simple unbound form and then runs a query to add a record to a table. It show you how to make an Append query. The query, with no source tables, appends the values in the form's unbound textboxes to a new record in a specified table. Create columns by entering an expression in the Field cell to reference a control name on the entry form and then map that to a field in the new record using the Append To cell.
The video further suggests some edit/validation ideas that could be tailored to individual needs such as setting default values and modifying rules in the table design.
NOTE: in newer versions, choose Append from the Query Type group on the Query Design ribbon, or right-click in the source pane and choose Query Type, Append Query. Also better to use CurrentDb.Execute "Queryname" to run the query, and then no need to change SetWarnings (or Echo)
related videos for Append Query:
Shuffle Data Imported from Excel (24m45)
• Shuffle Data Imported from Excel
Learn Access 4 Tables and Relationships (36m05)
• Learn Access -4- Tables and Relationships
This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.