Search results

Also, I don't know much about ppt objects but there are times you are working with an "ActiveWindow" object with the dot "." in front of the object and other times you are not. My assumption is that "ActiveWindow" is a property or other member of a "powerpoint.application" and thus, you should...

I was thinking that Colin, but decided that if I changed it, you wouldn't have anything to comment on.

You see, I saw a British comedy show on TV. It influenced my life. And thanks for the vote of confidence!

This is public information. You can get to them via the main forum menu. There are really only 2 active, per my last review night before last.

Why, because we LIKE you!

Create a query in design view, click on SQL view, paste the text I provided above, test it out. Very simple. Or, using your approach, do what you did but right click on the line between the tables and select all tables in tblclients. Then where you have "=null" replace that with "is null".

I wish I were kitty enough to respond. Maybe I should leave the puns to people who do it better.

Wow, hope you get better soon. Pain is not a fun thing to endure.

select * from tblclients where clientid not in (select clientid from ClientCleaner); is one way to do this. Usually, "not in" is notoriously slow if the junction table is large. Another alternative is to do an outer join on the 2 tables (tblclients and ClientCleaner) and check for null in...

Any resolution yet?

You were trying to create a unique number to act as your PK in the before update event (the event that fires when you change data that is already in your table)? Wouldn't you normally do that in the before insert event? Or did I miss something?

I meant to do that (I learnt that from my cat).

We're trying soooo hard, Colin. Welcome back. (Yes, I know i spelt "so" incorrectly. But as a bonus, I did include punctuation and proper capitalization, and used "spelt" instead of "spelled".)

I think that's a separate issue. The "hanging" when posting replies was resolved for me by the ad blocker. The site is still oppressively slow at about the times you've indicated.

They "went bad" because they grew up? Utopian society is easy when it's accomplished in shallow minds. When it comes to real life...

There are "fun" guilds in WoW. The only problem with them is if you do want to do something serious (like raids).

Why VBA? Are you disallowed from using bound forms? Wouldn't it be easier to use a non-Access platform if you don't use bound forms? The error you are experiencing has no meaning. Where does it say it? When? Is there a line high-lighted? Is there an error number? I'm guessing you'll want...

A query will do this for you. Just use a sub-query to find the date/timestamp of the last "Fail" and compare that to the date/timestamp of the main query within the where clause. select stuff, count(*) from mytable where dtstamp > (select top 1 dtstamp from mytable where result = 'Fail' order...

I actually feel kind of bad using this. Serving ads is what generates revenue for this site. But the site is almost unusable with the ads.

Do you take US Treasury Bonds?