Activity Stream

Thank you Peter - this worked. I had done this, but for whatever reason it worked the second time.

Than k you so much - even though I had done this, I only needed to (again) delete and re-enter.

Thank you for your time - it was as simple as deleting and re-entering; which I had done, but clearly needed a bit more nudging!

I think what he's trying to say is: he has a file at "C:\Users\Test\Documents\SomeFile.xyz" when he runs fso.FileExists("Somefile.xyz") he is...

The last update to VBA was in Access 2010...so the answer is yes If you mean will an ACCDE file that was created in A2021 run in A2019, then almost...

I don't understand OP's original question. I tested function. If path does not include a filename, I get False. Same for empty string.

Using a ZLS will still return a false. MsgBox fso.FolderExists("")

What you describe is called 'cascading' or 'dependent' combobox - a common topic. Review: ...

I am new to all of this. I have created the continuous form and binded the query to the combobox. I need help with the formula.

Me!Field2 = Me!Field1

We were Glad to help

Access isn't best tool for this. For such tasks, you need to use recursive queries, which aren't supported in Access. Recursive queries are...

if i'm reading your question correctly, you need to test s_path for zls Function fileExists(s_path As String) As Boolean Dim obj_fso As...

I would recommend that you step back and make a rough diagram (30,000ft level) of all the things (entities/probable tables) that are involved. Also,...

There may be some useful info in the Similar Threads at the bottom of this page. Bill of Materials is described quite well here to assist with...

To Vikgarden: From my first actual doing just a couple of minutes ago, create your Master/Blank Report, and then drag the sub-report(s) onto the...

Thanks Micron and Mike, I am going to mark this thread as solved. I was able to take a look at the resources Micron linked and the database Mike...

Shame you don't actually try some of these suggestions and understand how they work. I suspect the only way your function has worked for you up up to...

IMO, it's a hack for an improperly designed db. Subform/subreports are for displaying the many side of one to many relationships, not for fixing...

@June7 & CJ_London I reviewed both articles, they are interesting, but not my situation. My function just reads a sequential number from a table,...

To Micron: Why not sub-reports from individual queries? I have seen sub-reports side by side in other threads that I have read. Also probably want...

Thank you so much!!! I was hoping for an easy solution. I'll play around with it some more.

You should really have stored the Case manager ID (Unique code) against the Roster rather than the case managers name. I can't see how you can do...

Thank you. I will definitely play with that and see what I can come up with

Why not sub-reports side by side? In reading through parts of this forum, I've seen sub-reports side by side.

Someone said 5 because the "practice" database has five. Basically, if you look at the database, on the Form that opens, there is a button that says...

Agreed the number should be 7 not 5.

I think you will first need to make 5 queries - each where you include the linked fields of (a) case manager and (b) client's last name, or since...