Recent content by Teessider

I have a problem with a db using SQL Server linked tables. Bit of background: It was originally designed in 2007 and is on a corporate network using corporate PC's. Then when we upgraded to 2010, the db was upgraded also. Anyway, I design on my work desktop PC, and all works well. It also...

LOL, wierdly, I realised that after I posted, and I was coming back to try and delete my post out of pure embarressment... Thanks for stating the obvious for me...I am an idiot...ignore me...:D Obviously, when I was re-pasting the other text, access looks at the query again and automatically...

I create a querydef using the following code... Private Sub Command74_Click() Dim sql As String Dim assType As String assType = "1" sql = "SELECT tblPeople.strPersonNINumber, tblPeople.strPersonforename, tblPeople.strPersonSurname, tblAssessments.strAssType...

It's all good, found the solution elsewhere... Simply used Shell to start Wordpad, then used sendkeys to paste in the text. Wasn't working before for me (which is what was confusing me, as I thought it an easy solution), but by simply pausing the execution of the code for half a second, worked...

Because that's not what I want to do. I understand your obsession with people searching first, but I have searched a lot to see if this is possible (i.e. for two days) and haven't found anything, so I was hoping someone would be able to simply tell me if this was possible or not.

I have some vba that concatonates a number of variables/fields and puts the resultant value into a text box. Then the user copies and pastes this into wordpad to create a file. What I would like to do is for the user to click a button and instead of the result being placed into a text box on...