Recent content by MajP

What you were trying highlights several other learning points 1. As mentioned do not store calculated data for many reasons. It is so easy to get out of synch from the true value. You have to make sure every change in the data reflects in the calculation. If you are doing a roll up then every...

Here is a form demo with the concat and search in one. This is basically the same approach as Ken's just packaged differently. If you search for both Plumbing and HVAC If you want either plumbing or hvac

To be clear you want to search for companies meeting more than one criteria. For example return all distinct companies that do both HVAC and Plumbing? You can do that in a query but to build a search form to do that you will likely have to generate the sql string in code. I assume you would...

I think if you went with the left join suggestion it would need to add the inner join to equipment. Something like. SELECT * FROM qryActiveUsers as t1 LEFT JOIN (SELECT UserID FROM tblAssignedUsers WHERE equipmmentID = [forms]![mainform]![equipID) AS...

@CJ_London, I do not think that gives you anything. TblAssignedExaminers is a juntion table with UserID and EquipmentID. That will give you users without any equipment not users who are not assigned to a specific piece of equipment.

Because we do not see the real tables I will assume you can make the query qryActiveUsers which returns something like UserID,EmployeeFirstName, EmployeeLastName, EmployeeID .... Something like this if the main form is the equipment Select * from qryActiveUsers where UserID Not in (Select...

Thanks. Was not familiar with that. I will edit my post.

A treeview is an ActiveX control in the MSCOMCTL library. Similar to when we call the subform control and the form inside the subform control a "sub form". Even though two different things. There is the treeview activeX control of class (Access.CustomControl) and then the treeview object...

Same here. I cannot get an error.

Can you provide the backend?

According to chat -2147352567 error is actually a bug with NZ But my question is how can the subform have records and have record with a null ID. The only way I can think that is possible if it is on a new record. So I would have it move to the first record in the subform if it is null. So...

It appears the flow is going in the opposite direction. My guess is the main form selects a location and the the sub form is in use items in the selected location. The user selects a location and if that location does not have any items the location node is selected. If the location has in use...

So that does sound like a timing issue, and do events would be my first guess to. Often the fixes for timing issues are unexplainable. Like changing to focus or simply putting in a debug.print. Often figuring out where to put the dovents is also tricky What is the real error? My guess is when...

If I read this correctly it does not have to do with the treeview but has to do with reading the ID of the current record in the subform So the question is why would the subFrmItem.itemID return no value? Well that code should never work because a subform control does not have a field. The form...

Example Post in thread 'Programatically change color on continous form conditional formatting' https://www.access-programmers.co.uk/forums/threads/programatically-change-color-on-continous-form-conditional-formatting.323250/post-1827631