Search found 204 matches

by DougWilliams
Wed Aug 16, 2017 11:37 pm
Forum: Using CATraxx
Topic: sql-Question
Replies: 4
Views: 39

Re: sql-Question

Hi Cally, While it's likely a sql query could do what you're asking, I'm wondering if a custom Track View for the Copy Track Data be a better idea. The problem I have with the sql query is there could be unexpected variances. The song title "Heaven" has many artists. How would you determin...
by DougWilliams
Tue Aug 15, 2017 10:25 pm
Forum: Alternatives to the CAT programs
Topic: MediaMonkey alternative to CATraxx?
Replies: 2
Views: 26

Re: MediaMonkey alternative to CATraxx?

As an alternative to CATraxx, it fails. MediaMonkey requires audio files. Unless you digitize your LPs, cassettes, reel-to-reels 8-tracks, etc, it couldn't manage them. The website says you can do CDs, but reading other parts give indication that you have to rip the CD before MediaMonkey can truly c...
by DougWilliams
Tue Aug 15, 2017 4:22 pm
Forum: Using CATraxx
Topic: CATraxx random capabilities
Replies: 2
Views: 30

Re: CATraxx random capabilities

Hi Salvatore
Welcome to the forum!

I created a playlist that is random but also looks at the "Days Last Played". If it's less then a year, don't play it (my collection is a bit larger than yours).
You could have it so it looks for those longer then 7 days.
by DougWilliams
Sat Jun 10, 2017 6:02 pm
Forum: Using StampCAT
Topic: StampCAT
Replies: 2
Views: 94

Re: StampCAT

Hi Allen, Sorry I cannot help. We are just fans of the "CAT" programs that believe they are still a versatile cataloging software. Any updates are provided by the original programmer (Fredrik) and, while no longer expected, are much appreciated when they do occur. My only suggestion is to ...
by DougWilliams
Sat Jun 10, 2017 5:49 pm
Forum: Using CATVids
Topic: "Protocol HTTPS not implemented" error
Replies: 0
Views: 51

"Protocol HTTPS not implemented" error

This question was sent to me via an email. ----------------------------- I'm trying to find out if anyone knows how to solve the "protocol HTTPS" not implemented error in CatVids 7.23. I'm using the latest queryinternet.dll file and this function worked fine 2 months ago, but some recent w...
by DougWilliams
Mon May 15, 2017 10:19 am
Forum: Using BookCAT
Topic: Last issue with title
Replies: 20
Views: 529

Re: Last issue with title

I am not at a computer where I can test it, but try this.

Code: Select all

SELECT Series.SeriesID, Series.Series, Max(Book.ReleaseNo) AS MaxOfReleaseNo, Book.Title
FROM Book INNER JOIN Series ON Book.SeriesID=Series.SeriesID
GROUP BY Series.SeriesID, Series.Series, Book.Title;
by DougWilliams
Sat May 13, 2017 6:04 pm
Forum: Using BookCAT
Topic: Last issue with title
Replies: 20
Views: 529

Re: Last issue with title

With MS Access, open the MDB and right click on the query. Select Design View. Then VIEW > SQL VIEW and update the code with the provided code. Remember to BACKUP first!! :)
Capture.JPG
Capture.JPG (92.31 KiB) Viewed 201 times
by DougWilliams
Sat May 13, 2017 5:38 pm
Forum: Using BookCAT
Topic: Last issue with title
Replies: 20
Views: 529

Re: Last issue with title

Try list for the "LastInSeries" query. SELECT DISTINCTROW FirstQuery.SeriesID, Series.Series, Max(Book.ReleaseNo) AS Max_Of_ReleaseNo, Book.PublishDate, Book.Title FROM (Book INNER JOIN Series ON Book.SeriesID = Series.SeriesID) INNER JOIN FirstQuery ON (Book.ReleaseNo = FirstQuery.MaxOfRe...
by DougWilliams
Fri Apr 28, 2017 1:31 am
Forum: Explorer Templates
Topic: CATraxx - Explorer Templates with Chart info
Replies: 6
Views: 780

Re: CATraxx - Explorer Templates with Chart info

Okay, I've got my ideas... The MusicChart.xsl would display the selected chart data set. Billboard Year End Top Pop Albums (my year end data doesn't have a "weeks" value entered but if it was there is would display) Status - Year - Peak - Weeks - Format - Artist - Title Own - 1987 - 1 - - ...
by DougWilliams
Thu Apr 13, 2017 1:01 am
Forum: Windows 10
Topic: Report printing error
Replies: 2
Views: 153

Re: Report printing error

I love Catraxx
Me too!
Was this an inplace Windows 10 upgrade or a new PC with Windows 10?
Have you tried re-installing CATraxx after installing Office 2016?

Go to advanced search