Activity Stream

I was considering the data set in the first one to be a different domain because a) it's a query, which AFAIK is a domain and b) while it is selected...

Both appear to be TableT to me?

They are based on different domains? Not using code tags to maintain indentation might have caused you to miss that? Or maybe I've missed something...

No need to set rs again, just AddNew

see if this helps you at all http://allenbrowne.com/AppInventory.html

I wouldn't doubt that custom classes would be the way to go with much of the things that TWG is trying to do. Custom events, form instances, etc.

Hi CJ_London its me again ))) What you gave me worked great thanks again. I am bothered that I cant figure out what you did. Do you mind...

@CJ_London, i just wanted to say one more time that your my hero today. Thank you for helping me out.

CJ your da man! I appreciate your help on this.

go into table design, select a field to be indexed and check - select from the dropdown the type of index required You can see what fields are...

This idea worked for adding new records but I was confused trying to put a WHERE statement into that.. I used a record set. Ex. Dim...

@ CJ_London Thank you I think that worked. I dont really understand what you did to make it work but thank you. I dont think I would have figured...

still haven't seen what outcome you actually require but to determine the relevant record from the first table in relation the date in the second...

See this article by Daniel Pineault.

Finding most recent Date is quite a common request. See the links in Similar Threads at the bottom of this page. There is an example by PBaldy here.

No, I was just curious about that tool you mentioned.

Excellent. Did you see the code I posted to do this using VBA?

@CJ_London, Here are the two tables. Take a look it should make more sense to you now. what I am trying to do is to multiply the two tables out...

Note that Name and Date are reserved words and should not be used as field names - give them a name that would be unique across the whole app such as...

@CJ_London You are correct i brought in the tables from excel into access. If you know of a way for me to format them for Access please let me...

Look at the Max() function

not clear what your data represents, but you need a username field and a date/time field, both populated when the record is created - so when you...

suggest show the result you want from the example data you provided since your description is not making sense to me at the moment. Initial...

Typo - sorry. I've corrected my original post.

Hi Colin, Gunter responded to the mailform and advised it is a false positive.

That might work, but what do you do when abbreviations are repeated? What if a band name is "Lean Ground" and another "Luna Grande"? I'm making that...