Calendar in Table Design view

[MescaBug]

Hi all,

Is it possible to have a calendar control in a table design view? All
our data is entered directly in tables. We don't use forms or queries.
We have roughly 5000 lines to add manually, so typing the dates by hand
is too time comsuming. It would be better if we could click the date on
a calendar. The other fields are all lookups, so we don't have to type
anything manually.

Thanks!

 

[Pieter Wijnen]

Nope,
Tables are for storing, Queries are for, well, Qyuering, forms are for
manipulating

Pieter

 

[Jeff Boyce]

If you are primarily entering dates in the current year, Access will "fill
in" the year for you if you type m/d and tab to the next field.

Considering how much "away from keyboard" effort is involved, are you quite
certain it is less work to let go of the keyboard, acquire the mouse, mouse
to and click the date, and reacquire your typing position on the keyboard?

By the way, a scan through the tablesdbdesign newsgroup will reveal a VERY
strong consensus against the use of tables for data entry, and especially
against the use of lookup data types.

If it's working for you, though...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[strive4peace]

Hi Mesca,

to echo Jeff, here is something you may want to read:

Don't use lookup fields in table design
http://www.mvps.org/access/lookupfields.htm

Even though you CAN define lookup fields in the table, it really is not
a good idea. You are allowed to use spaces and special characters in
names -- that is not a good thing to do either.

It is pretty easy to make a form based on a table with the wizard -- and
you can use a Datasheet form if that is what you are more comfortable with.

If you want to be able to (for instance) double-click on a date field
and popup a calendar, this is not hard to do if you are using forms, but
it is not something you can do with a table directly.


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[MescaBug]

Thanks for your help! Sorry for the late reply. I was on vacation.

I actually didn't develop this database but I will definitely recommend
a change in architecture. I've read a few things here and there and
everyone seems to agree that lookups must be avoided for the database
health.

 

[strive4peace]

you're welcome

I have a document that I send out on Access Basics to all who request it
-- helps if you are setting up a database or restructuring

I can also send you a calendar that pops up when you double-click on a
date (only works with forms though, not tables)

.... email me (address in my siggy) if you are interested and be sure to
specify what you want in the subject line


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*