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 dencom 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: PureSlate
  • Content: Threads
  • Order by date
  1. PureSlate

    Macro ending without hitting "exit sub" "end sub" or generating an error.

    Hi all, I have an interesting issue I've run into. I have a macro that is used to import data from a selected file into a specific location. This macro worked fine in Excel 2007, but has an odd glitch where it will just end when run in 2010. I've tried putting break points on each line that...
  2. PureSlate

    Excel VBA Macro to remove document information

    Hi all! I've been working on a macro (in excel) to remove document information/ from all the powerpoint, excel, and word files within a document, but I'm having a difficult time getting the .RemoveDocumentInformation(type) method to run with any non-excel types. The code will run if I replace...
  3. PureSlate

    Excel 2007 Hotkey question.

    Hi, As part of a template I'm making, several "on event" macros I have running prompted me to keep one worksheet in the template locked without the ability to select the locked cells. For some reason, this has the side effect of disabling ctrl-pageup and ctrl-pagedown to switch between...
  4. PureSlate

    Excel 2007 - Modifying PivotTable Source Data

    Hi all, I'm having an issue correctly modifying the source data for a given pivot table. I currently have the following code: ActiveSheet.PivotTables("PivotTable3").ChangePivotCache ActiveWorkbook. _ PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "ETD WIP...
  5. PureSlate

    VBA Function issue (Entire Row formatting)

    Hello, I'm having issues getting a function to work properly. Essentially, I am trying to make a function that will conditionally format a row for the user. (Yes, there is a reason I'm not using conditional formatting.) My problem is that, while I can get similar code working in a subprocedure...
  6. PureSlate

    SQL Matrix of possible combinations.

    Hi, I've been given a large set of data to transform, and while I think the task would be relatively simple to complete by making a quick macro, I imagine there should be some relatively simple SQL solution for this. Despite my efforts, I have been unable to come up with a query (or set of...
  7. PureSlate

    Simple query gone wrong?

    Hi all, I have a simple query here I was hoping somebody could look at. I created this query to pull only records from "GLHIST" which had no cooresponding record in "GLMAST." SELECT GLHIST.* INTO GL FROM GLHIST LEFT JOIN GLMAST ON GLHIST.[Account Number] = GLMAST.[Account Number] WHERE...
  8. PureSlate

    Data type mismatch (Again)

    I think I am cursed with this problem. Again I am having an issue with a query refusing to run due to a data type mismatch. All related fields appear to be set to text, with a field limit of 255. Currently the fields I want to update are all Null, while the fields I am pulling from are...
  9. PureSlate

    Large .txt file to table issue

    Hello, I've been trying to import a large (>2GB) text file into access lately. My main problem has been that I either get import errors for everything after 400k~ rows, or I get #Num! errors when linking on around half the rows imported, still missing many rows. The file is fixed width, and I...
  10. PureSlate

    Query for blank values: Data mismatch

    Good morning (Or afternoon/night if the locale is right.) I was introduced to the website last Friday, and this is my very first post! Anyway, I'm having an issue with a very simple query. I'm trying to use the criteria "" to return only records where the specified field is blank, but I get a...

Part and Inventory Search

Back
Top