Search results for query: *

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

Background: I'm a decent Java and C programmer but rather new to VBA programming and having some definite trouble understanding the concepts. The tutorial(s) I've found have been absolutely dreadful. If anyone has suggestions for a good place to start, that's great. Next, how do the ranges...

We're currently creating XML from Java Business Objects (but this isn't a java question). We need to display that XML to the user in the browser in a print-friendly way. Is there a way to display n rows of the XML, repeat a header, and then display n rows again? We'd like it to appear in a...

I have two machines, let's say Source and Target, both WinXP or Win2K. I want to create a network share on Target, such as C:\share, and call it "share". Then I set its IP address to 192.168.0.200. I connect the two machines via crossover cable. Then I want to go to Source, set its IP...

Thanks again for your help. The code works great to find the right network adapter now, and I have written some modules to change the IP address for that adapter. Now the next step: I need to create a network share on the machine that can be used from that adapter. Here are the details...

Excellent code. The "netconnectionID" is in the properties list for Win32_NetworkAdapter. However, it explicitly states that netconnectionID does NOT work on Win2000 and WinXP. Now that I see how your code works, I can probably adapt it to use the device name and parse the string for the...