Recent content by TXWizard

Thanks much. I appreciate your comment about the brackets, which would be less bothersome if I made a regular practice of writing my own SQL. I thought I'd left out an INNER JOIN clause, too; good catch. :) As I thought further about the matter, I decided it would be best to move all these...

In an Aceess 2000 data base, I have two tables, CUSTOMER and tblMonthsOccBrackets. Table CUSTOMERcontains customer daata, including the number of months that each customer occupied a rental unit. Table tblMonthsOccBracketscontains ranges of months (brackets) into which I wish to group the data...

I know all about FindExecutable, and have used both the 16 and 32 bit versions of that function for years. Like you, I was looking for a way around its limitation. As it happens, I have a file of the correct type in the package for which I am writing an installer. I'm writing an installer for an...

I agree, and that's one of many reasons that there is a way to do it in code. Here is an example from production code that I just finished last week. The task at hand is different, but it will give you the idea. Dim adoConn As Connection Dim fldCust As Field Dim rstCust As...

I came here looking for working examples. Finding yours, I changed the arguments I was using to match yours, since I was getting zero, but also no data (a null-filled buffer and a value of zero for pcchOut. With those changes, I am also getting -2147024894 on XP Pro with Service Pack 1. Have...

OOPS! I misread it, probably because I was thinking about Access at the time. :(

You're preaching to the choir. <G> My point was that the original poster seemed unaware of the need to declare column names unambiguously when you are working with two or more tables that contain like named fields.

What Median function. Not in my copy of Access!

To reference fields in two tables, you must use unambiguous names, fully qualifed by the table name; e. g. CUSTOMER.LastName. However, if it's the field NMAES that you want to compare, you can use the Fields collection of the Tabledef or Recordset object.

I'm puzzled. There is no such thing as a &quot;double integer&quot; in Microsoft Access. There are Long integers and Double Precision Floating Point, however. I just finished coding up a generic function to derive the median of any value. AMOF, since a Double is a 64 bit floating point number...

Noticing your use of the Match method of the String object in the example in the last post, I'm wondering if you can offer a suggestion about why the following code is not working. window.alert ( 'purl = ' + purl ) ; ourl = new String ( purl ) ; // Create string object for testing...

Excel can save as CSV directly. Then, <b>server side</b> script can read that and format it into a table. The XML that you get from Excel has so much extra goop in it that it's virtually useless. :-(

Start with http://devedge.netscape.com/library/manuals/2000/javascript/1.5/guide/regexp.html#1008506, which is part of the Netscape &quot;Bible&quot; of JavaScript.

<!-- BEGIN 1024-bit WEBSITE ENCRYPTION oh498349hog9py34hp9ywoiropuywe984ytoihrgg8 I love it! :-) At last, a programmer who can make a point with humor. That's a sign of a REAL programmer.

I think the local drive is supposed to be off limits to the JavaScript sand box. I certainly don't want some stranger's script snooping around on MY hard drive!