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 Chriss Miller 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. mrfritz44

    Data Validation

    Thank you Sir!
  2. mrfritz44

    Data Validation

    Our Internal Audit department once had a slide rule that calulated the percentage of certainty for data validaiton over a given sample. I cannot for the life of me find and equation to use for my own validation. Does anyone have that equation or could you point me in the right direction for...
  3. mrfritz44

    Can't Turn Off "Format with Multiple Columns" Setting

    We have a prescription report at work that was designed to print two columns. For the Detail section, the "Format with Multiple Columns" is checked. As an aside, the right side of the report is shaded blue and can't be edited. We also have a special printer that prints single prescriptions so...
  4. mrfritz44

    EXCEL: How can I remove spaces?

    Thank you very much Gavin. That last function is the ticket and the one I'll be using. Have a good one, Fred
  5. mrfritz44

    EXCEL: How can I remove spaces?

    Update....that funciton works but there seems to be a character limit on the cell for the macro to work. I trimmed down the text block a bit and then it works. There seems to be a limit around 600 charcters that makes it not work. This is too bad since it seems like a very useful macro if I...
  6. mrfritz44

    EXCEL: How can I remove spaces?

    Using this macro with no luck: Sub RemoveParagraphs() Cells.Replace What:=Chr(10), Replacement:=" ", LookAt:=xlPart, SearchOrder:= _ xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False End Sub
  7. mrfritz44

    EXCEL: How can I remove spaces?

    It's a chr(10), which I already tried in the previous replacement macro...........ahhhhhhhh!!!!!!!!!!!
  8. mrfritz44

    EXCEL: How can I remove spaces?

    This is the block of text: Note that the following scripts will take a long time to run as they read the entire Anc file! Script to identify ANC records with error #08 "Ev-Subject Error, null not allowed" select where EV-PTR = 0 OR EV-PTR = 8224; l d @prikey, ev-use, ev-ptr, ev-date;go...
  9. mrfritz44

    EXCEL: How can I remove spaces?

    I highlight the cell and then run the macro. IS this what you mean? Similar funcitons work for text typed into Excel, but not the copy and pasted block. Fred
  10. mrfritz44

    EXCEL: How can I remove spaces?

    Thank you for the attempt, but it did not work. Try pasting the text I listed above on your funciton. It appears to do nothing. Thanks, Fred
  11. mrfritz44

    EXCEL: How can I remove spaces?

    I want to remove everything necessary to make the text appear like the block I manually edited above. This text is all in one cell. I'm not sure what characters are keeping the lines from formatting. I tried chr(9), chr(10), & chr(12). Any ideas? Fred
  12. mrfritz44

    EXCEL: How can I remove spaces?

    Sorry for being vague. The goal is to make the above text block appear as I've pasted below: Note that the following scripts will take a long time to run as they read the entire Anc file! Script to identify ANC records with error #08 "Ev-Subject Error, null not allowed" select where EV-PTR = 0...
  13. mrfritz44

    EXCEL: How can I remove spaces?

    I actually got it to run, but it won't work with the block of text I'm trying to clean. I'll post the text block here and maybe you can deduce what modifications needs to be made to the macro? Thanks, Fred Here's the text block: Note that the following scripts will take a long time to run...
  14. mrfritz44

    EXCEL: How can I remove spaces?

    Thanks very much for the tip. From a newbie perspective, how do I get this code into Excel to actually use as you described? Thank you! Fred
  15. mrfritz44

    EXCEL: How can I remove spaces?

    I would like to start with a blank spreadsheet that uses some technique (macro, function?) to automatically remove spaces from a cell when text is pasted into it. Better yet, I would want to remove instances of double-spaces with nothing. The goal is to automate the process of forming a...
  16. mrfritz44

    PERSONNEL View

    Please to you to run the PERSONNEL view and me to tell the results. We machine will'nt run this prossess. Thank you to you very much good day, Shiek Fritz
  17. mrfritz44

    Query to Find Database Differences

    This needs to be done with Oracle SQL on an Oracle box.....any hints onthe syntax for that batch?
  18. mrfritz44

    Query to Find Database Differences

    Is it possible to run a single query to audit the row counts of the tables for an entire database? My final goal is to find the tables that differ in terms of row count from two separate databases on two different servers. Any help would be apreciated. Thanks, Fred
  19. mrfritz44

    Use a multi-select box in a parameter form.

    I'm using a form to pass variables to a query. On this form is a multi-select box. If I set it for no multiple selection, the object works fine and I can see my chosen value in the Datasheet view. However, when I use simple or extended selection, the form does not pass the values and the...
  20. mrfritz44

    Enable/Diable Form Objects with a Checkbox

    I have a checkbox on a form that sits next to a select list. When tha page loads, I want the seletc list to be disabled. When I check the checkbox, I want the select list to become enabled. When I uncheck the checkbox, I want the select list to become disabled again. What steps do I need to...

Part and Inventory Search

Back
Top