Search results

  1. G

    Deleting records ready for a New import

    Dear all Could anyone provide me with a section of VBA code (module) that will carry out the following in one procedure: Open an existing table - called 'Students' Select and delete all the records leaving just the structure (preferably WITHOUT a request to confirm) Close the table ready for...
  2. G

    A Menu of Choices

    Dear all Not sure which thread this belongs in so here seems good. I have multiple tables (around 60) that (will) contain assessment data on students. The tables will have the generic name PA# eg. PA1 or PA32 etc. I would like some kind of menu, with a drop down list or similar that will...
  3. G

    Case Sensitivity in Primary Key fields

    Dear all Can you help! I have imported a Dbase5 file into access that uses the full range of ascii characters to make up the primary key field. eg. £%{A or ""$6 The problem is, they use a mix of upper and lower case letters and when imported Access sees upper and lower case as the same...
Back
Top Bottom