Recent content by mutley1

Hey guys, code below. Trying to convert a text field to date time and thought I would convert thwe text first using the below (from 20110131 to 01/31/2011 as an example), but I keep getting "must use Updateable query" Any help appreciated as its a long time since I programmed, but this loooks...

Thanks, but see above "But it does not work".... I thhink the problem ie the was I wan conmecting SQL to MSACCESS - Both on the same machine as well.

http://msdn.microsoft.com/en-us/library/aa216427(v=sql.80).aspx

Hey Experts, I have SQL 2000 (old I know) and access 2010. I have looked up steps on google but once I have managed to get a linked server, I can't query the data even using full qualifiers (select count (*) from [server]..[table] etc etc.....) but it comes up with table not found. I have now...

thx simi

Hey guys, I have an access 2010 DB on my desktop and want to connect SQL 2000 to it so I can use SQL to manipulate the data. I have googled but everthing that comes back is regarding access upsizing etc. or creating linked tables (which I don't really want to do I just want to access the raw...

Can anyone give me a good guide to serttingup an XLSX import? Does iot alway have to be the same file name? I set up the driver but it doesn't like the file. I keep having to repoint the packge setp to the specific sheet every time, so I have got round it by just saving the file off and thn...

Never heard of FTP-ing to an email address. It needs to go to their mailboxes. Thanks.

I realise this may be considered for the DTS section but I have done all that formatting etc. already, so here's why I opted for the programming section. Inbound Excel, I convert, outbound file, I send. Does anyone know if there is a way that when the mail comes in with an attachment, that i...

OK, I have a DB with 2 forms. both have a detail segment only. I also have a table with 8 forms imported into the DB as attahments. Ther fromt end is seperate from the DB. Nothing difficult so far (well, the rest isn't either, but....) The table has 2 fields, ID (Auto), Desc, Attachment and...

It's a stats screen sitting on my desk and just wanted to liven it up otherwise it is a few boring lines......

Hi experts, I have a double column bar chart (each person has a given & received column) but wanted to liven it up a bit. I have a backgroupd, put it in 3D and changed bar colors. Quick question, is there a way to get the bars to flash, run thru all colors (like a glowing effect) or anything...

Thanks George, Not spoken to you for a good 9 months but you're still the king!!!! Thanks, M.

Hi guys, I had a read through the useful date time items as always, but cant work this one out. I have 2 fields that are datetime for a diabetic - bloodlasteaten and blooddate (when blood is drawn). What i also have is a computed column giving hours between the blood being drawn and the time...

I know i posted this in another thread, but I have found what seems to be a simple VBA to run the send of a message over 255 chars. Problem is, when I put the entire text of the email in, it doen not seem to like it and it auto add's speech marks etc. in the message body. Code is below. Sub...