Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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