Search results

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.

Some help. I have been tasked my boss to help with the migration of a database from one datacenter to another. It has been decided to produce a flat file of the original database and transfer that and then import the file into the new database at the new location. (The data within the...

I always loved "Mork and Mindy", that 70s TV show with Robin Williams. The landlord was called "Mr Wanker", the amount of times his name was said was amazing. I can only guess "Wanker" is not (or was not) a word in the US..

The system at Nuffield was not build by the same company that Accenture are working with that are laying off staff. One of the points to note is on the NHS project if the companies fail to deliver they do not get paid..

I was suprised I thought that there was no way he would not get the death penalty...

So what is the feeling about the 9/11 guy not getting the death penalty. Whilst I do not support the death penalty, putting someone to death because something they did not do seems completley wrong. No matter how terrible 9/11 was.