Recent content by ecrespol

  1. E

    Access to Word Automation

    Another quick question does anyone know the syntax for opening/closeing the header/footer (I have a couple of bookmarks there that need to be used)? Thanks Eric
  2. E

    Access to Word Automation

    What I did was point to a template based on a combo box ' Specify location of template strTemplateLocation = cboTEMPLATE.Column(1) & cboTEMPLATE.Column(2) Where Column(1) was the template's path and Column(2) the template file's name. In this example I gave those columns a width of 0...
  3. E

    Creating Merge Template

    Presuming you have bookmarks called CaseText and ItemText (not just the words), I don't see anything wrong.
  4. E

    Need simple counter module

    I'm a bit confused as to what you are trying to do?
  5. E

    Stuck with a query in VB

    I'm not an expert on VB, but I think that the following will work... Set dbs = CurrentDb dbs.Execute "Your SQL" dbs.Close
  6. 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...
  7. E

    Relating subform to a form

    Update: Ok I've changed the database so that the relationship is many to one between the data in the subform (many) and the mainform (one). I think that the whole thing would work if my mainform and subform were reversed, but I need to have it display as a datasheet view. Any Ideas on how I can...
  8. 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...
  9. E

    Triggering Yes/No message box based on date

    Thank you kindly that worked perfectly.
  10. E

    Triggering Yes/No message box based on date

    It will be a date field in a one row table ("LAST_UPDATE"), but I don't think it would matter much either way. Also if anyone has a better way of implementing this idea (without using a table) I'm open to suggestions. -Thanks
  11. 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
  12. 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...
See more
Back
Top Bottom