Search results for query: *

...of available programs. But when I actually double-click to open a JAR file, it says the file is "not a valid Win32 application." If I rename the *exact same file* to *.ZIP, it works fine. Any help? No rush on this one, but it'd give me great personal satisfaction to solve (and I've been...

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

...Table 2 ADDRESS NAME wacker chicago main miami broadway dallas 2nd new york I'd like the query to return a "table" that shows me the info for each pair of names, i.e. INFO SOURCE_NAME DESTINATION_NAME red miami dallas ************ RudeJohn ************

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

...name for both the SOURCE and DESTINATION address. Here's what I have, and it's not working: SELECT A1.Info, A2.Name DESTINATION, A2.Name SOURCE FROM ExportData A1, Addresses A2 WHERE A2.Address = A1.Destination, A2.Address = A1.Source; Thanks in advance! ************ RudeJohn...

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

...struct { unsigned char var1[6]; unsigned char var2[6]; } MY_STRUCT; Now, I'm pointing this struct at some hexadecimal data. MY_STRUCT *tmpStruct; tmpStruct = (MY_STRUCT*)ptrWherever; My question is, how can I reference the items in this structure and print the hexadecimal results...

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

...time removed. Example: C2 has the value "1/6/2005 8:00AM" I want to have the value "1/6/2005" without the time after it. I'm not talking about *display* (which could be handled by formatting): I need the actual data to not contain a particular hour. Here's what I came up with, but I'm...

...rowNum SomeFunction(i) The code above doesn't seem to work in some cases. Furthermore, what about the same situation when it's a RANGE? How do I *create* range and cell objects to work with? How can I iterate through each cell in a column that has data and manipulate the formulas inside...

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

...End Sub I'm getting myriad "object required" and other such generic errors. I'm sure it's due to a lack of understanding of the basic concepts, but some clarity would be greatly appreciated. How does .Value work? What about Range objects? TIA, RJ ************ RudeJohn ************

...in a nice report format. I don't need code samples; general advice would be greatly appreciated I referenced thread426-792729 but didn't find any specific help (I'd rather stay away from Crystal Reports and .NET is absolutely out of the question). TIA, RJ ************ RudeJohn ************

...share say "everyone" has "full control," which is good. What I really want to know: Am I missing a step? Is there something else I should be doing? Logically, am I SUPPOSED to be able to do this? Thanks in advance, ~RJ For reference, see: thread222-1069201 ************ RudeJohn...

...I realize this MAY be a networking question, and not a Visual Basic question, but I have the utmost confidence that one of our resident geniuses will be able to help me. :) Thanks a TON in advance, I know this is a long question and lots of work... ~RJ ************ RudeJohn ************

...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 vendor name. Thanks again and I'll come back if I have any more questions. RJ ************ RudeJohn ************