If you're a new or even a longtime user of Realms of Wonder, hopefully you will find answers to questions you may have, as well as tips to make your entire Realms of Wonder experience more efficient and enjoyable (some clearly less informed people may suggest to those of us who "enjoy" entering information about comic books into a computer, that we actually get a life. But, what do they know).
Click here for a fairly detailed explanation of the best way (IMHO) to get your data into Realms
Realms is not affiliated with any publisher, price guide, etc. So, there is no "built in" price guide. There is an absolutely free, separate, stand alone utility available that will update the values in your collection automatically. Contact me for more info on that
It's very important that you understand how to change the "active title" in Realms. Otherwise, the program cannot tell if you are trying to switch titles, or change the title on an existing record. Click here for a detailed write-up on how to switch active titles.
Ok, this is one that`s a little confusing, but not too bad. When you type an entry into a drop down list box, Realms checks to see if it is there already, and if it`s not, Realms adds it as a new entry. It really has no way of telling a "good" entry from a "bad" one.
For example, suppose I was trying to type "Zero Hour" into the Crossover field on the Issue Detail window. I accidentally type "Hero Hour" and don`t notice it until after I leave that field. If I go back and correct it, I will now have both "Zero Hour" and "Hero Hour" on the list. I want to get rid of "Hero Hour" but don`t seem to be able to. Here`s How:
Click the File menu, and select "Build Lookup Files". This option scans you`re entire collection for all values that are actually used by any record, and then updates all the list boxes. In the above example, it would only find "Zero Hour" as being actually entered in the crossover field (assuming you corrected it), so "Hero Hour" would no longer appear in the list since no record actually used "Hero Hour" as a crossover.
If what you consider to be a bad entry still shows up after you run the "Build Lookup Files" option, that means it is being used by at least one record. Use the Find option off of the Summary window to find any issues using that entry. Then correct it, and run the option again.
It`s a good idea, though not necessary, to run this option every once in a while just to clean things up, but it may take a few minutes, based on the size of your collection.
Note: The Creative Team entries work differently - see the next question.
I'm sure everybody incorrectly types in creative team members and/or appearances from time to time. You can't directly delete entries from the drop down list, so how do you get rid of them?
Basically, you have to correct the incorrect entries on the records containing them.
Ok, so the next obvious question is how do you find which records have the incorrect entries. You actually have 2 options.
As an example, let's assume you discovered that "Garth Ennis" is in the drop down list for writers as "Garth Enis".
Option1: Using the Find option on the Summary window
Bring up the Summary window. Click the Find button. In the Creative Team field (or Appearances field), type in the incorrect entry surrounded by an asterisk on each side. In our example, you would enter *Garth Enis* in the Creative Team field of the Find window, off the Summary window.
Click the Find (and) button. The Summary window will then list all the issues that have "Garth Enis" somewhere within the creative team. Click on each row, then right mouse click, then choose Creative Team from the pop-up menu. When the Creative Team window appears, you will see the incorrect entry. Fix it.
Once they are all done, the next time you bring up the Creative Team window, the bad entry should be gone.
This process works, but can be pretty tedious if their are a lot of records to fix.
Option 2: Using the Batch Edit window
This is the preferred method. From the Summary window, click the Batch Edit button. On the Batch Edit window, select "Creative Team Member" from the Select Column drop down list box.
Then, click "Garth Enis" (the incorrect entry) from the Current Value list box.
Then, type in "Garth Ennis" into the Change To field. Then click the Replace Data button.
Realms will replace all the incorrect entries with the corrected ones.
An important word of warning: Be very careful with the Batch Edit process. It will do what you tell it to do, so if you tell it to replace the wrong data, it will (I think someone once said "With great power comes great responsibility").
I always advise making a backup of your data before using the Batch Edit function.
Fixing Appearances errors using Batch Edit works exactly the same way.
For example, suppose I just purchased the first 20 issues of "The Sandman", and prior to that I had none, and therefore had no records for this title entered in Realms. I will have to type in all the data for the first issue (after entering the title in the Title Maintenance window, of course). It's a good idea to enter the oldest issues first.
Once I've entered and saved that record (Issue #1, in our example), all I have to do for the next issue is click the "Dup" button, which will copy all the information (that I thought made sense to copy) from Issue #1, and create a new record for issue #2 (yes, it will automatically increment the issue number and date). Then, go ahead and edit any fields that should be changed or are not copied over (like Location, which I assumed would change - I'm not sure if that's a good assumption or not). In many cases, you can enter an entire issue with only a couple of keystrokes.
I use the duplicate feature more than any other in Realms, by far.
The next time saver is to set the Default Purchase and/or Value Effective dates on either the Comic Detail or Collection Summary List window.
Click the appropriate menu option, either "Comic Details", or "Summary List", depending which window you're on. Then select the "Set Default Dates" option. This will bring up the Default Dates window. Enter the default purchase date and/or the default value effective date.
For example, I pick up my comics every Thursday, so when I enter that weeks comics, I set the default purchase date equal to Thursday's date, and the default value effective date equal to the issue date of the latest issue of Wizard, which is the price guide I use. Now, whenever Realms creates a new record or copies an existing one, it will use the default values.
Each month I would update the values of my collection using the latest issue of Wizard, or whatever price guide you choose. You can use any price guide you wish. Most, Wizard included, highlight the issues that have changed in value (Wizard uses color coding), so it's very easy to identify which records need to be changed.
I find it easiest to update the values from the Summary List window. First thing I do is set the default value effective date (see question 3) to the issue date of the current Wizard issue.
Then, title by title, using the Find Issues window (click the "Find" button on the Summary List window to bring it up), I select all the issues I own for each title. For example, I know that I have some issues of Amazing Adventures of Spiderman in my collection. I scan Wizard and see that some of the AAS issues have changed in value (if none have, I can skip this title and go to the next one). So I click the "Find" button, and enter "Amazing*" in the Comic Title field of the Find Issues window. Then I click the "Find (And)" button (or press the "Enter" key). This will bring up all the issues I own that begin with the word "Amazing". Just a note: the Find Issues window remains visible, so just slide it out of the way, which is faster than constantly loading and unloading it.
Now, I check Wizard and see that issues 299, 300 and 315 have increased in value. Assuming I have those issues in the list, I simply find them, scroll right until I find the "Current Value" column, and enter the new value in the appropriate cell. I can either click the "Save" button , or move to another row to save the changes. All the related value fields will be updated automatically. Because I set the default effective date earlier, that field will also be updated properly. So, by entering just one field on each row, I update all the necessary fields. Then, after updating each of the rows whose value has changed, I move on to the next title. I can usually update my entire collection in about 20 minutes.
The other option is to take advantage of a absoluely free, stand alone utility that will update the values automatically for you. Contact me if you have questions about this option.
Anyway, Access databases (and DBase databases, and I'm sure others) can be corrupted. Every case I know of is caused by the computer being turned off or rebooted while the application using the database (Realms of Wonder in this case) is still running.
Important rule #1: Don't shut off your machine without properly exiting Windows.
I realize at times (like when your machine locks up) there is nothing you can do about it, but try to avoid it at all costs. Now, here's the deal to fix it.
If you can open Realms and choose another collection file, or get by any error messages, you can choose Repair Database from the Utilities menu. That should fix it.
If you can't get into Realms because the file is corrupt and it won't let you go any further, you can download a utility here that will repair the database.
If you have further questions you would like to see addressed here, please let me know (E-Mail me here), and I'll add it to this page.
The Value update uses several criteria to "match" to the appropriate record.
First, the titles must be linked via the Match window.
Second, the VALUE EFFECTIVE DATE on the record must be LESS THAN THE PRICE GUIDE DATE on the update database. That's usually the one that people miss.
<< Thanks that did the trick for me. Is there a way to have ROW skip a particular
issue when it is updating? (i.e. Gen13 #1, 2nd series There are multiple covers and it
seems the value program prompts you on every one). >>
A couple of options here.
First, Realms only updates the issues in the list. So, you can use the Find button, to restrict the list to anything you want.
Second, if you turn the "Upd Non-Numeric Issue #sThat match" checkbox on, on the Options window, it will only update the non-numeric issues where the issue numbers actually match each other. Otherwise, Realms propmpts you for any issues where the numeric part of the issue number matches.
Then, after you do that, select the "Show Issues Not Yet Updated" and the "Show non-numeric issues only" options and turn off the option above, and run it again. That should get any others where the issue number doesn't match. You will be prompted in those cases, but it should reduce the number of "repeat" prompts.
<< I have had this problem a couple of time in the last few days, but I was able
to get around it by deleting the title then re-entering it, and that worked fine. But this
won't work now. Any idea what is wrong? >>
You simply have the filter option set to something that is excluding these titles. My guess is you have it set to include active titles only, and these titles all have tha active indicator tirned off. Or, you are restricting it to only certain publishers. Make sure to select them all if that is what you want. Click the filter button on the detail window (right next to the title), and set it to include all titles (which is the default).
<< I am wondering if I can create a list of comics I have entered into Realms
That I have not added a picture for, so I know what issues I need to scan or look for on
the net. >>
The easiest way is to go to the summary window. Click Find. Scroll down until you see the "Primary Image" field. Enter the word "blank" (no quotes) in that field, and then click "Find (and)". That will bring up all the issues with no image associated in the Summary window.
Then move or hide any columns you want (save this as a view if you plan to reuse). Then, right now, export the data. I have a fix for the print button, but it's in the version I am currently working on, so the print button doesn't work on your version.
But, if you export to an htm file, and then open it in just about anything (your browser, Word, Excel, etc.), you can print from there.