| | |
|
|
|
add same data in mutiple records at once |
|---|
| message from =?Utf-8?B?YWRyaWFueQ==?= on 11 May 2004 |
how do i add same data to mutiple records at same time?
like to input data from the form and save button. save data will placed on mutiple records in one table/field
|
| Wayne Morgan replied to =?Utf-8?B?YWRyaWFueQ==?= on 11 May 2004 |
If you have criteria that will let Access determine which records you want
updated, you could use an Update Query to do what you're wanting.
|
| adrian replied to Wayne Morgan on 11 May 2004 |
thanks for quick rep.
my basic q : textbox in the form, i like to input date on
textbox [New_DATE]just one time and have was to fill all
empty record field call New_DATE..... it can be one
record or 200 records
which records you want
wanting.
4EBED86A6396@microsoft.com...
data will placed on
|
| Wayne Morgan replied to adrian on 12 May 2004 |
Ok, if I'm understanding correctly, you want the current entry to become the
default for the next record. To do this, in the AfterUpdate event of the
control, set the DefaultValue of the control to the current value of the
control. The syntax will vary slightly depending on whether the value is
text, numeric, or date.
Text:
Me.txtMyTextbox.DefaultValue = """" & Me.txtMyTextbox & """"
Numeric:
Me.txtMyTextbox.DefaultValue = Me.txtMyTextbox
Date/Time:
Me.txtMyTextbox.DefaultValue = "#" & Me.txtMyTextbox & "#"
|
|
Archived message: add same data in mutiple records at once (MS Access Error Message)
