Activity Stream

CJ thank you for sharing this neat trick with me and explaining the syntax it makes more sense now! I applaud you! Thank you and Mr. Orange for...

another way is to bind the form to an ado disconnected recordset rather than a temp table

as far as the report.lines are concerned, not possible since these can only be horizontal or vertical. You may be able to with a line control...

You don’t need via, just set the form property.

One way is with an UNBOUND form, lots of UNBOUND controls, and lots of code. Another is input to a temp table and then 'move' records to permanent...

Maybe if you attach the two Excel files it's easier to understand how the data in the first table is obtained because you certainly don't understand...

tanks that is what i want

Attach a sample file so that we can see the structure of the database and consequently give you concrete advice.

ok thanks!

theDBguy has a function as well. http://www.accessmvp.com/thedbguy/codes.php?title=simplecsv

I have a report with multiple subreports. One of these subreports shows a number of entries. Another subreport shows of the these entries broken down...

there are two methods - one is is called 'concatrelated'. There are various examples around, all working off the same principle. Here is a link to...

(SELECT MAX() FROM T1 A WHERE A.<T2. AND A.W_Name=T2.W_Name) is a subquery that returns the maximum allocated date that is less than yourdate. T1...

Hi,Thank you for your help. I have managed to draw the vertical lines using the article you quoted.

Thanks for your help. Subfolders were the problem I believe. Mission was to move a subfolder on Drive F: to a subfolder in a different path on Drive...

Middlemarch, My intent by showing Daniel's article was only that he had info indicating fso.movefolder did not work. I have found a few links...

Rather frustrating, in spite of the claims in that link his routines does not work, at least in this case. It generates error 76 so I added this to...

CJ may be busy, so I'll offer a suggestion. There are several topics and examples at https://www.w3schools.com/sql/sql_intro.asp There are...

Not that I am aware of? You select records, none are returned, so then you just add? I used to use a where 1=0 to get an empty recordset and then...

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...