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: *

  1. newguy86

    Excel VBA Automation Issue

    Hey Skip, I'm not sure if I understand your question but the list that I provided is generated by the end user when they enter the different zone codes, or syscodes, that apply to the change being requested. There are several syscodes within a single market so each market will usually show up...
  2. newguy86

    Excel VBA Automation Issue

    I'm trying to automate a form that was built in Excel so that the information within the form is automatically organized into a table on another sheet. I've worked out most of the process but the issue I'm having is that a part of the form lists different codes for each of the broadcast zones...
  3. newguy86

    Resize Pivot Table Data with VBA

    I've been running this for a while now and I've noticed an interesting issue. Whenever the code is trying to pull in the first dataset from an excel spreadsheet, it takes forever to pull the data in. But after that first dataset, all the rest of the dataset's (regardless of size) get pulled in...
  4. newguy86

    Resize Pivot Table Data with VBA

    Ok. I see what you're talking about. I put everything in that you said and it works perfectly now. Thanks! Travis Charter Media
  5. newguy86

    Resize Pivot Table Data with VBA

    Correct. The formulas are in each separate workbook table and gets copied over into the Data worksheet. I'll try to change the code to put the formulas in after I've copied the DATA over from the other files. Travis Charter Media
  6. newguy86

    Resize Pivot Table Data with VBA

    The data comes from a separate Excel file that we use to process and reformat the raw data that comes out of our system. The formulas are put in to that file during the reformatting. Here's the code that updates the final report: Sub Update_Report() Dim MainWkBk As Workbook Dim NextWkBk As...
  7. newguy86

    Resize Pivot Table Data with VBA

    Thank you for the suggestion. That seems to work with the exception that whenever I upload the new data through VBA the formulas in the first record of the table are now being changed from: =SUM(F2:L2) To something like this: =SUM(F2:L92600) It only happens in the first record of the table...
  8. newguy86

    Resize Pivot Table Data with VBA

    Thanks for your response Skip! Quick question...if I do this will it be able to accommodate to changes in data sizes? For example, the data right now is about 83k rows. But sometimes the data is less than 80k rows and other times it's over 85k rows. Will a Structured Table be able to capture...
  9. newguy86

    Resize Pivot Table Data with VBA

    Hello Everyone, I've been tasked with automating an Excel 2013 report that uses pivot tables. So far it's working except when I get to refreshing the pivot tables. Now what happens is whenever a new report needs to be run, the data in the old report is cleared out of the Data Tab (except for...
  10. newguy86

    Automatically Update a Linked Table Filepath

    Sorry for taking so long to respond, the holidays can be hectic! :-) To answer your questions, because the worksheet is a report that's generated by a 3rd party system, we don't have a way to change how/what the worksheet is named when it's generated. Currently we are manually renaming the...
  11. newguy86

    Automatically Update a Linked Table Filepath

    Hello Everyone, I have an Access DB that has linked tables to excel data that I'm trying to compare. When I setup the linked tables I made sure to name the excel files something relatively generic so that any new data that was generated could just overwrite the old data using the same file name...
  12. newguy86

    Adding Notes to a Record

    Hello Everyone, I'm using Access 2013 and I have a query "qryTTOver24" that shows every order that took longer than 24 hours to complete. What I want to do is be able to is select a record in that query and add notes explaining why it took that long. I already have a table setup...
  13. newguy86

    Pivot Table Report

    Well what we have is a hierarchy built to not only identify which sales offices belong to which regions (Central, Pacific, etc), but which sales offices belong to which corporate office that manages them (STL, TN). What I wanted to do was have a report that showed the average turnaround time...
  14. newguy86

    Pivot Table Report

    What I'm trying to do is create a single report that allows the user to view overall turnaround times for all work orders in our system but also gives them the ability to drill down to specific regions and teams to see how they stack up against each other. I'm figuring that the easiest way to...
  15. newguy86

    .txt Dates Import Issue

    Perfect. Exactly what I was looking for. Thanks! Travis Charter Media
  16. newguy86

    .txt Dates Import Issue

    I'm not exactly sure what you're referring to but I'll take a stab at it. When I linked the .txt file to access, a wizard came up and I told it at that time that the data is Tab Delimited. Travis Charter Media
  17. newguy86

    .txt Dates Import Issue

    Hello Skip, I have a linked table to the .txt file that I use to upload the information. The file is setup as tab delimited. Here's a sample of what the file looks like: ID ContractNo Name StatusDesc UserName UpdateDateTime 59342 11664803 National Submitted to Traffic grice 2014-02-20...
  18. newguy86

    .txt Dates Import Issue

    I have a .txt file that I'm trying to import into access. The import works well and the data comes through just fine except that the only way that I can get the date/time stamp for each record to appear is if I import that field as a text field. The issue I run into with that is that we need...
  19. newguy86

    Query records between two dates

    I've tried using the code that you provided and I ran into a bit of an issue. Because of the large amount of historical data in the table, my process is taking forever to run the report. So I need a way to filter out the data that doesn't fall within the date range before I reformat the data...
  20. newguy86

    Query records between two dates

    Ok. To be honest, at this point I've spent way too much time trying to figure this issue out so I'll give your alternate approach a try tomorrow morning when I'm back in the office. I'll let you know what happens. Travis Charter Media

Part and Inventory Search

Back
Top