Search results

  1. T

    How do I import Excel table into Access

    Hi All, I appreciate there are numerous posts on importing from Excel, but I've not yet managed to find one that solves my problem. How do I important and excel table with headers into Access (If its possible, as Excel tables are dynamic ranges)? I can import into a new temporary table using...
  2. T

    Help - Access 2013 Consistently Freezes

    Hi All, I have a an Access 2013 accdb database being developed, however I now have a problem where it consistently freezes in the same place (I'm on 64 bit laptop, windows 7). I have a specific form whereby a command button runs VBA to import 2 files, convert the data based on a set of rules...
  3. T

    Guidance required on copying records v normalisation

    Hi All, Can anyone please advise on the best approach for copying records for archiving purposes. Scenario: I need to update records that meet criteria, but the user may later need to see the original record, what changes took place and the updated record. My thoughts were to have...
  4. T

    Can you amend an import spec via VBA?

    Hi All, Is there a way to amend the file path & name of an existing import spec, via VBA? Nothing else should change. FYI, this is to future proof the specs, so if the file location or name changes (which is highly likely this year due to changes), the user can remap by selecting the file via...
  5. T

    Which combobox event is best to reset the rowsource

    Hi All, I am developing a simple query builder which enables the user to create rules to automate data changes. When creating the criteria, the user selects a FieldName, Operator & Search value. The operators available are based on the Table.Def DataTypeName for each subform record. The...
  6. T

    How do I add a Calculated field in a sub form that works for each record

    Hi All, I have 'custom query builder' in a main (Header) & sub form (Criteria), where the user selects a field name (combo) from a table, operator (combo), & value (textbox). I also have a function to return the TableDef DataTypeName of the Field name selected, which works as expect for a...
  7. T

    How do I set and manage query order priorities

    Hi All, I have a Access 2013 database which imports a dataset from MS Excel, makes changes based on a set of rules (setup in another table and run via VBA using DAO recordsets), then exports the amended dataset. The rules need to be assigned a number for order of priority they are to be...
Top Bottom