Recent content by rudejohn

I know there are shareware/freeware applications for natively viewing JAR files on Windows desktop machines (I use a few nice flavors of them at home). However, some people on my team don't have admin access and can't install said tools on their machines at work. It would be nice to use the...

Oops! Found a typo in my code. Thanks for your help, excellent detective work! RJ ************ RudeJohn ************

Thanks for your help. I'm getting the following error message: Microsoft Access: Join Not Supported. ************ RudeJohn ************

Sure. I'm simplifying the data a bit to mask the application, but this is logically the same: Table 1 INFO SOURCE DESTINATION blue wacker main yellow broadway 2nd red main broadway purple cleveland 2nd white 2nd wacker black jackson...

Didn't work. When I put the "AND" in I didn't get any results, and if I make it "OR" the DESTINATION and SOURCE address are the same (which I know from the table they are not). Any suggestions? ************ RudeJohn ************

Thanks, I'll try that immediately. That will work even though the Destination and Source addresses are different? ************ RudeJohn ************

Here's the scenario: "Table 1" has INFO and SOURCE and DESTINATION address "Table 2" has address and name (essentially a lookup table) I need a SQL query that will give me: INFO SOURCE_NAME DESTINATION_NAME Essentially, I need to lookup the name for both the SOURCE and DESTINATION address...

Great answers: Thank you, much obliged! Being a Java programmer by training I'm unfortunately weak on pointers and data storage. ************ RudeJohn ************

I'm relatively new to C so I appreciate your assistance for my novice question. I have a struct pointing to some data. Let's say... typedef struct { unsigned char var1[6]; unsigned char var2[6]; } MY_STRUCT; Now, I'm pointing this struct at some hexadecimal data. MY_STRUCT...

Thanks to both of you. ************ RudeJohn ************

Can anyone clue me in as to why some VBA code uses "--" before a formula? Example: num = Evaluate("=SUMPRODUCT(--(B2:B5=H4"),--(C2:C4=")) ~I'm splicing code pieces together so don't worry if the ranges/parentheses don't quite match up Thanks in advance! ************ RudeJohn ************

Excellent. I added some safeguards to prevent it from being zero, and safeguards to ignore the header row, and this formula works perfect. I owe ya one! :) ~John ************ RudeJohn ************

Excellent help... thanks PHV. I'm having an additional problem now. I'm trying to grab a date from one field and either remove the time from it, or copy it to a new field with the time removed. Example: C2 has the value "1/6/2005 8:00AM" I want to have the value "1/6/2005" without the time...

Thanks, that's what I tried to do. But I'm having a bit of trouble translating hard values to variables. For example, if the code says: SomeFunction(A1) How do I change that to Dim i As String i = colNum & rowNum SomeFunction(i) The code above doesn't seem to work in some cases...

Thanks... first problem solved! Any recommendations for a general "overview" of VBA or tutorial? All the Google results I got were just compilations of Excel files without much assistance inside... ************ RudeJohn ************