Search results

Please can someone put me out of my misery. This cant be as hard as I'm making it. I've looked at old posts and nothing I've tried from them seems to work, so I'm not understanding something, or I'm looking straight through something. I have a combo box with 1 column in it. But it also pulls...

Sorry, me again. This code was working a few days ago & upon testing it again today it isn't. Yesterdays code was to fill in text boxes for a new record in this same form. So I've broken something, or more likely, I need to be more specific to stop the code going off at a tangent. The code...

I'm still quite new to Access & I've hit what seems to be a formatting issue. I've trawled google but cant find an answer to my exact issue. I'm trying to fill a text box on a form with todays date using this code. Forms!Form0_AddEditJob!TBOX_DateInitial.DefaultValue = Format(Now...

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...