Search results for query: *

Thanks PVA and Skip, Named Ranges work OK Skip / xlbo I don't mind Pivot tables for quick lookups, but I'm usually required to produce presentable static tables of data thus negating the need for Pivots. All calcs are normally done in Access. I also think there is better software on the...

Hi, Im trying to find a way of updating an exisiting Pivot Table when the data range changes e.g one week a data table on a worksheet might have 300 rows, the next it might have 350 rows. The column headers are static. The refresh data property only updates data from the previously defined...

Fantastic, thanks guys both ways work fine!

Hi, I get you about the excplit ref - thats cool, but still no joy; The code reads c = 1 Do Until objSht.Cells(1, c) = "" excelheaders c = c + 1 Loop With Sub 'exceheaders' looking like..... objSht.Cells(1, c).Select Selection.Font.Bold = True With...

Hi, Thanks very much for that, its seems to have done the trick except the formatting no longer works. The code finishes whihout error, but the excel spreadsheet isnt formatted - any ideas? Thanks, NIc

Hi, I wonder is someone can help me? Basically I have some VBA which exports a recordset to Excel and then formats the cells - the Excel application then stays open so the user can view the data. This all works fine until I come to run the code again, which susequently doesnt always run...

Hi, Thanks very much for that - it works a treat

Hi, I'm having difficulties trying to understand how to export to Access 2000 from Outlook 2000 from a custom form. I'm very new to Outlook struggling to work out what I need to do in VBScript. I have been looking around on the net and have come up with the following which of course doesn’t...

Hi, UPDATE: I have solved this one now - found the answer on the net. I needed to uncheck the 'Send form definition with item' box on the (Properties) tab. Cheers Nic

Hi, have published form which is on Outlook 2000.

Hi, I'm hoping someone can help me with this. I'm completely new (just today) to custom forms on Outlook and have got a bit stuck. I Basically have created a form with a number of fields on which are to be completed by a user and sent back to a group email address. When the group email...

Hi, Thanks for looking Combo. I will be moving over to XP in a few months so your info on the Local Parameter should be very handy. Have tried just about everything that the saveas method has to offer in 2000 but to no avail - I wonder if it is a registry issue?

Hi, I'm returning error 'named argument not found' using 'local: =true' , I presume I'm not adding it correctly, as quite new access VBA. Any extra info would be apreciated. Thanks in advance. Nic

Hi, I wonder if any one can help me? I am trying to save an Excel Worksheet as a tab delimited txt file using Access VBA. I need to get the file into text format so I can then Import it into Access (The data is pretty naf so need the functionality of an Importspec). I have created something...

Hi, I wonder if someone could help me with the following... Basically I'm trying to disable a button on a form when a specific action happens on the subform. I have searched around for an answer and the closest thing I can come up with is by using the Parent Property, But cant get it to work...

Thanks Skip, its know working, you help is very much appreciated. Nic

Hi, I wonder if anyone out there could possibly help me please. I'm currently trying to output data to a number of Excel Workbooks from Access and am trying to achieve this by looping through stored filenames and query names in a table. The macro starts by stepping into the first row in a...

Hi, I wonder if anyone out there could possibly help me please. I'm currently trying to output data to a number of Excel Workbooks from Access and am trying to achieve this by looping through stored filenames and query names in a table. The macro starts by stepping into the first row in a...