Recent content by msp

Hi - Thanks all fo your help, managed to get it to work, I recreated the module and tried it again, results as expected

Function validateMessageDate(Mdate) ' determines if another message has occured within 10 seconds of the MDate ret = False NDate = DMax("[MessageDate]", "tbl_BaseData", "[MessageDate]>#" & [Mdate] & "#") If (IsNull(NDate) = False) Then ' determines if next highest MessageDate value in...

I have changed it to a function (and updated the SQL- Thanks) still gives a error, seems to be the # that are causing the problem

Hi I have changed it to a function, it seems to be the # that are causing the issue..

Hi, Sorry still having issues with this, my table is called tbl_BaseData, when i try and run the code given i get the message, but i am getting the error, Runtime Error @2465': Microsoft Access can't find the field "|" reffered in your exession I admidt it is prob me doing something...

I have a table which I want to compare the time of two rows, and if the time is within 10 seconds return the two rows and ignore the other rows. i.e. from the table below it would return rows 3 & 4.. Row Date Computer message 1 28/08/2012 22:11:23 Comp1 Problem...

There I was thinking that this thread was about that superbowl half time show...

Ability to wash themselves, have a conversation that does not include any reference to Star Track or Star Wars. Really just being able to communicate and convert business requirements into code, oh yes and ability to wash themselves, (I know it may seem I have repeated myself but I know more...

Wosley Rich Made me laugh

And there was me imagining some Scottish Gremlin "Do not Feed him oats after 09:00" ;)

My diet is mainly because I like it. I also enjoy cooking from fresh, so that makes a diffrence.

I find it amazing that someone would complain, they may be well within their right too but...

Hi is anyone aware of a query or Stored Procedure I can call that will retrieve all the users and permissions for a particular database. Thanks for any help.

Most weekdays, Some fruit for breakfast, Lunch is either bowl of pasta (made the night before) or a couple of sandwiches (something such as Cheese, ham, or sausage) with some fruit. Usually cook the evening meal tonight it is Thai red chicken curry with (I make the red curry paste myself)...

I never quite sure why there has to be diffrent forums. I think it was better when there was just one forum for non-technical talk. The tittle of the thread usually gave it away.