Recent content by tomasm

I wonder if I had that feature all last year and didn't notice until yesterday. I've noticed some cosmetic changes over the last year with updates but I don't think I had the SQL view feature. Maybe I completely overlooked it for months. Either way, it's great that it's finally implemented.

I just noticed with a recent update [Microsoft® Access® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20336) 64-bit] that I can FINALLY open a saved query in SQL view by right clicking the object in the navigation pane. The absence of this feature has puzzled and plagued me for several...

Thanks, I'll write the full code later. I just wanted to provide the SQL for now to get feedback on my plan. Ideally I won't need to make combo box selections for each query that I run. My example query is just one of several, and I don't want to think about which combo box selections to make...

I'm back after being disabled by the CrowdStrike incident... and I think I may be getting close to an answer to my original question. The first part of the answer is: don't hard code IDs in queries. The second part of the answer is: if you are trying to run UPDATE queries to change foreign...

Yes, I will fix the tables. I agree that it needs to be done. I understand the StackOverflow question but not for the scenario given in the question. Maybe I understand the question because my ideas about table design are wrong. It wouldn't make sense to assign equipment to users with an...

Attached is a screenshot of my Relationships window. One main table with six lookup tables. No parent/child relationships. Until recently, I had only one dollars field and one positions field, and an additional field to identify the fiscal year for dollars/positions. I removed the fiscal...

I see that happen when the list of values is too long. I think you can increase the number allowed in Access options.

Yes, pasting in continuous view or datasheet view works correctly as long as the number of columns is the same and field types are the same. The data is stored in the table that the form is bound to exactly as it should. Now that I know datasheet column names (and other things) can be...

That's what is stated above but I haven't tried it. I think I'd rather specify names per form anyway. I wish I saw the Datasheet Caption property a long time ago. You can have short, non spaced table field names but long, spaced datasheet names in the form. Customizing the appearance is the...

I never noticed that form controls have a Datasheet Caption property to display whatever you want in the datasheet column heading. That's huge. Column names might be the biggest reason for me using continuous forms instead of datasheets. Now that I know how to customize datasheet column names...

If I paste multiple rows from Excel into a continuous form, and the first row copied from Excel does not contain the matching field names in the form, I receive the following prompt: "None of the field names you pasted onto the clipboard match the field names on the form. Access treats the data...

What is the difference between the three Set lines below? Dim db As DAO.Database Set db = OpenDatabase("C:\Northwind.accdb") Set db = DBEngine(0).OpenDatabase("C:\Northwind.accdb") Set db = DBEngine.WorkSpaces(0).OpenDatabase("C:\Northwind.accdb") And should either/both of these lines be at...

Back again with more notes to add. I wanted this powerful form filter to be even more powerful for my forms so I made some changes to make the button pictures show that a field is sorted as well as being filtered. Four more pictures are needed for a total of six. I'm using these images and...

Another note to add: If a field name contains the name of another field then the button picture will change unexpectedly. For example, if you have a field named Spool and another field named SpoolSize, whenever SpoolSize is filtered, the picture for both SpoolSize and Spool will change to show...

I see now that your class version uses the Form_Current event to check if the filter is on and update button pictures accordingly. This must be what you meant in a previous post about fixing a bug in the original. I prefer the simplicity of MajP's original because I understand (mostly) how it...