Recent content by matthewnsarah07

Hi I currently have database that provides staff briefings, due to use of a Citrix Server and some very slow local connections there is one table in particular [tblcontent] that is only needed on occasion and therefore I create a link to that table as required via VBA. This table then needs...

Hi I currently have a system that provides staff briefings on a 24/7 basis. I am now expanding the usage over a much wider area but to users who are also spread across three different, non connected servers as they are regionally located. However there will be a need for certain articles to...

That works fine as the number of washes is a constant. Thanks for your help, really appreciated!!

I've attached a quick sample In this the letter W for wash, after the 5th the item is replaced and an R for replacement is entered. The counter (BE) would then need to count from the furthest R from the left each time Thanks

Hi I think what I'm thinking of is possible but I can't work out how!! I have a worksheet which is tracking the number of times a uniform is washed so it can be replaced when needed. Between columns E:BD the user simply enters the letter W when they have washed their uniform and a simple...

Hi I have not used the FollowHyperlink method before and have started to use it to open another Access database. The database is one that opens briefly, emails out a report then show a message box and then quits. I have used the following Application.FollowHyperlink "G:\NW REGION OP...

Excellent thanks for your help both The DLookups should be fine as there will only ever be 7 records in the table

Public Function CumbriaImmediate() Dim MILLNESS As Integer Dim LOWHURST As Integer Dim Total As Integer MILLNESS = DLookup("[Immediate]", "tblIncidents", "[Sector]='MILLNESS'") LOWHURST = DLookup("[Immediate]", "tblIncidents", "[Sector]='LOWHURST'") Total = MILLNESS + LOWHURST End Function...

Thanks for your help I have added it like that and it is public in a Module - it now states ambiguous name error

Hi How do I call a variable in a public function into a query. I have an append query and need a variable within a function to append to a field. The function ImmediateCount() has Mill, Low & Total as variable - I want the variable Total to be called Thanks for your help

Not sure why the minus occurs but I've actually added in If Statement so if DiffMin is less than 0 it uses the original calculation and that seems to have negated the problem

Funny you should say that - just tried 22:00 to 06:26 and its thrown out a minus!

DiffMin = (DateDiff("h", [StartTime], [EndTime]) * 60) - DateDiff("n", [StartTime], [EndTime]) Swapped around as you day and works fine now - thanks for your help working this out, seems so simple now

Sorry responded as you did - shows data type mismatch with that code - could me the minus number

Just stopped the VB Code at the error and say for 22:06 to 06:00 next day it is showing DiffHour as 8 which is right but DiffMin as -6. This is causing the error, is it something to do with the calculation that forms DiffMin