I have a linked table between two databases(A & B). The data is entered by multiple users in to A once all the data is entered I review the data in B and then append that data to my main table in B. I'm essentially using the linked table as a buffer so if there are any entry mistakes they don't go directly into the main table. After the data is appended I would like to view it in the form that is linked to my main table, the problem is when I review the records they are all out of order although they are in order when I directly open the table. I was just wondering if there was an easy fix so when I open the form the most recent record by date appears first. The column/field is DATE I tried using the order by property(Order By: tablename.DATE)but that didn't seem to work. Any suggestions would be helpful.
Additional Info:I have previous and next record navigation buttons in the form. I would have no problem opening the table and looking at the data but I'm not the only person who will be accessing it so I'm just trying to make it as user friendly as possible.
6 2573 Rabbit 12,516
Recognized Expert Moderator MVP
The most likely reason that the order by isn't working is because your date field isn't actually stored as a date but as a text. Convert it to a date before doing the order by.
twinnyfo 3,653
Recognized Expert Moderator Specialist
Alby22,
Are you sure the Order By On Load property is also set to Yes? I have encountered such strange cases where this property is set to yes and still won't order properly. One solution, which I have found sometimes works when Access quirkily does something it shouldn't, is to remove TableName from the Record source completley, then reset the record source to TableName. For some reason it will re-order the data in the form based on the current settings of the table automatically. Again, a strange, quirky thing, but sometimes it works.
Best of luck!
You are right it was a text field I should have checked that but I assumed it was set as a date. Now the problem is that to change it to a date it says that I have to delete the relationship it has with another table then change it and re-establish the relationship. Will changing it to a date have any major effects that you could predict on the data base. There are many other queries that use that filed through queries.
twinnyfo 3,653
Recognized Expert Moderator Specialist
First, good DB practices would prevent you using a date as a primary key or as a relationship within a table. Relationships between tables should typically be based on a Primary key in one table as a foreign key in another.
So, if your date is somehow in a relationship with another table, that should be fixed first.
Then, make sure all your datews are "dates" and not text, and re-establish any relationships between tables properly.
Yeah the database is a mess and it is obvious whoever made it didn't really know what they were doing. Is there a way that I can just convert the text into a date/time in the order by statement? I don't wanna change much because some how it works and I'm afraid if i start changing things its going to bring on more troubles that frankly I don't have the time to deal with.
twinnyfo 3,653
Recognized Expert Moderator Specialist
The place to start is the format of the date to start with. What is the format, so we can work on converting it to a date? After this, just keep in mind that the recordsource for the form will have to be the query you make, and not the table itself., but good chance that all fields (except the date) will still be updateable.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: peterleeds |
last post by:
Could anyone explain why Access 2003 is continuously calculating a
continuous form, when it works perfectly in previous versions?
On reading previous messages I gather that overlapping controls...
|
by: Frank.Sebesta |
last post by:
I have a employees database with a picture that shows on a form with
employee information. Similar to the Northwinds sample database. When I
print the record, my output is only the data and does...
|
by: AA Arens |
last post by:
When I finished whitch the Design View and want to go back to normal
view, the form does not appear. Instead of that the table appears. I
only get the form when I cal it on the Switchboard.
How...
|
by: carmela_wong |
last post by:
Hi all,
I have converted a database from Access 2003 to Access 97. Everything
gets neatly imported into the new database except for one form which
continues to show a fatal error when I try to...
|
by: erainc |
last post by:
Hi There,
I am trying to put a search box on my form in Access 2003. I tried doing it through a combo box, and the search part works, but the rest of the information on the form does not correlate...
| |
by: Marianne160 |
last post by:
Hi,
I would like to update a table based on another one by adding any missing records from one to the other. I can't do this in the update query as this won't add records and I can't see how to...
|
by: Bface |
last post by:
Hi All,
I am stuck on a problem and hope someone can help me out. I have 8 users who will be using a form . For the users to access their accounts I use the SendKeys function, the user click on...
|
by: Greg (codepug |
last post by:
I want to display the last 22 records in my continuous form. I have
writen the following
code and it works, but was wondering if there were any better
suggestions for accomplishing
this. My code...
|
by: eyalco |
last post by:
I have a receipt form (with continuous sub-form) where I need to issue many receipts in 1 form (from 12 to 36).
I need to duplicate the details of each receipt (the only change every time is the...
|
by: greeni91 |
last post by:
I am currently trying to put a find box at the top of a form I have created for reviewing machining methods. I have setup the box to show the Part Number field and take you to that record when...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |