Search results for query: *

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

Thanks K, I'll have a play around.

Hi all, I have a message that is probably about 500 words long and am using the Run Macro on a button then SendObject. I get the warning that the message is too long when I copy and paste it into message box in the create macro screen. Is there an easy way to do this without VBA etc., i.e...

Thanks very much for your help.

Thanks Remou - sorry, i am a total novice in access (no idea how i managed to build the db & front end forms!!!). where would I put that code and where would i look for the results during the middle of the day to see the amount of connections - or is that something to run now to see who is...

Hey Experts, Just a quick question. I have a DB on a drive and the front end is on everyone’s machines (Access 2007). Is there a way I can add a table to the database that counts how many people log in - or not even a table maybe, just a way to see amount of connections? I want to get an idea...