Search results

Hi all, Very long time no post. I'm working in a non-IT post at the moment but someone has asked me to do them a favour! OK I know I shouldn't strictly embed images in HTML emails but that is exactly what is required. I need to be able to send an email to 100 users on our internal network via...

You could check if any of the dates in the range are a Saturday or Sunday. I would use 'format' to check what day it was. Something like... Something like this will work but I'm sure there are more elegant ways to do this. Hopefully someone will post one. One other thing, my organisation...

That girl can't be from Essex (got family in Church Langley, Harlow). Where are the white high heels, the Burberry cap and the double buggy covered in cigarette ash.:D

I work in an atmosphere similar to what you describe. IT in our organisation is largely male dominated. I would expect the average age is mid 40s. The first time I saw this happen I was amazed. They broke off in mid sentence, drooled, then picked up the sentence as if the hadn't stopped. I asked...

Do you need to put the records into a temporary array .GetRows. Can't you just work with the recordset? Your SQL statement could take a while as I'm not sure it be taking advantage of any indexes you might have on the table. I used to use a auto index on all of my tables and when I needed...

Kodo, Adeptus - Thanks guys. I find your last posts particularly valuable. My company is a bit slow on the uptake when it comes to development. We have a web development team for in-house applications. Sadly this team has NO web developers??? They are tinkering with .net trying to build...

Cheers Kodo, I agree a string is just a string the url to the asp is something like this ...search.asp?mr=smith+1&am=1000 when I request.querystring(mr) the value I get is 'smith 1' when I request.querystring(am) the value I get is 1000 the + is being treated like a space...

Adeptus, Thanks for the reply. It gave me an idea to write a URLEncode type function in Javascript. I iterate through the reference and check each character to see if it's none alpha numeric (using charCodeAt) to get the chr$ value. I then convert this to Hex and bung a '%' in front. Ref...

There are two statues in a park, one of a nude man and one of a nude woman. They had been facing each other across a pathway for a hundred years, when one day an angel comes down from the sky and, with a single gesture, brings the two to life. The angel tells them, "As a reward for being so...

Cheers Keith, For concatenation in Access, I always use '&'. This issue is about getting the information from the input page (HTML) to the ASP. If the reference being searched for contains a '+', this is interpreted as a space. If the reference has a '&' in, this is interpreted as a termination...

Hello everyone, How do you all deal with + and & when sending info to an ASP? Some of our Reference fields contain + and/or & When the user enters a ref containing + eg SMITH+1, SMITH 1 is sent to the SQL server stored procedure. When the user enters a ref containing & eg SMITH+1, SMITH is...

When you say ASP, do you mean VBScript? If so it's quite simple... Replace(string, char(s) to replace, char(s) to replace them with) Hope this helps.

Thanks again Workmad3. He's back in work and no-ones the wiser. He's decided to leave the database as I recreated it. This makes life easier for everyone. He's going to do a back-up every week. This is OK by me because it won't take long to restore (upto 7 days only could be lost). He told me...

Thanks for the reply workmad3. I was afraid that the records were gone for good. The database in question was something I set up many years ago to store Management Information. I wrote a totally seperate back-up application and in the 3 years I was looking after it, I never lost a record I...

Long time no post. The guy who took over from me has been a bit silly. He was in a 'test' database and deleted some records from a 'test' table. Problem is, he was in a live database. Instead on admitting it, he's gone off sick and is bricking himself (he's just rang me). Where do the deleted...

I'm not entirely sure about the exact problem but it looks like you have to pass a date into the function. So I would say when you're setting the control source of the text box instead of shouldn't it be =CheckSeason(SomeDate) Might solve the problem. Take care

Four friends, who hadn't seen each other in 30 years, reunited at a party. After several drinks, one of the men had to use the toilet. Those who remained talked about their sons. The first bloke said, "My son is my pride and joy. He started working at a successful company at the bottom of...

Could it be your mouse? Does right clicking in another application work? Sorry I know they are dumb questions but you never know. Take care

Hello, modDate= FileDateTime(Your Filename inc path) This should do the trick. Take care.

Sorted now thanks I've sorted this out now. The last column in my html table is a hyperlink to another page. It has details of the references input by the user. This hyperlink was terminating at the single quote. As the references on the next page are for display only, I did a...