Search results

  1. R

    Filtering on combo text

    Aaaargh! It's a couple of years since I got my hands dirty in Access and I seem to have forgotten more than I thought! :( I have a simple database which includes tables STOPS (stopID, stop name, routeID, Cost band), JOURNEY(CustID, routeID, stopID), and ROUTES (routeID, Route name, Bus co). I...
  2. R

    Format a field to Short Time?

    OK, so now, thanks indirectly to this list I can create a new table. In the table I can create a field of data type adDate. How do I now format this field so that it is Short Time?
  3. R

    Creating a new table in code

    I'm a newby to VBA. I have tried to create a new table from within a module following the code in the help file. I get a compile error "User-defined type not defined" to the code Dim dbs As Database. Where should I be defining what?
Back
Top Bottom