Search results

Bravo! Exactly what I wanted :o Many thanks!

I found the below code searching through the forum and it almost does what I want but not quite! The code writes to a file then outputs to a pop up box from an OnClick event on a form. In the box the Chr(13) ensures that a carriage return is at the end of each line so the output it how I want...

Working!! Excellent! Took a while to get my head round the Chr$(34) and how to use it! The full string finished up looking like: C:\Program Files\Microsoft Office\Office\winword.exe "x:\my file\mydocument.doc" Works a treat! Hopefully a few more brownie points at work for me! Cheers for...

Nearly! Ok, I’m very nearly there with this! The problem I have now is the one of the folder names has a space in it! e.g. x:\some_project\excel files\the_file.xls When excel opens I get two error messages, one saying cannot find file “x:\some_project\excel.xls” this a second says cannot...

I need to create a button to load various documents with either word or excel. I have done some test with the Shell command and I have got it to work but I could do with being able to build the shell string from variables rather than having only as static. :confused: This code works fine...

Worked :-) Yep, worked like a dream! Many thanks! Yes didn’t use ‘Name’ as my field name either it was just for an example ;-) Cheers Matt

Ok, I have a query that pulls data from various tables, what I want to be able to do is when the query is displayed, add an additional field to the end of the result based on information stored in other fields. E.g. Query field headings: Name, Favourite Number, Favourite Colour, Show me, “5th...