Search results

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.

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?

IT WORKS!!! Amazing.

I just re-installed it. And the verdict is:

I honestly don't believe that removing ads will fix this issue.

Spam in post #2 reported.

Let us know if you have questions. Be specific!

Yes. It is called an associative or junction table. That is how you implement a many to many relationship. You'll put the junction table's data in your subform(s) as Pat did, with look ups into the other side of the M:M relationship.

Well, did it work?

I answered your question on your other thread. You really don't need to post on the same topic on more than one thread. A possible reason why you haven't had an answer is that your description is a little verbose and doesn't really indicate what you're having problems with. The thing you are...