Search results

The query for the form recordsource is SELECT tblShotList.ShotNumber, tblShotList.ShotNumSuffix, tblShotList.Inline, tblShotList.ShotDescr, tblShotList.ShootsFK, tblShotList.CamerasFK, tblShotList.ShotListID FROM tblShotList ORDER BY tblShotList.ShotNumber, tblShotList.ShotNumSuffix; (This is...

Hello all. I've been building a small app for some friends. At present, they enter "records" line by line into a word processor, then use (archaic, IMHO) macros to produce the desired printouts. They wanted the new data entry UI to mimic that process. Ok, so I've adopted the datasheet...

YESssss! I've been fiddling with this for days; you nailed it in seconds.... Doh! As mentioned, I had tried it with a form. Not (yet) understanding just what the feature is good for, I was guessing it would be used with a form. Now I see that if I have *both* a form and a table open, the...

ACCDB. Northwind as well as my own project.

Hello all, I just noticed that my Access 2010 "Create Email" option is greyed out. It's in the External Data tab. Does anyone know how to activate it? I'm running Access 2010 on Win7x64. My default (MAPI) email client was not MS Outlook, but since the help file indicates Outlook needs to...

That wasn't intuitively obvious to my noobyness. Thank you! I guess you mean extract the primary key from the record found by .findfirst and then use it with DoCmd.FindRecord? So far, I'm getting an error with that, even after making sure the subform control has focus. Will keep trying. For...

Thanks, but that doesn't work. Actually, the developers guide (forum won't let me post link) says: "The source can be a table name, a query name, or an SQL statement that returns records." -Ron

Hello all. Please consider the following code (from which I have removed statements I believe to be irrelevant to my question. The code appears in a combo AfterUpdate event on a main form. The cbo is used to select a record in order to display related records in the subform. The code sets...