Date/time entries not saveing to Table correctly

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

Guest

Yet another problem with my first data base. I have a data entry form that
is linked to a Table. In the data entry form to make it easier to enter on,
I attempted to set it up so that when entering the date as 02102005 it would
fill in as 2/10/2005 and if I typed in another feild 345 it would fill in
3:45. This was successful on my form...it worked correctly. However in my
database (table) the date is saved as something crazy like 10/25/1785 and the
time is saved as a date more like the same 10/15/1657. I am not sure why the
data is is going in correctly on the form and datsheet veiw but not the table.
 
What is the data type of the field in the table? How are you changing the
appearance of the data you enter, are you using an Input Mask or VBA? Using
an Input Mask should do what you're wanting.
 
Veronica said:
Yet another problem with my first data base. I have a data entry form that
is linked to a Table. In the data entry form to make it easier to enter on,
I attempted to set it up so that when entering the date as 02102005 it would
fill in as 2/10/2005 and if I typed in another feild 345 it would fill in
3:45. This was successful on my form...it worked correctly. However in my
database (table) the date is saved as something crazy like 10/25/1785 and the
time is saved as a date more like the same 10/15/1657. I am not sure why the
data is is going in correctly on the form and datsheet veiw but not the table.
Click to expand...


You must be using some VBA code to munge the value into a
real date. The error is probably in that code. If you'll
post it, someone should be able to point out the problem.
 
Hi Wayne,

On my table the data type for each of the cells (date) (time) are both set
at Date/Time. On my form in properties for control source I have Date Taken
which is the name of the column on the table and the format is set at
00\/00\/0000 I origanlly put it in as 00/00/0000, it reformatted itself
after. This did get me what I wanted on the form but not on the table.
There is nothing in the "Input Mask". Thanks for your continued
help...Veronica
 
Try removing the Format. It should be Short Date for what you're trying to
do, not what you have. Also, instead of the format, try an Input Mask in the
control on the form. If you click the ... button on the right side of Input
Mask, you'll get a wizard that will generate the mask you want. It should
look something like:

99/99/0000;0;_
 
Hi again Wayne,

Thanks, I tryed it the way you instructed, everything worked. The only
thing is when I clicked on "Input Mask" no wizard came up nor did it offer a
list of any sort. I typed in what you had suggested and it worked. Now I am
left with the Q. why doesn't the wizard work??? The combo box wizard doesn't
work on the form either, I again had to make it work manually with a great
deal of help from this site. If you could shed some light on that it would
be great "but" more importantly in regards to the same formatting issue only
this time with the "time" feild. I chose med. time and typed 99:99 in the
input mask. this worked "but" it automatically entered "AM" what is the
clock set on and why would is put in AM instead of PM.

Thanks for your additional help...Veronica
 
When you click in the Input Mask box, there a button should appear to the
right side of the box. The button's label says "...". Click this to get the
wizard.

The combo box wizard should work if you click the Wizard button on the tool
bar before creating the combo box on the form.

The Input Mask for Medium Time should look like:

99:00 >LL;0;_

The user will need to enter AM or PM.
 
Back
Top