Steven L. Dasinger

Understood. Just suggesting a work-around for now.

While waiting for that, you can type that sort in the Order By once, Save it, then Load it to start and Advanced Find with that as a beginning.

After the current update, I have both of those issues you listed as missing. PS I just check a database not yet updated and it also has both of the issues. You can try checking Atomic Avenue and see if they are listed there if you think they are missing.

Delete or Move 6.jpg From: Pictures\M\Marvel\S\Space Worlds To: Pictures\A\Atlas\Space Worlds Delete or Move FCBD 2010.jpg From: Pictures\R\Red 5\Atomic Robo-Neozoic-Box To: Pictures\R\Red 5\Atomic Robo-Neozoic-Box 13 Delete or Move 1.jpg From: Pictures\I\Idea + Design Works\Nick Fury Agent of S.H.I.E.L.D.- Artisan Edition (Steranko...) To: Pictures\I\Idea + Design Works\Nick Fury Agent of S.H.I.E.L.D.- Artisan Edition (Steranko's-) Delete or Move 1.jpg From: Pictures\M\Marvel\S\Silver Surfer- Rebirth To: Pictures\M\Marvel\S\Silver Surfer Rebirth Delete or Move MMPB-6.jpg From: Pictures\D\Del Rey\Star Wars (Del Rey) To: Pictures\D\Del Rey\Star Wars- From the Adventures of Luke Skywalker (Note: If you have a MMPB with a blue Star Wars logo and a Yellow diagonal strip on the cover, it is NOT a 1st printing and should be deleted (it is at least a 6th printing when this yellow strip with the text 'The Year's best Movie!' - Time Magazine' on it.))

I am getting the same error when I select the Simplistic theme. Error in the Theme file: Arithmetic operation resulted in an overflow of value cellbackcolor.

It depends on the 'pack'. For #56, that is Yes. One a story from "Star Wars: Visionaries" and the other from "Star Wars Tales". Others could reprint the whole comic book story.

Correct. I like functions and was glad you posted about it. I was just writing something up on that... While the Year component may not be as efficient, it can be used for Month, Day of Month, and (possibly) Day of Week. For example If you want all items put out in a particular Month (January in the example): strftime('%m', I.CoverDate) = '01' You can also constrain it to a Year range (Month January between 2010 and 2019): strftime('%m', I.CoverDate) = '01' and I.CoverDate Between '2010-01-01' and '2019-01-01' The Day of Month and Day of Week are probably most useful for Street Date as Cover Dates normally have Day of 1 (with bi-monthly or weekly being some exceptions) Not sure if they are useful or not but if you need them: All items with a Day of '15': strftime('%d', I.StreetDate) = '15' All items that came out on a Wednesday (Sunday = 0, Saturday = 6): strftime('%w', I.StreetDate) = '3' NOTE: the % value is case-sensitive. %m works. %M does not.

While strftime('%Y',I.[CoverDate]) = '2022' does work, using: I.CoverDate BETWEEN '2022-01-01' AND '2022-12-31' is easier to remember and more efficient. Query with function strftime takes 23 seconds to process while Between takes 1.75 seconds. (Ran each query several times and got the same results each time. For those interested, the reason is the function has to be applied to every row before the comparison is made. The Between just has to compare.) PS In case someone hasn't found it, there is an Advanced Find Guide/Manual (work in progress) for those who need a little more information about Advance Find.

Delete or Move 1.jpg From: Pictures\P\Peachtr\Disney Mickey Mouse To: Pictures\P\Peachtree Playthings\Disney Mickey Mouse Delete or Move ALL (1.jpg - 699.jpg) From: Pictures\W\W.G\Walt Disney's Giant (G Series) To: Pictures\W\W.G. Publications\Walt Disney's Giant (G Series) Delete or Move 1.jpg From: Pictures\M\Marvel\C\Captain America- The Great Gold Steal To: Pictures\P\Pocket\Captain America- The Great Gold Steal Delete or Move ALL (MMPB 1.jpg - MMPB 11.jpg) From: Pictures\M\Marvel\M\Marvel Comics Novel (Pocket) To: Pictures\P\Pocket\Marvel Comics Novel (Pocket) Delete or Move HC.jpg From: Pictures\M\Marvel\G\Guardians of the Galaxy- Collect Them All To: Pictures\M\Marvel\G\Guardians of the Galaxy- Collect Them All Prose Novel (NOTE: The 'To' Title has incorrect Item # of TPB. I have notified the editors about this and it should be changed with the next update.) Delete 1.jpg From: Pictures\I\Image\S\Spawn- Scorched Also, these covers need to be swapped: Rename HC 1-A-4.jpg to HC 2-A-3.jpg Rename HC 2-A-3.jpg to HC 1-A-4.jpg From: Pictures\D\Del Rey\Belgariad, The (Del Rey)

I don't think it is in CB yet. Attached is the indicia. If it can't be read it is: Star Wars Comic Pack #56: Star Wars Visionaries "Old Wounds," Star Wars Tales "Marked," November 2008. Published by Dark Horse Comics, Inc... I also found this information: This story is reprinted in Star Wars Comic Pack #56 which came in a 2010 Sandiego Comic-Con exclusive boxed set with a Darth Maul and Owen Lars action figure. It appears there are a whole set of these. A Star Wars comic reprint of one sort or another along with 2 action figures. http://www.rebelscum.com/darkhorse_hasbro2packs.asp has some information about these. I think this should be a new Title "Star Wars Comic Pack". These were put out by Hasbro with a Star Wars Comic (most if not all by Dark Horse).

You can open Notepad and scan into that to see the numbers the scanner outputs.

Not sure what you are asking. If you have a barcode and you want to see that it is, you can open Notepad and scan it in to that. You should see the numbers that decodes for the bar code.

In my CB 2022 database, the Marked check mark does show up in the grid. Not sure why you are not seeing it. What Theme settings are you using (in case there is a problem with one of them)? Is this a problem for all types (Comic Books, Books, and Magazines)? Can you include a screen print of what you are seeing? PS Here is what I see (with issues 1 and 3 Marked:

Not a bad question but it is fairly easy. First, Rename the *.jpg cover scan to the same as the Item #. The only thing to keep in mind is replace any slash ( / ) with a dash ( - ). (because Windows won't allow a slash in a file name. Some examples: Item # Filename 1 1.jpg 1/A 1-A.jpg HC 1/A-2 HC 1-A-2 After that, drag and drop it anywhere in the 'grid' area (where the data is). (If you have multiple covers for the same title, you can drag/drop them all at one time.)

The best way is to add them to CB, then select the Issue ( s ), right-click and select Submit New or Corrected data from the pop-up menu. If you have a larger scan, it will ask if you want to send it, also. However, if you have a replacement scan (replacing an incorrect one) and it won't ask you to send it, you can post it here with an explanation. Or, you can send it to Support with an explanation.

Look at 'Wizard World Chicago Convention Program' or 'Baltimore Comic-Con Program' to see an example of what you could do.

Can you supply a little more information (and maybe a cover scan or link to it somewhere)? I think, this Title is Cherry by Kitchen Sink. But it has a convoluted history. Issues #1-2, with a Title of Cherry Poptart, was published by Last Gasp. Issues #3-19, with a Title of Cherry, were published by Kitchen Sink Issues #20-23 were published by Cherry Comics. However, Cherry Comics also appears to have reprinted the earlier issues with the Cherry Comics Logo. If all this is correct, I am not sure if Cherry as printed by Cherry Comics deserves its own Title or to keep every thing in the Kitchen Sink Cherry title with a Note on Publication change and the various reprints. Either way, based on the logos on the covers, some clean-up work looks like it is needed.

Delete or Rename 4-C.jpg to 1-C.jpg then Move From: Pictures\Z\Zenescope\Myths & Legends Quarterly- Dragon Clan To: Pictures\Z\Zenescope\Grimm Fairy Tales Myths & Legends Quarterly- Dragon Clan Delete or Rename 2-A.jpg to 1-A.jpg then Move From: Pictures\Z\Zenescope\Myths & Legends Quarterly- Gretel To: Pictures\Z\Zenescope\Grimm Fairy Tales Myths & Legends Quarterly- Gretel Witch Hunter Delete or Move 1-A.jpg and 1-C.jpg From: Pictures\Z\Zenescope\Myths and Legends Quarterly- Dark Princess To: Pictures\Z\Zenescope\Grimm Fairy Tales Myths & Legends Quarterly- Dark Princess Delete or Move 1.jpg From: Pictures\S\Storm King\Night Terrors- Graveyard Moon (John Carpenter'-) To: Pictures\S\Storm King\Night Terrors- Graveyard Moon (John Carpenter's-) Delete or Move 1.jpg From: Pictures\S\Storm King\Night Terrors- Second Nature (John Carpenter's- ) To: Pictures\S\Storm King\Night Terrors- Second Nature (John Carpenter's-) Delete or Move 1.jpg From: Pictures\T\Tokyopop\Secretary Love To: Pictures\B\BLU\Secretary's Love

Here are a couple of thoughts. They may or may not help depending on what and how many you are processing. I am looking at the Price Labels report. I am assuming you have one Issue with a Qty 10 (as an example). One thing you can do is duplicate the issue and have (up to) 10 individual issues instead of 1. Then, when you process labels, you can select the Title and only the issues you want labels for and not the others. Another possibility, if you are not selling all of your comics, is to create 2 databases. One for your collection and for for sales. In the Sales database, you can just list the 2 or 3 issues you want to sell (if you want to print all labels at this point, you don't have to duplicate the issue but you can if it helps). As for the Price, you can change the Price in CB. There is an option to Lock Price so CB doesn't change it (although some have reported that it could still get changed under certain circumstances).

Douglas did a great job explaining the process. The only thing I will add is Quick Change will replace the entire contents (important for any Text filed (i.e. Notes, Item Description, various creator fields)). Additionally, 2022 has added Edit->Find and Replace for Text fields. This WILL allow you to replace specific parts of the text fields without replacing the entire contents.

The different size text for are normal (see attached). For lack of any better idea, maybe try changing Theme. Don't think this will help but it can't hurt. You will probably need to contact support and see if they can remote to your computer. There is probably some windows setting (or lack of something) causing the problem since it is in the program itself (otherwise we would all be having the problem).

Delete or Move ALL (1.jpg - 40-A.jpg) From: Pictures\A\American Mythology\Beyond the Farthest Star To: Pictures\A\American Mythology\Beyond the Farthest Star- Warriors of Zandar Delete or Move ALL (1-A.jpg - 1-D.jpg) From: Pictures\Z\Zenescope\Myths & Legends Quarterly- Aries To: Pictures\Z\Zenescope\Grimm Fairy Tales Myths & Legends Quarterly- Ares Delete or Move ALL (HC 1.jpg - TPB 2.jpg) From: Pictures\#\1987-1990\Encyclopedia of the Worlds of Doctor Who To: Pictures\P\Piccadilly\Encyclopedia of the Worlds of Doctor Who Delete or Move 330.jpg From: Pictures\S\Sunrise Publications\Gameinformer To: Pictures\F\Funco\Game Informer Magazine, The Rename 1-2.jpg to 1-PR-2.jpg & 1-3.jpg to 1-PR-3.jpg From: Pictures\D\DC\B\Batman Adventures, The- Mad Love Delete or Rename 2.jpg to 2-B.jpg From: Pictures\F\Funk-O-Tron\Double Take Delete 5-A.jpg From: Pictures\Z\Zenescope\Myths & Legends Quarterly- Dragon Clan (it if for a Title not in CB, yet)

Just curious. What happens if you resize the Add by Barcode window (making it larger)?

I believe the only way is to Export information from one database and Import into the other. I would just select Issues you own. After you Export data, you can edit the file (Notepad works fine) and compare it with the database you are about to import into. This will let you remove lines where they are in both (so you don't get duplicate entries). Also, if you have Books and/or Magazines in addition to Comic Books, you will need to do an Export/Import for each of the Types you have. PS Make sure both databases have be update to the same weekly Update time.

No, you are not missing anything. First, the Custom Check names should change in the Title Information window after you change it. I will mention this to HC and see if this can be fixed. As for using Title information in Advanced Find, there currently is no way to select Title fileds from a drop-down box. There is only Issue fields. However, as an unsupported function, you can use Title fields. (I have updated the Advanced Find manual in 'News & General Discussion' to reflect this) You do this by using the Table name instead of the I (which is for Issue Table). For example, using an Issue field it would look like: I.Notes For a Title field use either ComicTitles, BookTitles, or MagazineTitles, depending on the Type you are searching, like this: ComicTitles.Publisher = 'Marvel' BookTitles.Publisher = 'Ballantine' MagazineTitles.Publisher = 'Time' ComicTitles.[CustomCheck1] IS TRUE BookTitles.[CustomCheck1] IS TRUE MagazineTitles.[CustomCheck1] IS TRUE This is not supported by HC and I haven't tested it on all Title fields. As for Reports, you can't use Title fields if you used menu item Reports->[type_of_report] but you can run a report on the result of a Find. Run the Advanced Find to get a result. Select some or all of the issues. Right-Click and from the pop-up menu, select either 'Quick Report' or 'Report Selected Titles As...' then either 'Collection Report', 'Item Checklists', or 'Price List'. (I couldn't get the 'Collection Overview' or 'Wanted List' to work.)