Search results

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...

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...

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?

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...

Maybe it's just a momentary server problem, but I just tried (twice) to send a message using that address and it bounces. Is there something that needs fixing or should I just wait a while and try again?

The title pretty much says it all. I'm looking for something that could help me answer questions for myself, e.g. "If I've got a bunch of find/delete blocks in a macro, how do I get the macro to keep moving if one of the row sets it is working doesn't contain the row I want to delete?"...

This might be another case where I'm doing something that seems logical to me but is database-brainless. I've got a 'central' table, Titles, with an AutoNumber PK, Title_ID, which is an FK on several other tables, e.g. Print_QC. When I try a simple append of Title_ID from Titles to Print_QC, it...

I'm building a production-oriented database that needs to track who did what task (many instances). I started with lookups and this morning learned how that was a poor decision for my context. Now I'm trying a workaround that will limit workers to entries that match one of the rows in...

The subject is my basic question. The context is a content production tracking database where I have a Users table that currently is related to 12 other tables, a number which could grow slightly before I'm finished designing. In the Navigation pane, I see only one table named Users. In...

Greetings good people, I've been learning and modifying an existing (digital library) project for a few years now, and years before I studied access briefly enough to cobble together some interactive lessons on UI basics (Access 2000, maybe earlier). These days I'm trying to get more...