Recent content by Royce

It is a Microsoft Bug!!!! This explains more: https://stackoverflow.com/questions/26373328/linkchildfields-and-linkmasterfields-being-automatically-set-when-changing-recor Adding the reset of the Links, even though they appear to be blank, after setting the RecordSource fixed the problem...

It gets called from cboLookup_AfterUpdate(). debug.print prints this: fsubImportContactMatchPotentialDuplicates True True SELECT * FROM ImportContactMatching WHERE FedTaxIDorSSN = '167-44-6727' AND ImportContactMatchingID <> 65643 1 I have modified the code slightly (hard...

I have a form on a subform on a subform. The Master and Child Links are null. Filter On Load is off, as is the filter, and the filter is blank. The code below sets the recordsource property to a SQL string. I can copy the contents of strSQL to a query and one record is displayed. The...

If a large architectural firm has dozens of Architects, and different ones will be assigned to different projects from time to time, and you need to know "which architects are assigned to this specific project" then you need a ProjectArchitects table that with ProjectID and an ArchitectID...

There are several tables. The main ones are DBObjects, which has one record for every form, report, query, table, or module in the actual database. DBObjectDependencies, which has one record for every object that the main object needs for it to work. e.g.. A query won't work if the tables...

:D or as we used to say LOL!. I did notice someone mentioned Excel, but I ignored it. This has nothing to do with Excel. No wonder your head hurts. This project is used for building databases from an Access Model database that has a whole bunch of forms, reports, queries and modules. Think...

DESC stands for "Decending", the default is Ascending. Descending is sort order 10, 9, 8, ... Ascending is sort order 1,2,3,4,... As to the actual implementation, a lot depends on the specific details. In other words, I know enough to know there is not enough information to give a definitive...

I looked at the database and frankly it's a mess. Do some studying on Normalization, (another post has a couple of links. If you can find an old Litwin & Getz book on Access development I still think it was the best around). Normalization does take a bit of work to get your head around. In...

The problem with "real types" is I am using the invented value for a phantom object that never really exists. There is no corresponding object in MSysObjects. In a sense, it is a "virtual" object, but I'm not sure that is the right word either. The closest type would be a "container"...

The point is using a custom type number greatly simplifies my application code in this specific instance. I have used the standard types many times in many different databases, all the way back to Access 95. This is the first time I have ever needed a custom type. However, using it means...

I'm going to use the -30000 until I find a reason not to. I have a reason for it, which I spelled out in some detail in one of my other replies. This is NOT a typical usage of the ObjectType (Type in MSysObjects). It is a special purpose table where I have a need to include "custom types"...

Setting the "Inherit Value List" to No fixed the problem for me. Thanks!

I discovered it works fine if the control is unbound. As soon as I bind it to the field it breaks!

Strange, that is where my code is being called. I tried Access 2010, and 2016. Same problem with both. Did you include the -30000,WKSSet pair?

My actual code looks more like what you have. A string is passed to trusted, long used and debugged function that uses the .AddItem property, along with a variable for the # of columns. I posted the simple code to make it easier to spot the error.