Search results

Can anyone tell me why this isn't working?!! Function Testmodule() Dim TT As String TT = "*" Dim SQLquery As String Set MyDb = CurrentDb() SQLquery = "SELECT BizTalk_Import.F1, BizTalk_Import.F2" & _ " FROM BizTalk_Import " & _ " WHERE BizTalk_Import.F1 = " & "TT"...

Thanks for taking the time to answer but this isn't the same message. The one I'm getting seems to be related to Windows XP SP2 security (It has the XP security icons etc as found in the control panel) rather than Access 2003 security. As the only thing that's changed is the introduction of SP2...

Sorry to bump this but someone must know what the cause is?!

Hi all, Our company is currently rolling out an SP2 update to all of our PC's and this problem has reared its head on all of the updated PC's so far. Basically when someone opens a database from a shared drive, they get an error stating that the file was made by an unknown publisher (seems to...

Sorry for the late reply I went on holiday :) That worked great thanks again! Code looks like this: Public Function Downtime(systemOff As Date, SystemOn As Date, sev As Integer) As Date Dim diff2 As Date Dim diff As Date Dim hrs1 As Date Dim hrs2 As Date Dim tyme1 As...

Sorry to resurrect this thread but I've got a new requirement which I'm not sure how to incorporate (if possible!!) At the mo I'm using different code to the above as things changed as we learnt what was required. Currently I'm using: Public Function Downtime(systemOff As Date, SystemOn As...

That's done it, it works now! I just thought integer meant number, didn't realise it had a maximum value attached to it. The whole lot calculates now which is great! Thanks ver much for all the help Peter it's greatly appreciated! Rob.

here's the actual database with two lines of data in it, one which works, and one which produces the error message. Could you take a look???

Hmmmm.... strange. on the instances where it works, it steps through each step fine, however when the #error is produced, it simply doesn't step into it, it's like it ignores the breakpoint (which i placed at the Public function at the top of the modules).... Any ideas??

It's running from a query - I've never stepped through a module before - where's the option? :) <-------- Newbie spotted!!! :)

The times are input into a form and then the forms text fields are appended to the database table. I use the seconds figure to calculate numerical outage times (we need hours:minutes as well as a numeric time, e.g. 1 hour 30 minutes is 01:30 as time and 1.5 as numeric value) So thats why I've...

Ok, so I've come back to this and don't really understand what MJ is talking about, and I've still not done the open recordset option as yet. However, the code below is working for some, but not for others and I still don't understand why. The attached Xls file shows an example from the...

Hello All, I've got a database which has several fields but the ones I'm interested in are: Seconds1 Sev Seconds2 Sev2 Seconds3 Sev3 etc... Basically Seconds 1 holds a number in seconds of outage time, Sev tells me which severity the incident was at at the time. So for example the database...

Bloody hell how stupid of me! Well spotted and thanks!!! Working fine now! Rob.

Hi all, I'm trying to create a database to manage contacts coming in to us from another company. Their extract has a reference number and updates (kind of like a call logging system). Every time an update it placed into the system, it's put onto a new line so you see this: Reference...

I also got the other time figured out too (non-core times). I needed 4 hrs intervals to set the non core before the core hours. I.e. 00:00:00 am - 07:00:00 and 22:00:01 pm - 23:59:59 used this: Public Function Downtime(systemOff As Date, SystemOn As Date) As Date Dim diff2 As Date...

Scratch that, I used the following on the resulting field to calculate hours:minutes Public Function HoursAndMinutes(interval As Variant) As String Dim totalminutes As Long, totalseconds As Long Dim hours As Long, minutes As Long, seconds As Long If IsNull(interval) = True Then Exit Function...

Hmmm... well it DID work great :) I've got a problem - when the diff is more than 1 day, I get things like 01/01/1899 04:00:05 etc.... Can it be formatted to say XXdays XXhours XX mins ????

That works great! Thanks so much, only thing I had to do was change mm/dd/yyyy to dd/mm/yyyy I may need to account for some other times on specific dates (someone just told me we have no coverage on sundays and only 08:00 - 12:00 [midday] on a saturday) I think I have the buliding blocks to...

Hi, I'm trying to figure out how to get this working and i'm struggling to get my head around it. I need to create a Database which looks at outages in a system and calculates the outage time. Initially this seemed easy enough and I soon had a database which would figure out hrs / mins of an...