Search results for query: *

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

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

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

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

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

Greetings, I am trying to close a form (frmLoading) from another form (frmCostings). Here is my code within frmCosting's Form_Load event: Private Sub Form_Load() On Error GoTo Err_Form_Load Dim rst As Recordset Dim Msg As String Set rst = CurrentDb.OpenRecordset("wDefaultAO"...

I have a listbox which is populated by a Query. My problem is I am unable to select individual items within the Listbox. I have looked through the different properties and cannot see anything to help with this. Also I have tried implementing a Click event and it doesn't register: Private...

I have a listbox which is filled as the result of a query. No problems filing the listbox, however i want to put in a test if the listbox contains no data. I have used the MsgBox to output the size and I constantly get "1". I get this result even when the listbox is empty. I thought if I'm...

From Access97 I am providing functionality to allow the user to export a query result to an Excel97 spreadsheet. Got it working well but I would like to give the user the option to select where to save to. I was thinking something along the lines of a Folder Dialogue box or a Save As Dialogue...

Gee I'm spending more time looking for help today than actually working! I'm trying to export the results of a query to an excel spreadsheet. Any ideas? Thanks again, Uncle Svenno

Can anyone tell me if it's possible (and of course how to do it) to have adjustable column widths in a listbox. For example I am outputing a query to a listbox : DoCmd.OpenForm "frmForm1" Forms!frmForm1!lsbListBox1.RowSource = "Query1" The resulting query has 4 columns which I would like to...

Ohh boy, back to VBA coding, I've been working on Java for so long I can't remember some basics! What does the $ symbol represent? ie: MsgBox Error$ And is there any good links or forums for these sort of syntax questions? Save me asking basic questions to experts! Cheers Uncle Svenno