S D
accessd667 at yahoo.com
Fri Apr 2 07:49:46 CST 2004
Yep, that's it....however, like everything in this app...it doesn't work! Sander Bert-Jan Brinkhuis <thevigil at kabelfoon.nl> wrote: Graag gedaan :-) Sander How is the rowsource dynamic? Do you make an sql string dynamically and make that the rowsource? Bert-Jan ----- Original Message ----- From: "S D" To: "Access Developers discussion and problem solving" Sent: Friday, April 02, 2004 10:49 AM Subject: Re: [AccessD] ORDER BY BUG using Date format AARHG > Bedankt :-) Bert > > Only problem is that the user's decided that they want this format for every date in the app. So I started changing stuff like you mentioned...Worked like a charm except 1 form. Here is the Rowsource dynamic. It is determined via a lot of selections. > > I'll have to figure this one out... > > Sander > > Bert-Jan Brinkhuis wrote: > Hi Sander, > > i do not know what kind of nonsense that is, but i have a workaround for > you. > > Add the original unformated [datum] field to your query and order on that > field. > Make sure you do not display that column in the combobox! > > HTH > > Bert-Jan > > ----- Original Message ----- > From: "S D" > To: "accessd" > Sent: Friday, April 02, 2004 9:06 AM > Subject: [AccessD] ORDER BY BUG using Date format AARHG > > > > Hi group, > > > > I've got a combobox based on a query: > > SELECT DISTINCT [TblArbo].[Datum] > > FROM TblArbo > > ORDER BY [TblArbo].[Datum] DESC; > > Resulted in: > > 01-10-2003 > > 02-09-2003 > > 21-08-2001 > > > > The user asked if this could be printed in the following format: > dd-mmm-yyyy > > No problem, says stupid me: > > SELECT DISTINCT Format([TblArbo].[Datum],"dd-mmm-yyyy") > > FROM TblArbo > > ORDER BY Format([TblArbo].[Datum],"dd-mmm-yyyy") DESC; > > > > But now the ORDER BY ONLY checks the DD part?!?!?!?! > > So this results in: > > 21-08-2001 > > > > 02-09-2003 > > 01-10-2003 > > ?!!??! What kind of nonsense is this? > > > > Sander > > > > > > --------------------------------- > > Do you Yahoo!? > > Yahoo! Small Business $15K Web Design Giveaway - Enter today > > -- > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > --------------------------------- > Do you Yahoo!? > Yahoo! Small Business $15K Web Design Giveaway - Enter today > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------- Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway - Enter today