Search results

O' hang on there does the variable pfield refer to a single field from multiple records? what I need to do is modify this so that it takes multiple fields in a single record forgive me my programming skills arent good enough to work it out regards John

Thanks jdraw I'll give it a go Best regards John

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

Hi the SQL call is what Im doing this code is just what I need thanks for the help:)

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

Thanks Guys I like the little code snippet, didn't no you could do that Ill use that one all a lot Regards

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:

Thats it:D Thanks so much CJ You've inspired me to take a Better look at SQL Kind regards John

Hi CJ Thanks so much for the sample I've tried it out and it works fine, or that is it did at first I tried adding more incidents and it worked fine so i delleted some incidents and it still worked great so I decided to change the date of an incident to put it out of date and see if it updated...

Noop, that not it either, now I get a different Error (See attachment) I knew this was going to be a problem, I've been puzzling over it for a couple of days :banghead:

Hi C J I'v pasted your code into a new empty query saved it, then run it I get an error message that says ! Operation must use an updatable query I can see this is an update query so I dont see where the error is being generated? See Attachment Thank for being pationt

Hi CJ I've checked the field names but Still not working I've tried to change your code to refleft my logic and this is what it looks like UPDATE Employee INNER JOIN (SELECT Incidents.EmployeeID, Employee.EmployeeName, Count(Incidents.EmployeeID) AS CountOfEmployeeID FROM Incidents WHERE...

Hi CJ The code doesnt work, instead it thows up two input boxes asking for Perameter values for Incident.EEID and Employee.EEID The aggregate Query I generated to count the incidents for an employee looks like this SELECT Incidents.EmployeeID, Employee.EmployeeName...

Wow I had considered using SQL Ill give it a go Many Thanks CJ

Thanks CJ I have an Employee table with fields EmployeeID (autonumber) EmployeeName (text) DepartmentID (Number) Status (number) and an incident table with fields IncidentID (autonumber) EmployeeID (number) this has a relationship to the Employee...

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