Recent content by Harry Shmedlap

Thanks for the reply. The application is registered and I successfully changed that application property from inside an access (2007) regular module using the syntax: Dim CESApp As Ces.Application Sub CES_Init() Set CESApp = New Ces.Application CESApp.XprobeMode = True End Sub...

I have a reference to the external application's dll. How do I write an event handler in Access VBA to be fired when that external application generates an event?

The table is already given and cannot be changed. The question is how I can solve the problem using a query and joins using multiple copies of the table.

Given a table with 3 fields for people, where each person can be either Curly, Lary or Moe, and 3 fields for chairs, where each chair can be either Blue, Red or Green. Here are two such records: Per1 Per2 Per3 Per1_Chair Per2_Chair Per3_Chair Curly Lary Moe Blue Green Red Lary Curly Moe Red...

You left out the DISTINCT keyword in the first line but once added it works. Thanks!

Thanks to both of you for your replies. WayneRyan - I did this method successfully at first, however my end goal is to have a single query that I can use in Excel, and this method calls another query. ByteMyzer - very cool. Thanks for the idea. It works. 1) What is your modified SQL that you...

I have a list of resistors which I want to ensure that each unique value has only one corresponding part number. Here, for example: Reference Value PartNumber R1 100 Z1 R10 800 Z5 R2 120 Z2 R3 100 Z11 R4 300 Z3 R5 150 Z4 R6 800 Z5 R7 600 Z6 R8 100 Z1 R9 100 Z1 we see that the value...

I still don't see what determines which query is the nested one? Especially if you say that both take place at the same time? Perhaps I don't understand the term "nested" in this context.

Thanks for your interesting response. Here are some followup questions: If "brackets have no meaning towards executing it first" then: 3.1) Why are brackets used when there are two or more joins? I have found that the query just won't work unless I have at least one set of brackets...

Thanks for the response The examples are clear but the explanation at the end isn't. 1) Its not clear by what you mean by "F = H <= G Right join". Is this some kind of database "algebra"? What does it mean, in words? 2) In your explanation it seems like you are doing the same thing in both...

It seems to me that one join-related failure in an Access 2003 query is when one of the fields involved in the join has null values. One way this happens is if an outer join is followed by an inner join. For example "F LEFT JOIN G" will produce full field values for both F and G fields, only in...

I copied your "k:\data\someFile#ref02.doc" into the Address box of the Edit Hyperlink window and it gave me the following error: Unable to open %22k:\data\someFile i.e. its still chopping off the all after #, thinking its a subaddress. Any other idea? Thanks

The # character in a hyperlink is used to separate hyperlink parts. Here is a case when I do NOT want this character to do the separation: a network file where the # character is part of the filename: k:\data\someFile#ref02.doc. How can I put this URL into a hyperlink field in a table and NOT...

I don't see that comment on Allen's website. Where do you see it?

The above great article on the Allen Browne site has one problem. I don't know if someone has posted it before but if the lookup is text rather than numeric then search is not found. Here is a modified version: Sub Form_Load() Dim varID As Variant Dim searchString As String varID =...