In Access create a date/time field with format dd/mm/yyy hh:mm:ss ampm
In VB.net update field with Now() function.
Date appears correctly but time is always 12:00:00 AM
Any sugestions appreciated.

I have a field [LastUpdated] in table [MemberFile].
I need it to automatically enter the date anytime any of the fields in the
Memberfile table is changed.  But I don't need or want it to put a date in
the field if the Memberfile is opened in either the front or backend, only

I am creating a database for server parts.  My company has
8 servers onsite at one of our largest customers for the
sole purpose of using the parts in these servers to repair
any of our customers servers.  Of the 8, three of them are

I have set up a database with a members table and a
payments table.  I need to be able to apply payments to
an individual member... all goes well until members have
the same last name, then the payment posts automatically

I have a numeri field that is set for two decimal places.
However, when I enter a number 6.80, it rounds up to 7.00.
Does anyone have any ideas / suggestions?
Brook

I have a table that has one field set to a number data
type. As part of the values input process, I need to enter
values leading with a zero as the first digit.
Unfortunately, every time we try to enter one of these

I am creating a new table for 225 fields.  I have ~140
entered, but when I try to enter any more fields a
warning pops up and says that the "property value is too
large." I have no idea what this means or how to remedy

We have an Access database that was originally designed
back in Access 2.0 days. It's since been added to and
convert numerous times; today it's an Access 2003 database.
My question has to do with table design and relationships.

I've seen in some websites where you enter your email
address, it validates that the address you've entered is
in a proper format :   name@domain.com  or (in my case)
name@service.domain.us

How can I change the length of a text field programatically?
TIA,
Lou

I'm trying to get my table to show decimal values.
In the table design view, I set "Field Size" to decimal,
and Decimal Places to "4".  However, all the decimal
values I enter still get truncated.  

Please help - I have a simple database with customer
orders and information and I have suddenly come to a dead
end trying to add a new record.
I can add one new record without any problem but when I

I have a table name hardware, with field tag number etc. I want the tag
number starting with 2001, and the new record will be 2002....., which means
it would be automatically filled in with the next number. How can I do this
in design?

I have had a problem with a record "turning into garbage"
so to speak.  I have no idea what or how this happened,
this DB is on a server, but one day the users couldn't
access this specific record.  The record now contains

I am unable to figure out how to fit the wild card character in my
query that is looking at a Pop up box for input. What I do know is
that normally one would use the Like criterion looking as,(Like "C*")
for example.