G
Grub via AccessMonster.com
Hello
I am running a database in Access 2003. It catalogues equipment information
and their problems.
When you click a button on the Switchboard it will go to a form which which
contains the information about the piece of equipment (location, model etc)
searched by a Barcode number(primary Key). This information comes from a
query of a Equipmentlog Table
This form has a subform at the bottom which draws directly from a Comments
Table.(tblComments). Anyone can then enter information about the error
history of the machine, which includes the date and comments, and then click
the save button, which are saved back to the Tblcomments log.
Now my problem.
The Database has always sorted by date ascending somehow, I'm not sure how
it did this. But now occassionally when a date is entered it will now appear
at the top of the subform after it has been saved and form closed out of
(entries are made at the bottom of the subform). Then the next time someone
goes it, some of the new entries are now at the top.
I don't understand how this is ordered?, any suggestions? I feel like I
tried everything to correct it. But I'm unsure how to order it as as far as I
understand I can't set ascending/descending on a table. And can't understand
why it is doing this. I've tried the properties "Order by" date, but it
doesn't seem to work either.
it used to ascend by date naturally and the field of date in the comments
table is set as date/time with "short date" format.
I have made the database without code, and have used wizards & design view
criteria.
Any suggestions that would help me on the right path would be very
appreciated for sanity's sake. Even if I can jam in a string of code
somewhere.
Leighton
I am running a database in Access 2003. It catalogues equipment information
and their problems.
When you click a button on the Switchboard it will go to a form which which
contains the information about the piece of equipment (location, model etc)
searched by a Barcode number(primary Key). This information comes from a
query of a Equipmentlog Table
This form has a subform at the bottom which draws directly from a Comments
Table.(tblComments). Anyone can then enter information about the error
history of the machine, which includes the date and comments, and then click
the save button, which are saved back to the Tblcomments log.
Now my problem.
The Database has always sorted by date ascending somehow, I'm not sure how
it did this. But now occassionally when a date is entered it will now appear
at the top of the subform after it has been saved and form closed out of
(entries are made at the bottom of the subform). Then the next time someone
goes it, some of the new entries are now at the top.
I don't understand how this is ordered?, any suggestions? I feel like I
tried everything to correct it. But I'm unsure how to order it as as far as I
understand I can't set ascending/descending on a table. And can't understand
why it is doing this. I've tried the properties "Order by" date, but it
doesn't seem to work either.
it used to ascend by date naturally and the field of date in the comments
table is set as date/time with "short date" format.
I have made the database without code, and have used wizards & design view
criteria.
Any suggestions that would help me on the right path would be very
appreciated for sanity's sake. Even if I can jam in a string of code
somewhere.
Leighton