Search results

Hi Guys I'm trying to use this code snippet to use the excell median function to work out the Median value from a number of feilds in a record [CODE] Sub xlMedian() Dim obj As Excel.Application Set obj = CreateObject("Excel.Application") MsgBox obj.Application.Median(1, 2, 5, 8, 12, 13)...

Hello everyone Here’s a good one The operative at my place of work produce a product that they have to measure every 25m for QC reasons, and then, the information they generate, I want to store in a database. I have no problem creating the database except for one thing. I need to calculate a...

Is it possible to disable the dialogue box warnings you get when you run an update query I’d like to be able to update tables without the end user having to OK the changes or even know that an update has occurred? :rolleyes:

I have a created a very simple application that I want to use to track how often I have to remind employees to ware their PPE. So I have a two table database. One table for the employee names and their status, status being the number of times I’ve had to remind them about their PPE in the last...

Hi everyone my names John and I'm from the UK. I'm an intermediate level Access user (I think) but want to learn more about Macros and VBA I'm also new to this kind of Forum, so please be patient with me