Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nic6000
  • Content: Threads
  • Order by date
  1. nic6000

    Update Pivot Tables using VBA

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

    Exporting Data to Excel, but process not finishing

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

    Export Data from Outlook Custom Form to Access

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

    Creat Macro in Outlook Script Editor

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

    Export Excel Spread Sheet as a text file using Access VBA

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

    Changing the properties of a control from a subform

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

    Problem with exporting Recordsets to Excel from Access

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

    Export MS Access Record Set to Excel

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

Part and Inventory Search

Back
Top