Recent content by MajP

@isladogs, this should be updated on your site. It is no longer up to date since at least 2013. At a minimum after 2013 both the GUI and VBA could create 50 FCs. However, I think based on some reading it could have been in 2010 as well. At a time there was a bug and not a limit. You could...

I find it really hard to do this using parameters in the queries, and always find it easier to do this with sql strings in the code. Especially when you have more than 2 lists/combos. This way I can make a single procedure to filter and call that procedure from multiple events as needed...

I added to this demo so you can compare and contrast the other methods. Rich Text Conditional Formatting Detail OnPaint To make the new demos work I added a field lngColor to the categories table. When you select a color it saves both the rich text as well as just the color value. 1. By...

Are you concatenating with a "+" instead of a "&"? Please show the function, if not no one can guess at the cause.

https://www.access-programmers.co.uk/forums/threads/ms-access-custom-control-built-in-another-language.307414/post-1646046

I do not get this statement. Yes you would select all the controls and apply the rules. However this should take 5-10 minutes and be done. Not sure how you are doing CF, but clearly you are doing something wrong because this is a trivial thing to do in CF.

I would look at possible corruption and do a decompile recompile https://www.fmsinc.com/MicrosoftAccess/Performance/Decompile.asp

But you understand why this makes no sense? Public Property Let PropName(NewValue As Long) Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("UnionQueryName", dbOpenSnapshot, dbSeeChanges) mPropName = rs!FieldName rs.Close End Property You have a property with a required...

One more thing. A get without a set/let can be written as a function and I know of no difference. You end up calling it the same way. Private m_RS_Products As DAO.Recordset Public Sub Initialize(QueryName As String) Set m_RS_Products = CurrentDb.OpenRecordset(QueryName) End Sub...

In your example there appears to be more than one record unlike my example. In that case you may want a getter without any class variable. No need to store those values because they likely change every time you are getting them. Private m_RS_Products As DAO.Recordset Public Sub...

I think it is correct. The point is that Lets/Sets and Gets have to have matching signatures and yours does not. Your let is a long and Get is a variant (no specified data type). Public Property Let PropName(NewValue As Long) ' Let is a long End Property Public Property Get PropName() '...

I know that people have been raving about some of the home grown Gantt Charts for their capabilities, but when I was doing this I did not know about this or likely they did not exist yet...

Can you explain more where you get your choices from and how large that is. I do not really understand what you mean by unloading. The demo creates an ado in memory recordset, reads and loads the data into the recordset, and then binds that to the pop up form. I could envision that it might...

There is absolutely no issue. I have worked with Project and Excel and Project and Access. No different then working with Access and Excel or Access and Word or Access and Outlook or Access and Power Point. Automation is automation. Only potential issue is that the Project object model is...

If it is slow loading and unloading you may be better off with building a temp table instead of using the in memory ado recordset. The version I demoed has to read the data and loop it to build the recordset. If those selections are already in a table bound to a form then loading will be...