If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display records in date order, form view
I'm very new to Access--self taught using Access Inside Out, Access for
Dummies, and trial and error. Just created a simple database (form and table) for interlibrary loans. My supervisor would like to see the most recent record when she opens the program and click backwards. In form view, I right-clicked on the "borrowed date" field, which uses "Short Date Input Mask" (99/99/0000;0) (mm/dd/yyyy); and chose "sort ascending." Two stumbling blocks: 1. This works for most, but 12/06/2004 comes after 12/02/2005--apparently the sorting is purely numerical. Can that be changed without putting dates in yyyy/mm/dd format? Thanks 2. How can I set it so that it opens to the last record instead of the first? Also, it would be a bonus if we could enter years with two digits (so that they appear as four digits. Our invoice database does that, but this new one (and the other one I created for our catalog) doesn't. |
#2
|
|||
|
|||
Display records in date order, form view
Answered some of my own questions:
1. In Table design view, my date fields were in text format: when I switched them to date format the 12/02/2005, 12/06/2004 problem went away. 2. In forms design view, I clicked the black square at the top left, and under "on open" I chose "add record." Better than opening to the oldest record. Still don't know about the two digit year question, but that's unimportant. "ReadReadWrite" wrote: I'm very new to Access--self taught using Access Inside Out, Access for Dummies, and trial and error. Just created a simple database (form and table) for interlibrary loans. My supervisor would like to see the most recent record when she opens the program and click backwards. In form view, I right-clicked on the "borrowed date" field, which uses "Short Date Input Mask" (99/99/0000;0) (mm/dd/yyyy); and chose "sort ascending." Two stumbling blocks: 1. This works for most, but 12/06/2004 comes after 12/02/2005--apparently the sorting is purely numerical. Can that be changed without putting dates in yyyy/mm/dd format? Thanks 2. How can I set it so that it opens to the last record instead of the first? Also, it would be a bonus if we could enter years with two digits (so that they appear as four digits. Our invoice database does that, but this new one (and the other one I created for our catalog) doesn't. |
#3
|
|||
|
|||
Display records in date order, form view
1. It sounds like your field is DataType - Text instead of DataType -
DateTime. Format is just the display and should not affect sorting. 2. You can add an Event/Macro to the form - On Open property to GoToRecord - New. If you go to LAST it will go to the end of file but may not be the last record entered. "ReadReadWrite" wrote: Answered some of my own questions: 1. In Table design view, my date fields were in text format: when I switched them to date format the 12/02/2005, 12/06/2004 problem went away. 2. In forms design view, I clicked the black square at the top left, and under "on open" I chose "add record." Better than opening to the oldest record. Still don't know about the two digit year question, but that's unimportant. "ReadReadWrite" wrote: I'm very new to Access--self taught using Access Inside Out, Access for Dummies, and trial and error. Just created a simple database (form and table) for interlibrary loans. My supervisor would like to see the most recent record when she opens the program and click backwards. In form view, I right-clicked on the "borrowed date" field, which uses "Short Date Input Mask" (99/99/0000;0) (mm/dd/yyyy); and chose "sort ascending." Two stumbling blocks: 1. This works for most, but 12/06/2004 comes after 12/02/2005--apparently the sorting is purely numerical. Can that be changed without putting dates in yyyy/mm/dd format? Thanks 2. How can I set it so that it opens to the last record instead of the first? Also, it would be a bonus if we could enter years with two digits (so that they appear as four digits. Our invoice database does that, but this new one (and the other one I created for our catalog) doesn't. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
Reports with Date Range - Errors | jwr | Setting Up & Running Reports | 12 | August 8th, 2005 12:57 PM |
Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |
Form records out of order | Jason Kneip | Using Forms | 7 | August 6th, 2004 02:19 PM |