Activity Stream

I vote for the sql/query option as well. I don't see anything in that code that distinguishes between one user and another, so everyone's value...

Does your back end have a table that contains the path(s) for all tables that would need to be linked? That's where I'd get the paths from then run...

This is Access 2016 as your info shows? Older versions required a reference to DAO but 2016 should not. I've never multi dim'd on one line like...

docmd.openquery "quUpd1Field"

make a field BLOCK in manager table , make query qsBlocks that shows Person, CoD , and sorts the Person the code below will scan the list and...

This a classical example of poor design! You need an employees table, where every employee is registered with unique ID. And tables like...

That worked!! Thanks so much!

nnn, Some clarity please. You say "changes done to the form" which sounds like design changes to a form?? Typically an audit trail is for...

I just tried a report, and now that code that used to work fine, failed with the same compile error. So it might be something elsewhere that's...

I am surprised that the "d" in DAO.database is in lower case. Typically when entering vba code, intellisense will be invoked and that "d" will be...

Run some code to collect each persons Codes into a single field, tCOdList then in Qry A, remove COD field, join tCOdLIst on QryA.name.

Possibly. But readers need to know the structure of your tables, and it would be helpful if you provided the queries involved in your "a tedious...

I was doing fine, got the background colors to change in reports as I wanted based on post #6 Then I started adding code to do the same thing in a...

You understand correct, and thanks for answer. When (and if) any modification is required, I will work with the interface only (FE). Then I will send...

you need to clarify - you said 're-link tables in a front-end database from the back-end database.' and When the database is open, the system should...

Thanks. In the attachment relationships are not set, but I am checking my app that it is done. I am removing lookup fields from any table.

Not thought to google? :( Allen browne's site has some audit trail code, another person is martin green I think....

Self explanatory really. Show your concat code. I suspect you will need to qualify the field with the table name?

You should not have comboboxes in tables. They are lookup filds and not reccommended.

Tables should not be using lookup fields. Just because you can, doesn't mean you should. I looked at your db and no relationships set, so cannot work...

I find it truly frustrating that what I applied works for a while. Then later it fails again without changing any code or design. This challenge is...

Here's a quickie. It updates the table directly. Option Compare Database Option Explicit Private Sub cmd_updateYES_Click()

Thanks June7! So I added the module as described and then I added the following code in my query (thinking it was going to work perfectly) ...

Review http://allenbrowne.com/func-concat.html

Yes, purpose of database is to store and manage data. However, it is usually bad design to save aggregate data, especially if there are no records to...