Recent content by robjones23

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