Recent content by Charles Carter

  1. C

    using DoCmd.TransferDatabase to import data

    Re: I use this command. I'm not sure if it's what you're looking for. DoCmd.TransferText acImportDelim, "MerTemp Import Specification", "MerDBImport", "C:\MerTemp.txt", True, "" First I create the Table MerDBImport with matching fields to the imported data, then use the DoCmd to import a...
  2. C

    Update Query and Filters

    Have an update query that changes the Checkmark box to all on(yes) or all off(no). Those queries are assigned to buttons on a Datasheet Form. It works but what I would like to do is limit the query update action to the filtered set of records. Example: The main table has 4500 records...
  3. C

    Record Selection using Checkbox

    Re: Hi All, OK, I figured out how to filter using a Datasheet Form. Still need a bit of help on a 'Select All' button for Checkmark boxes. Also, how can I reset the Checkmark boxes back to nil value when the form is closed. Thanks, Charles
  4. C

    Record Selection using Checkbox

    Basic premise: I'd like to list all records in a table accompanied by a checkmark. If the checkmark is checked then this record will be edited (saved to a 'list' for editing). If not checked, then the record will not be edited (not saved to a list). What I've done thus far: I have a table...
  5. C

    Macro

    Hi All Access 97 DB I have a database that opens a macro and runs code to import a text file and parse information into several tables. It works great. What I would like is: When Access Opens, I would like it to open a form that allows the adminstrator to perform actions before the code runs...
See more
Top Bottom