Search results

Thanks, It was interesting, and the info on how google has changed is very helpful. Unfortunately, I think I have a good quality steak but no "sizzle" to sell it. Can't even write a book anymore. Killed by AI, Google, StackOverflow, etc.

Thanks for your comments. They express a lot of the concerns that made me decide to post here and see if I could get any creative ideas. (This is still the best Access forum that I know of.) Thirty years ago a web site with a pay button is what others did. From what I can tell, only a few...

Over the past 30 years I have collected 400+ objects, and over 30,000 lines of access VBA code that I call my "standard code". I've also written some Access Addins that I use in my development work. Some are very simple, one is pretty complex (I use it to export database code and objects for...

This is an old thread, but if you set the default value of the YesNo field to 0 or 1 The Access Form Wizards will add the field as a check box to forms. When there is not a default, or the default is No or Yes then it will add it as a Text Box. (Not sure if this is true for SQL backend, but it...

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.

There are two columns, and all of the pairs are "pairs". Including the last one. If I step through the code, I can print the rowsource in immediate mode and it is correct. But as soon as I hit F5 and go back to form view the last value does not show in the combo. That's why I added the...