Search results for query: *

I have an Excel 2007 worksheet where column A is a code and column B is a unit value associated with that code. Example: 02094 1.25 02095 0.00 Excel is displaying a value of 0.00 for any field with a 0 value, but the actual value being saved in the worksheet is 0, not 0.00 as it is displaying...

Thanks! Star for you.

Hi, I've need to parse out data to identify duplicate entries in a database that share a License#, but have slightly different names. I want the results to display on a single line for each ID#. My data looks like this: Name Primary Key ID Smith,John 1...

Thanks for the suggestions, guys. I guess I wasn't clear enough in my question. Here are the results I'm looking for: COL1 COL2 1 DJJ: SMITH,JOHN PMF: SMITH,JOHN A 2 DJJ: JONES,DAVEY PMF: JONES,DAVY PMF: JONES,DAVEY K 3 DJJ: DOE,JOHN PMF: DOE,JOHN L So essentially I...

Hi, I want to increment the value of a cell (basically a counter) each time the value "DJJ:" appears in a neighboring column. My data looks like this: COL1 COL2 DJJ: SMITH,JOHN PMF: SMITH,JOHN A DJJ: JONES,DAVEY PMF: JONES,DAVY PMF: JONES,DAVEY K DJJ: DOE,JOHN PMF: DOE,JOHN L Basically, I'm...

Hi, Any other suggestions about how to go about this? I wasn't able to find anything under "Normalization" that seemed to help. Thanks, Michael

Actually, JBinQLD, that's exactly what I need (same name and number) all on the same table. I will only be using this table to export to excel for a presentation of which databases are missing entries for certain employees. When I got to do the actual load, I won't be using this table to do...

Hi, I have three tables all of which have names and numbers in them in corresponding rows. I want a query to match on the numbers of all three tables, while also returning the nulls in all three tables. I'm doing the comparison between the three tables because I need to know which tables need...

Oops...some of my code got left out somehow. Here's the rest. Sorry about the length. .StatusBar = "Waiting for Prompt: PARTICIPATING: {" '.WaitForString ESC & "[33D{", NEVER_TIME_OUT, rcAllowKeystrokes '.StatusBar = "" .Transmit CR .StatusBar = "Waiting for...

Hi, I've written the below code to write data from an Excel spreadsheet to a WRQ Reflections terminal. It was working fine until I tried to add a loop to it. If I use "While", it says "Wend without while". If I try to use a "For" loop, it says "Loop without For". Any ideas? Thanks...

I'm not cutting and pasting into Access, I'm cutting and pasting into the VBA module behind the IDX Console screen. It's identical in every way to doing code behind forms and that sort of thing, except you're writing to an IDX screen instead of another office program.

My company uses a "roaming profile" so that any employee can log in to any machine (it's a big company). Unfortunately, when I've tried to write code to open an existing Excel spreadsheet whether on a network drive or on my C: drive, I get a "not found" error. I could create a temp table, but...

To be more specific, my data will be an internal part of the VBA code, such as this: CODE Sub ImportFile() Dim fs As FileSystemObject Dim f As TextStream Set fs = CreateObject("Scripting.FileSystemObject") strFileIn = "T:\strText.txt" Set fin = fs.OpenTextFile(strFileIn) Do While...

Hi fellas, I have an interesting quandry. Because of the security profiles of my company's network, I'm not able to access (upload/write to) any files via VBA. So the only way for me to write to our computer system via VBA is for me to cut and paste the entire text file in my code. I...

Doesn't the hospital have Wi-Fi? A *dedicated* tek-tips tipmaster would bring his laptop into the recovery room. :D Hope you're back on your feet soon...

I figured out the problem. The current statement is working, it's the previous statement that was used that listed specific insurance codes (K50, V20, etc) that was not working and was reporting inaccurate information. Thanks all for the help.

The data that's still coming up looks like this: LNM FNM PrimaryINS SecondaryIns TertiaryIns Smith john K01 X01 M02 Doe Jane X02 V01 A03 Jones Dave X01 M02 V01

Sorry, It's still returning rows with primaryins, secondaryins or tertiaryins that start with K or V.

Hi, I'm using the below query to try to exlude any insurance codes that start with a k or v, but it's not working. AND NOT (FinClassCurr IN('W','C','K','V') OR (LEFT(PrimaryIns,1) IN ('K','V') OR LEFT(SecondaryIns,1) IN ('K','V') Or LEFT(TertiaryIns,1) in ('K','V') OR PrimaryIns = 'M20' Or...

Okay, I figured out that I was making the boneheaded move of using "and" instead of "&", leaving me with this: =IF((LEFT(B4,3) = LEFT(F4,3) & LEFT(E4,3) = LEFT(A4,3)),1,0) Now the problem is that it's returning "0" for all rows, even on obvious matches such as: A1 B1 E1...