Search results

  1. R

    Query as ListBox Row Source problem

    I'm afraid this is a fundamental issue, but I'm rusty. I've got the following query as the row source for a listbox on a main form. cboShootName is a combobox on that same form. SELECT DISTINCT QrySbfShotList.CamerasFK, tblCameras.CameraNum FROM QrySbfShotList INNER JOIN tblCameras ON...
  2. R

    Union Query Question

    I'm preparing a query as the control source for an unbound listbox. The following code gives the desired results: SELECT DISTINCT tblCameras.CameraNum, QrySbfShotList.CamerasFK FROM QrySbfShotList INNER JOIN tblCameras ON QrySbfShotList.CamerasFK = tblCameras.CamerasID WHERE...
  3. R

    Design question on Sorting a Form's Recordset

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

    Create Email is greyed out

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

    Recordset Question

    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...
Back
Top Bottom