Search results for query: *

Many thanks all! After looking into this further it certainly appears this is not a problem I can solve through a simple configuration (and I'm def not going to edit the source code) so I've abandoned all hope and will just put a disclaimer with the SS explaining the problem. Cheers, Uncle Svenno

Hello, It appears Microsoft have set a limit to the row height. As in, if I format the cells to wrap the row height will adjust to a point. Then, it looks like I'd have to find the particular cell which exceeds that row height and adjust the row manually. Ultimately, I'd like to do this...

Heya, I have an MS Word document which I have linked to an html page via the following HTML code: <a href="S:\blah\...\toClient v3.0.doc" target="_blank"> The MS Word document (toClient v3.0.doc) has a VBA Form which loads on the "Document_Open()" event. This works fine if the user saves the...

Unfortunately I cannot think of a way to make this work, if I try to link the cells I will need to have another worksheet to link them too. Seeing as the other worksheet isn't inserted until I export the query result I can't see how i could link them correctly. I'm not keen to go into the...

Ohh I see, good idea, I'll give it a go and let you know the result. Thanks a lot, Uncle Svenno

Hi Mr Payback, The number of columns doesn't change but the number of rows does. I think I could make an estimate and suggest it would never exceed 60 rows. Are you suggesting I ask Excel to read the data from the "additional worksheet" from within Excel and paste it into the formatted cells...

Hi PHV, Thanks for your suggestion, I've had a look at it and it seems to dislike the set up I have. I have 5 back end .mdb files which sit on a shared server. The front end is an .mde file which sits locally on the users PC. I would need to pull the data from a query within the .mde file...

Hello All, I have a button on a form which exports the result of a query to an Excel spreadsheet with the following code: Private Sub cmdExport_Click() On Error GoTo Err_cmdExport_Click ' Local Variables Dim db As Database Dim qDef As QueryDef Dim fPath As String Dim...

My pleasure PenelopeC, finally I have put something back into the community! Regards, Uncle Svenno

Sorry Ken, I can't continue on this one, the data is sensitive and I'm a little under the pump so I don't really have time to re-create the spreadsheet. If I have time later I'll come back to it. Once again, I really appreciate your help. Take care, Uncle Svenno

John and Ken, Thank you for your help, unfortunately the problem still occurs. I have found a work around, a lengthy cut and paste effort. much appreciated, Uncle Svenno

Hello, I am trying to export data inserted into an HTML page to an Excel spreadsheet. If I right click on the HTML page I get an option "Export to Microsoft Excel", this works fine, however I wanted to use a button on the page to do it. I am using the following HTML code : function...

Greetings, I have an Excel 03 spreadsheet with a large number of cells I wish to paste into a column. Prior to pasting these cells I have sorted the spreadsheet. Upon pasting the cells the new cells line up correctly with the values in the other cells in the rows. Everything works fine until...

Hi PHV, Thanks for taking the time to answer my question. Unfortunately I'm a little slow on the uptake sometimes, do you mean by this that it doesn't really matter either way? I am making an mde file which to my understanding compiles the code. So if I create an SQL query as a String...

Hello All, Can anyone tell me if a query will execute quicker on linked tables on a seperate server if the queries are generated as "Queries" via the objects panel in the Access Database Window or as a String within the VBA code? If so what is the difference? Thanks, Uncle Svenno

Thank you very much, I'll be sure to look into it. I am pushing to upgrade to a more stable system which will allow for db schema growth and development and which will handle more concurrent users. UncleSvenno

Hi DuMoore, I'm no pro, in fact I've posted more questions than answers, but I thought you could have a field in the customer table which tallies the customer's orders. Each time an order is placed the tally is incremented. Then a query could be created selecting the tallied field, when the...

Hi Trendsetter, Thanks for your time. Yes it is connecting to data tables, the first screen to be loaded after the splash screen shows information resulting from a couple of queries on a couple of tables. The tables being queried have approx 25,000 and 5,000 records respectively. If I wanted...

What would cause a reserved error? And how would I know which version of jet database I'm using? I currently have an Access 03 db. Thanks, Uncle Svenno

I have an Access 03 Database, it's split across 5 tables. One of which contains all the GUI and setup data which I have converted to a .mde. This sits on the users pc (front end), and the other 4 sit on the server (back end). The largest of the .mdb back end files is about 12MB and the front...