automatic data input in table

[cora]

can anyone help; - I'm trying to add year end date that
automatically puts itself in field, either by list box or
some other means ie

in field year_to_date january 2004 would appear or
february 2004

 

[Jeff Boyce]

I don't understand. "Year end date" means "12/31/2004" or "12/31/2005" to
me. Your example used "January 2004" and "February 2004".

(by the way, you can enter any date in a date/time field, but can DISPLAY it
in a query or form as "MMMM YYYY" -- the date's still there, just not shown
in total.)

More info, please...

Jeff Boyce
<Access MVP>

 

[cora]

-----Original Message-----
I don't understand. "Year end date" means "12/31/2004" or "12/31/2005" to
me. Your example used "January 2004" and "February 2004".

(by the way, you can enter any date in a date/time field, but can DISPLAY it
in a query or form as "MMMM YYYY" -- the date's still there, just not shown
in total.)

More info, please...

Jeff Boyce

Hello Jeff

Thanks for responding back -

I have a database with different fields, one being year
end. In that I need to put a date in ie January 2004 or
February 2004. I tried to copy January 2004 and paste it
in say the next 10 lines down, but I can only paste one at
a time not paste 10 at one time. I have about 1500 entries
to do, and thought that maybe (or any other ideas you
have) I could create a list box or something like that to
save me typing the dates in.
year-end
january 2004
january 2004
ditto

Hope this amkes sense

regards

cora

 

[Jeff Boyce]

Cora

(see in-line below)

Hello Jeff

Thanks for responding back -

I have a database with different fields, one being year
end.

I'm still confused about what YOU mean by "year end".

In that I need to put a date in ie January 2004 or

February 2004.

I'm still confused about what you mean by "a date". If you tell me January
2004 is a "date", and, moreover, a "year end", my question is "do you mean
the 1st of January, or the 31st, or the 15th?"

I tried to copy January 2004 and paste it
in say the next 10 lines down, but I can only paste one at
a time not paste 10 at one time.

If you were working in Excel, you could copy/paste into a range of cells.
Access is a relational database, not a spreadsheet. If you are trying to
"paste" into a range of cells, you are probably working directly in the
table. Not a good idea... Data entry/display is handled much better in
forms in Access.

I have about 1500 entries
to do, and thought that maybe (or any other ideas you
have) I could create a list box or something like that to
save me typing the dates in.

If you are trying to paste in the same value for an identifiable subset of
all your rows in a table, use a query (an update query). But if you are
pasting the character string "January 2004", Access will NOT treat it as a
date (see comments above).

Out of curiosity, why are you trying to do this? I ask because there may be
alternative approaches to what you are trying to do (not "how").