Search results

Now I remember some basics from years-ago training. I'll remember to use lookups if necessary on forms only, and that I can set default User entries on the forms for individual front-ends. Most of my tiny group of users are moderately to fairly technical, but I still keep them working in forms...

Thanks to all for helping me learn how to ask better questions. I've attached a copy of the database and also opened a OneDrive folder, uflorida-my.sharepoint.com/:f:/g/personal/gwswicord_ufl_edu/EpUl2Nja57NCudKky_wi6FIBwVTkDBDa-i74Se_2GVi6xw?e=3itY0B, in case anyone might find that an easier...

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

Items 2-4 and 6-7 alone or together have me sold on ditching the lookups. Avoiding bloat and being prepared for possible migration to SQL Server are especially important for this project. The database is for a master's theses scanning project. We cannot be certain about the final number of...

Hi Ridders, I'm the only person touching the database (I'm still designing it), and I never added the Users table manually--it just appeared after I used the Lookup wizard to connect a task-user field, e.g. Who_Prepped_Batch, to the list in Users. G.W.

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