[Dxbase] Couple of items for next release

[Gary AL9A]

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" <k0bx at arrl.net>
To: <DXbase at mailman.qth.net>
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:Dxbase at mailman.qth.net
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html