Search results

Hey @MajP, this is my curiosity and not a specific issue, so I didn't want to make a new thread--but can you elaborate on this "cascading combos" concept? If you have a demo database I'd love to take a peek.

Thanks a million, knew I'd done this before somehow, couldn't find it. Solved!

Hi all, Is there a way to make the dropdown width on a combobox wider than the width of the control itself? I'm not referring to the column widths--it seems like if you set them wider than the control width, you end up with a scroll bar on the bottom of the dropdown. I'd like for the dropdown...

Yeah, that was my issue previously--it would appear (I'm not sure) that if you just alias the column name in the query, the caption persists in the datasheet view. I ended up doing it at the control level rather than the table because I need a different caption here.

Lol I totally missed that. I was looking for "Caption" and totally skimmed over "Datasheet Caption" every time I looked at the properties sheet. Little things. Thanks again!

I'll add for anyone else that stumbles across this: your column names on the datasheet are the control names. Key takeaway from that article is that datasheets are just forms, and many of the properties of them are configurable just like any other form. Name your controls what you want the...

You da man, @MajP !

Hello all, I have a form used to select various employee and process training records. One half of the bottom of the form is a subform displaying the trainings that we "think" should be needed. It uses a complicated query to link employee names and job titles with what training we already have...

Hello all, Trying to figure out how to configure two parts of a subform that I'm displaying in datasheet view--making the column widths persistent, and customizing the column names as they appear on the datasheet. The recordsource is a query that's an amalgam of various joins from several...

Just popping back in to add-- Looks like any standard fields in the header or footer will break, throwing the "Multiple ..." error. Not just calculated fields. Calculated/expression based controls in the report details also break the report, though instead, you get a #Value or #Type or "Error...

🙏👍

Proud to be a trailblazer, even if the trail goes off a cliff... Yeah, I pull the subquery out, and it works. But I can't figure out a better way to do it without a subquery. Some folks here were kind enough to help me with that initially a few days ago--...

Hi all, Any idea why I get this error when I go to create a report off of the query in question, but the query otherwise runs fine (ie, I can hit "run", and look at the datasheet view of the query, no error. Base a report off of that query, go to run the report, above error. Copy the query...

Elaborating here: you'd pass the results of the DMin function to the datevalue function, eg: =DateValue(DMin("[YourField]","[YourTable]")) DateValue explicitly truncates times from date strings. Note that for what it considers to be "invalid" times, it throws an error, and I don't have enough...

That was my initial thought too... but no, 160+ employees, 27 SOPs. Weirdness. I'll talk to the "powers that be" with respect to the lookup. I've found it immensely annoying on a number of occasions, but I didn't build this database, so I'm not sure where it's plugged in that removing it will...

Hi Plog, Good question. I would prefer the second column of the query display as process, but for whatever reason, the caption from tblTrainingRecords is used instead. Unfortunately, I can't recreate the bug for further inspection at this point-- after I deleted the filter from the properties...

Hello all, Wanted to share something that I'm running into in the hopes that one of our experts has run into it before. I had seen inconsistent result sets out of a query I've been tweaking today. Sometimes 3640 results, sometimes 247520 results. Those are precise numbers, and I can't figure...

Following up here to bump and request further assistance-- My final version of this is slightly more convoluted than @MajP (due to the lookups) but appears as follows: SELECT Tr.trbpnumber, Tr.trbpEmp, Tr.trbpdate, Tr.trbpTrainer, Tr.trbpNotes, (SELECT TOP 1...

Fair enough... One thing I love about SQL is that there's always an alternative approach if you want to get clever enough...

Oh, that's much smarter! I was looking at a bunch of joins (ie, every training date with every revision date) and then trying to select only the correct revision dates, but this is a MUCH better approach. I'll leave this as open for the moment while I put this into implementation, but I think...