Automate a default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm rewording my a question. I need to allow a change to a fields default
value but not via access to the property sheet or form design. I need to
have the date value (Recap Date)in our invoice data entry form set and
automatically populate when entering a new record. I'm using a Switchboard,
so I would like to design a simple form to do this.
 
Lin,

I'm not 100 percent sure I understand your question. Do you want the form
to show the current date in the Recap Date field for any new records that
will be added? If so, you can accomplish this by opening the data entry form
in design view and entering =Date() in the Default Value properties of the
Recap Date control. If that's not what you're trying to do, I apologize.

Ken
 
Close.
All invoices coming in and being recorded are given the same date if they
fall within that current Recap period. For the weeks of Dec 6 - 17th the
recap date is that following monday, Dec 20th. On the 20th all invoice are to
be sent to City Hall for payment. So we record the invoice date [from the
invoice] and we record the recap date. It works as another checking or
sorting value. What I want to do is have that recap date, which changes
every two weeks, automatically populate that field in the invoice data entry
form.
 
Lin,

With something of a better understanding of your goals and knowing you're
looking for a simple solution without having to write a bunch of code, here's
what I would suggest. Create a table (tblRecapDate) with one date/time field
called RecapDate. Enter the current recap date in the that field. Close the
table. Open your form in desgin view and in the default value field for the
Recap Date control enter =Dlookup("[RecapDate]","tblRecapDate"). Now
whenever you enter a new invoice it will have the current RecapDate value in
the Recap Date field. You will have to change the value of the RecapDate
field in tblRecapDate every two weeks or whenever it changes, but that may be
easier for you to maintain than writing procedures to automate the process.
Hope this helps.

Ken

Lin Light said:
Close.
All invoices coming in and being recorded are given the same date if they
fall within that current Recap period. For the weeks of Dec 6 - 17th the
recap date is that following monday, Dec 20th. On the 20th all invoice are to
be sent to City Hall for payment. So we record the invoice date [from the
invoice] and we record the recap date. It works as another checking or
sorting value. What I want to do is have that recap date, which changes
every two weeks, automatically populate that field in the invoice data entry
form.

Ken Warthen said:
Lin,

I'm not 100 percent sure I understand your question. Do you want the form
to show the current date in the Recap Date field for any new records that
will be added? If so, you can accomplish this by opening the data entry form
in design view and entering =Date() in the Default Value properties of the
Recap Date control. If that's not what you're trying to do, I apologize.

Ken
Click to expand...
Click to expand...
 
Odd things. First thing this morning I created a combo box on the AV invoice
Data entry form and that was a good solution. 1 key stroke and enter. But I
thought I would at least try your solution. When I tried to repeat your
instruction the default line would appear to be save but actully wasn't.
Under the TAB for DATA in the Properties for the Field Recap Date I did
enter as discribed. But I also have some other data under this TAB:
Control source Recap Date
Inputting mask
Row Source type SELECT [A/V Recap Date].[Recap Date]
FROM [A/V Recap Date]
Bound Column 1
Limit to List NO

Should this be deleted?
Lin


Ken Warthen said:
Lin,

With something of a better understanding of your goals and knowing you're
looking for a simple solution without having to write a bunch of code, here's
what I would suggest. Create a table (tblRecapDate) with one date/time field
called RecapDate. Enter the current recap date in the that field. Close the
table. Open your form in desgin view and in the default value field for the
Recap Date control enter =Dlookup("[RecapDate]","tblRecapDate"). Now
whenever you enter a new invoice it will have the current RecapDate value in
the Recap Date field. You will have to change the value of the RecapDate
field in tblRecapDate every two weeks or whenever it changes, but that may be
easier for you to maintain than writing procedures to automate the process.
Hope this helps.

Ken

Lin Light said:
Close.
All invoices coming in and being recorded are given the same date if they
fall within that current Recap period. For the weeks of Dec 6 - 17th the
recap date is that following monday, Dec 20th. On the 20th all invoice are to
be sent to City Hall for payment. So we record the invoice date [from the
invoice] and we record the recap date. It works as another checking or
sorting value. What I want to do is have that recap date, which changes
every two weeks, automatically populate that field in the invoice data entry
form.

Ken Warthen said:
Lin,

I'm not 100 percent sure I understand your question. Do you want the form
to show the current date in the Recap Date field for any new records that
will be added? If so, you can accomplish this by opening the data entry form
in design view and entering =Date() in the Default Value properties of the
Recap Date control. If that's not what you're trying to do, I apologize.

Ken

:

I'm rewording my a question. I need to allow a change to a fields default
value but not via access to the property sheet or form design. I need to
have the date value (Recap Date)in our invoice data entry form set and
automatically populate when entering a new record. I'm using a Switchboard,
so I would like to design a simple form to do this.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top