Search results

Please can someone give me a nudge in the right direction on the best way to design this form? I'm moving from a massive spreadsheet to Access & trying to upgrade how I do it as I go, but this is my first go at Access. Several people have already helped with the normalisation of the data etc &...

I assume I'm being an muppet, but cant see where. I have this code ColourBack = DLookup("ItemValue", "BackgroundStoredValues", "[UseID]=1 AND [ItemID]=1") the Public variable ColourBack is stored as a String ItemValue is saved as short text in the table UseID & ItemID are stored as short...

Hi, this seems like a stupid question, but... I'm building my first attempts at a database and when watching videos I've noticed an obvious difference. Where's the rest of the icons on my version? As you can see below, I don't have anywhere near the same number of icons to choose from & we...

Hi, I'm very new to vba in Access but have dabbled in Excel for some time. I'm in Access 2016 (through office 365). I have a large slow spreadsheet over multiple sheets with lots of VBA which we use to manage our jobs & I'm remaking it in access. This section is a main form which will have...