Recent content by Philocthetes

Oh, that was just me waxing on about my growing trust issues with today's over-networked, under-tested software environment. I'm in a heavily managed enterprise setting and the number of unknown interactions between 'products' and 'services' is surely incomprehensible to most human minds; my...

Thanks for the pointer, Gasman. Good point to think about nulls, arnelgp, but values are required for the field I'm working with. I'm getting closer to expected results, but 365 is so 'helpful' sometimes that I'm rarely certain the SQL I see is being run as I see it...

Hi, all, I'm trying to pull rows where the string length in the target field is less than 10 characters. I thought this should work: LEN([TABLENAME].[FIELDNAME]) < 10 entered in the Criteria row for the target field. Access 365 puts "" around the number 10 and yields no results. All the...

Hi theDBguy. I think your 03:55 post came to me by mindmail. I added a stripped-down version of my database to the shared folder linked above, went to post about it, and found your request. The working form is Track_Catalog_Work. To test it, filter by form, enter 025210211 in the Catlog ID...

Yes, the main record is there. On my other forms with subforms, filter-by-form on the main record functions regardless of whether related records for the subforms exist.

I've not had luck yet with filtering from a subform, but when the master and child fields are linked properly I have no trouble filtering a main form and having the subforms pull the related data. I don't think I have enough forum juju to post caps, but I put a snap of the problem form in...

I have built an Access 2016 form that included 3 subforms (I've deleted one while stabbing at a solution). The feeder query for the main form includes 4 tables, one of which is an inner join. The subforms pull data directly from single tables. If I use the form to simply page through...

Hi folks, I'm trying to build what I thought would be a simple update query. The update source is a SQL Server table connected as a dbo object. My query reads: UPDATE UberTable INNER JOIN dbo_DPS_ItemWide_Recent_95_Days ON UberTable.[Bib ID] = dbo_DPS_ItemWide_Recent_95_Days.BibID SET...

By Jove, that did it Ridders!

Hi Ridders, Sorry the table came across like crap. It looked fine in this WSYWIG. I can't use a fixed character number because the Degree strings are quite variable. Unfortunately, the source I was given lumps all degrees into one field, so some rows have only a single year many have three...

Hi June7, The Degrees and Year columns are from my dataset. the Match column looks how I wish I could make it look. I'm hoping for code to tell me whether or not the value in the Year column is present in Degrees. Degrees Match Year MS EG 1949 Yes 1949 BS...

Hi folks, I've got a pair of fields in a table and I want to ID all the rows where the string in All Degrees includes the number in Year_Published. The stabbing around in the UI and Help leaves me thinking it might not be possible with an expression and maybe I need to use VB?

Thanks, jdraw.

Hi folks, When I try to step through the code below, I see get "Compile error: Next without For." But I have a For line. What am I or the compiler missing? Dim Titles Dim Counter As Long Range("A1").Select ActiveCell.Columns("A:A").EntireColumn.Select For Counter = 1 To 941...

I'm running a large-scale book digitization project and most of our work will be destructive, cutting books to run them through sheet-feed scanners. An unknown subset of those books are only-known copies that need to be kept intact and transferred to our Archives. My database design has a...