Search results

So in my main database I combined both your techniques: Added Private Sub Form_Current() Me.NavMenu = Me.NavMenu.ItemData(AIN) End Sub and Private Sub AlphaTab1_Click() LocateRecord (Screen.ActiveControl.Caption) End Sub Private Sub AlphaTab2_Click() LocateRecord...

As it is, since I'm the only one that plays with this database and its code, I don't have any qualms about copying/pasting new If/End If lines to add a new Publisher. But that is a good idea- I'm trying to adapt my Anime/Media database to a Mass Market Paperback database, and there are many...

I used your LocateRecord change too: Private Sub AlphaTab23_Click() LocateRecord (Screen.ActiveControl.Caption) End Sub Private Sub AlphaTab24_Click() LocateRecord (Screen.ActiveControl.Caption) End Sub Private Sub AlphaTab25_Click() LocateRecord (Screen.ActiveControl.Caption) End...

That's the one thing I built into the database that makes the database gods' teeth itch- the means to keep the indexed AIN field from going out of sequence. The "Insert After" button (top left, next to the NavMenu ComboBox icon) does it... select a record where you want to insert a new record...

Thank you both - I really appreciate for your efforts (and your patience with me). I commented out the Private Sub Form_Load() section in the original database, and replaced all [NavMenu] = [AIN] lines with Me.NavMenu = Me.NavMenu.ItemData(AIN), and it worked- no rounding of the...

Thank you. I do appreciate your efforts, but I have more questions than answers now. 1) My question still isn't answered. What causes the rounding issue? 2) I know what this does because I either wrote it or found it on the web and used it because it did whatever I wanted it to do: I have...

Yes upper left. and I don't understand what you mean "your method." I changed the code to what you described. Oh and for some reason, now the rounding issue appears no matter what I do- upon first opening the database, the first time I open the ComboBox, the record highlighted has an AIN value...

If I'm reading your question right, the Text Box named AC is where you input the character for the [AAC] field. Looking at the above screenshot, you reminded me of another record selection method I incorporated into this form that I don't use too often... Probably because the [AIN] number is...

Yes it's been working since before I posted the first comment... I only wanted to find out what this rounding thing is all about and why does opening and closing the ComboBox solve the problem. Like I said, it seems like a very specific quirk that only manifests itself If I don't open and close...

What you're seeing is part of the reason for including the bar codes in each record... I have multiple versions of the same titles, sometimes by different publishers and sometimes because I bought two of the same title because I want one that's unopened and another to actually open and watch...

[AIN] stands for "Arbitrary Index Number". It's an Indexed and Required field, but I don't make it increment automatically when a new record is created. When I want to create a new record, I select the record I want to create a new field after then click the "Insert After" button, which is...

So I commented out the code too... Save it, then close the database and re-open it (From the Access Objects, it's the "Anime Input Form"). When I click a tab, say N... The record with [AIN] = 1285 and [Disc Title] = "Nabari No Ou: Complete Series, Part 1" is displayed. But when I click...

Ah I see.... etc, etc, etc... But now clicking a button doesn't actually do anything. How does the button know recognize which character (# or A-Z) it's supposed to act upon? EDIT - Oh I see you added the appropriate character to this:

@Gasman @The_Doc_Man - I manually edited the DVD and Blu Rays table so 1) all titles use the same CoverImage File , 2) all titles use the same International EAN bar code (1234567890128) and EAN bar code file ("1 234567 890128.png") and 3) if the title is part of a boxed set, it uses a US UPC...

@Gasman - Zipping it up and including it here as an attachment might be a little problematic with over 2100 .png images of each DVD or Blu Ray disc/box cover and 2200 .png bar codes (file size of "Anime_List.zip" = 1.67Gb). I'll test how badly it errors out if I don't include them as soon as I...

The Solution? So bit of trial and error over a few sleepless nights led to an interesting discovery- Upon launching Access and opening the database, if I merely click the ComboBox to open it, then click it again (or click off of it for it to "Lose Focus") to close it, I can now click any tab...

The Puzzle. As I said above, I purchased "Hero Tales Part 1” and “Hero Tales Part 2" (note the "Preordered" and "Arriving" buttons at the bottom of the form). I fire up Access and open the database... I click the H and see [AIN] = 926 and [Disc Title] = "Haibane Renmei - New Feathers": I...

Hi folks. I'm at a bit of a loss as to the reason why this is happening. I can circumvent it but the symptom is so oddly specific I can't believe it wasn't incorporated into the Access or Visual Basic with a specific purpose in mind. This is also a long one so I'm splitting up my explanation...