Search results for query: *

Thank you Sir!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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