Search results

  1. E

    Refresh a single record in a Query or Form (datasheet)

    I'm trying to figure out if there is a way to refresh a single record in a datasheet subform (based on a query) using a VB statement. Currently I have a FormA (a series of test/combo filters) which launches queries/reports based on input (never closes). FormA also launches seperate FormB, which...
  2. E

    Relating subform to a form

    I'm having a bit of a problem figuring out how to do this... I have a form (single form) and a subform (datasheet which is based on a query which includes the data elements [via outer join] in the single form). What I'm trying to do is have the data sheet form include (view only) all records...
  3. E

    Triggering Yes/No message box based on date

    I have a form in my database that opens by default. I want to trigger a yes/no (yes would run a query, no would end) popup based on the value of a field in a table or query (i.e. if "now" is fifteen days past date in the table/query). Any help would be most appreciated. -Eric
  4. E

    Exporting Access Query to Excel (into a temp file)

    I'm trying to find a way to export my query results to a new blank workbook (some might call this an excel instance). So far all I can do is export the result into an excel file then open it using the following; Private Sub cmdEXPORT_EXCEL_Click() DoCmd.TransferSpreadsheet acExport, 8...
Back
Top Bottom