Skullhammer wrote in Collector's Database:Since I don't have Microsoft Access, I couldn't view the data structures. Do you have an Excel "flat file" of your database available? Thanks, MadCat.-Skull
cwfrizzell wrote in Collector's Database:I would be more than happy to provide feedback if you wouldn't mind sending me a copy.Cheers!Chuck
cwfrizzell wrote in Collector's Database:Received. There's a functional issue, potentially on my end, before I can actually get to validating data.Using Access 2013, if I open the AD&D Book Master List form and select a Product Code form the dropdown, it populates the Title list Box (can tell by the change in the vertical scrollbar). However, the values aren't visible. I can copy a row listed in the dropdown, paste it into notepad and see Product Code 2013 pulls up item 587. Any ideas?
MadCatUSA wrote in Collector's Database:cwfrizzell wrote in Collector's Database:Received. There's a functional issue, potentially on my end, before I can actually get to validating data.Using Access 2013, if I open the AD&D Book Master List form and select a Product Code form the dropdown, it populates the Title list Box (can tell by the change in the vertical scrollbar). However, the values aren't visible. I can copy a row listed in the dropdown, paste it into notepad and see Product Code 2013 pulls up item 587. Any ideas?Sounds like the list boxes aren't scrolling to the correct value. Do you see scroll bars on the right side of the boxes? I was having some issues with the list boxes not scrolling properly, but thought I had them worked out (using Access 2010 here at work.) Microsoft may have changed something in Access 2013 that broke the code to scroll the list boxes. If you don't see scroll bars, there may potentially be a larger bug. I tested just now by entering "Dungeon Master" in a title search and everything worked fine for me (again, on my work machine running Access 2010.)
cwfrizzell wrote in Collector's Database:MadCatUSA wrote in Collector's Database:Sounds like the list boxes aren't scrolling to the correct value. Do you see scroll bars on the right side of the boxes? I was having some issues with the list boxes not scrolling properly, but thought I had them worked out (using Access 2010 here at work.) Microsoft may have changed something in Access 2013 that broke the code to scroll the list boxes. If you don't see scroll bars, there may potentially be a larger bug. I tested just now by entering "Dungeon Master" in a title search and everything worked fine for me (again, on my work machine running Access 2010.)I entered "Dungeon Master" in the title search and received an error:Attachment:$matches[2]The database wants me to pick a particular title. In this case, and using your example, it simply highlights the first name in the list starting with "Dungeon Master". Digging around in the Item_Code table, I know Product Code "2011" corresponds with Title "Dungeon Master's Guide", which includes several Item_Codes representing different DM Guide versions. Using this info, I try to search a couple ways.If I simply select "Dungeon Master's Guide" in the Title dropdown, nothing appears in the Title list box:
MadCatUSA wrote in Collector's Database:Sounds like the list boxes aren't scrolling to the correct value. Do you see scroll bars on the right side of the boxes? I was having some issues with the list boxes not scrolling properly, but thought I had them worked out (using Access 2010 here at work.) Microsoft may have changed something in Access 2013 that broke the code to scroll the list boxes. If you don't see scroll bars, there may potentially be a larger bug. I tested just now by entering "Dungeon Master" in a title search and everything worked fine for me (again, on my work machine running Access 2010.)
cwfrizzell wrote in Collector's Database:MadCatUSA wrote in Collector's Database:
MadCatUSA wrote in Collector's Database:
cwfrizzell wrote in Collector's Database:Please take another look at the form screenshot I posted earlier. The form is "AD&D Book Master List." The form, as I have it, does NOT have a "Search By" dropdown, nor does it have a "Enter Search" field or "Search" button.The database you sent me has three forms:AD&D Book Master ListExtract_AuthorTable_ImportUnless the search form you are using is somehow hidden, I don't see it in the database you provided.
HermitFromPluto wrote in Collector's Database:Ah. It's in Access. I use Access to keep track of my own collection. Would be happy to look at it.
