Search results

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

Is it only slow when scrolling and searching? Or does it take a long time to load and unload the control?

Thanks. The purpose of this demo was actually to demo the principle of "Composition". Composition is where a class contains instances of other classes to provide more advanced functionality. Someone originally asked about building a "Speedometer" or "fuel gauge" control to show completion...

If this is Latvian do not use any non Latin characters in any property or name of any object. This will make it almost impossible to get further help from most people on this forum. See issue...

My guess is that this was may have been added to keep compatibility with Sharepoint. These came out the same time attachment fields, and multi value fields came out. These features all seem kind of superfluous in Access and not well adopted. In Access you have queries and subforms but those...

I think the correct statement would be even narrower. Calculated fields in a table support a subset of Access SQL functions and operators. So the \ operator is a Access Sql operator AFAIK, but for some reason not supported. Supposedly Mod is Access Sql and does not work The question is what...

I did check it and it is in the expression builder and does not work. The expression builder is somewhat limited but there are still functions it shows that are not supported.

Table level calculated fields do not support UDFs.

I tested FIX and that works. That should give the same results. Mod does not work either. Also INT works. And since you will always have positive values it is the same as fix, /.

I tested it in the most recent version of Access and get the same issue. Says I cannot use it.

I just doubt this design makes any sense If you need a single class as a helper that all subforms can use then in standard module you have a global CA and CB. You can use CA as your factory to build CB. You can make these predeclared as people have been describing. But if you are declaring...

Going back to what I said in the first thread. If class A is the only thing holding a reference to class B you have to access it through Class A. But since an instance of A is intantiated in a subform you have to reference A through the subform. I added accessors in class A, but not required...