Recent content by roger_anderson

  1. R

    Filtering on combo text

    Tried that Thanks but tried that and it then presents only data from previously entered records in the journey table. I am sure that when I've done this before I produced a filter which was turned on when the Route combo box changed so that only the appropriate stops on the route were visible...
  2. 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...
  3. R

    Format a field to Short Time?

    Sorry Rich and anyone else who was mislead by my post. I want to be able to set the field format to Short Time in a VBA module having just created the field using ADO.
  4. 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?
  5. 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?
See more
Back
Top Bottom