Recent content by Nevermoor

It means they return 0 results (unlike the 3rd one, which works as expected).

Thanks r937. For whatever reason those first two options won't work, but the third one did. It's a small enough database (~1000 employees) that I can't imagine the inefficiencies are worth worrying about.

Does it work if you change it to 'I''ll tidy up and everything.'?

I have two databases "Employees" has names and ids, "Events" lists specific events and has a column that can contain employee ids. I want to select a list of employees from the "Employees" table limited to only those who have been associated with an event. I thought the syntax was "SELECT *...

I actually just got clearance to cut out the subtotal sheets, so the grand total just works. The problem was that the subtotal sheets would sort, but the Name value in each row of the grand total sheet was fixed so it would become disjoint with the rest of that data row. It isn't elegant but...

Sorry. Just posted over there, but I put it here b/c I was hoping there was a simple Excel formula that would copy over the formula.

I have an aggregation workbook, which has a number of worksheets with rows of data like: Name, value1, value2, . . ., globalsort globalsort is calculated on these pages to allow ranking in aggregation. As the values change (thereby changing the globalsort value), the subtotal and grand total...

I have an aggregation workbook, which has a number of worksheets with rows of data like: Name, value1, value2, . . ., globalsort globalsort is calculated on these pages to allow ranking in aggregation. As the values change (thereby changing the globalsort value), the subtotal and grand total...

That's the ticket. Thanks!

I'm trying to do things somewhat differently, I'm attaching my database to help explain, but I guess I don't really understand why my way can't work. I haven't done much with Access before, so I'm running on general VBScript / SQL experience. If I'm doing something fairly simple...

No dice.

I have a database with three tables: cases, firms, and manymany. Each case and firm has an autonumber key. manymany allows a many-many relationship by storing a case ID and firm ID in each row. When doing data entry, I want to enter some data about the case, and then associate firms with it...

I figured it out. The company that we registered the URL with (GoDaddy) was serving our page in a frameset, so I needed to go in and replace every call to window.top with window.top.frames[0]. Siiigh.

Turns out the problem was that I wasn't using disconnected Recordsets (I thought the Static flag was enough but apparently not). Load times are now <1second instead of >1minute. http://www.4guysfromrolla.com/webtech/080101-1.shtml If anyone has the same issue Thanks all for the input!

Sorry, I was just typing in the question lazily. On the page itself there'll be an input like <input name="metricStr" id="met115" value="Str1_COMMA_Str2" type="hidden"> And in the page contained in the iframe there'll be a call like var inStr =...