Joe, The date order problem is not due to DXB per se, but the way Access works. First make a backup of your mdb file. When your dates in the Previous QSO window get out of order go to the DXBase folder on the Start menu and run the Dxbutility program. In the Dxbutility select Database. Make sure the path name points to your mdb file and click on the Compact button. This action removes old garbage file remnants that Access leaves behind and compacts your database to consume less hard drive space. As an extra bonus, when you now go to the Previous QSO's window you will find the dates and times are correctly sorted in ascending order. I can't explain why Access gets this messed up. Over time it just happens and Compacting the database corrects the problem.
73, Gary AL9A ----- Original Message ----- From: "K0BX" <[email protected]> To: <[email protected]> Sent: July 29, 2010 3:21 PM Subject: [Dxbase] Couple of items for next release > Yesterday I was working on Buro cards. > I use the 'Previous QSOs' page to lookup, confirm and make labels for > the incoming cards. > > The problem I have is the 'Date & Time' column is not sorted by Date & > Time. > There are some of the contest stations that I have worked and have over > 100 qso's with and they seem to QSL every contact. So finding the exact > qso is a sequence search for me through all the qso's. My log go's back > to 1989. > I wonder what the 'order by' for the query that retrieves the list of > previous QSO's? > > The 2nd problem I had was with SWL cards. The Commands within the > Previous QSOs page has a SWL Reply. > This is really nice to have but when I entered several OK SWL station, > OK1-3453, the label generated cut off the '-' and the rest of the > callsign. So I had to go into the labels and manual add the rest of the > callsign. > So either have a data check when I enter the SWL callsign telling me I > can not have the '-' or fix the insert no to remove the '-' and the rest > of the callsign. > > These are both little things and should already be on list. Just would > make life easier. > > Joe K0BX > ______________________________________________________________ > Dxbase mailing list > Home: http://mailman.qth.net/mailman/listinfo/dxbase > Help: http://mailman.qth.net/mmfaq.htm > Post: mailto:[email protected] > > This list hosted by: http://www.qsl.net > Please help support this email list: http://www.qsl.net/donate.html ______________________________________________________________ Dxbase mailing list Home: http://mailman.qth.net/mailman/listinfo/dxbase Help: http://mailman.qth.net/mmfaq.htm Post: mailto:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
