Search results

Hi All, I have a check box labelled "Show Retired" which when ticked, I want it to show assets labelled "Retired" and when it's unchecked, to hide them. I cannot quite figure out how this is done however. This is what I've done so far: Private Sub chkShowRetired_Click() If...

Unfortunately not... Our assets are for example LT1001, DT2202, R419, ES404 etc which means that it would be a little harder than I expected.

How would I be able to use that with something like this? If I can refrain from needing to make duplicates it's a win-win as creating an enum would mean I would have to type each option essentially twice.

Hi all, I'm really sorry about this but I've updated OP which should make things a little clearer.

Hi All, In other languages, it's easier and better to be able to use named identifiers instead of their ID's, for example, in Java, you have an Enum: public enum AssetType { Desktop = 0, Laptop = 1, MobilePhone = 2, ... }; How would I achieve this with a Lookup table within...

Hi All, (Thanks for the welcome @The_Doc_Man) what @Uncle Gizmo has suggested has seemed to fix the issue I've had wherein I needed to delete all indexes except (as I could not actually delete it) ID. Not sure what this would do? I've had a look at the definition for my ID and it is definitely...

Hi All, I'm trying to add new entries into my table but I cannot add more than two and then access throws the following error: Run-time error '3022': The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or...