Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hibbie0762

  1. hibbie0762

    Access 97 to 2002 conversion: text in reports

    I have recently converted a couple of my Access 97 dbases to Access 2002 running under XP Pro without too much pain. The main trick seemed to be to replace the Missing Reference to DAO 3.5 with a reference to the new version (6.0?). However my reports, which use a lot of concatenated text, are...
  2. hibbie0762

    Access 2000 to Access 97 conversion gives switchboard problem

    I have converted a couple of my Access 97 dbases to Access 2002 fairly successfully by correcting the missing reference in a dummy module, then saving. Everything seems to work except my predefined reports, which contain concatenated text strings. The syntax (|[datone]| |[dattwo]|) to produce...
  3. hibbie0762

    Dividing an address into house number and street name

    I am looking for VBA code which will scroll through about 60,000 records dividing an address line field into two new fields, one containing the house number and the other the street name, using the first space from the left which it finds as the separator (for example datAddress "13 Elm...
  4. hibbie0762

    My database holds user permissions.

    My database holds user permissions. Table 1 contains User details and Table 2 contains User periods of approval. The tables are linked on a unique UserID. Each record in table 1 is unique but there may be several related records (events) in table 2. There are pop up forms based on each table...
  5. hibbie0762

    Forms: displaying latest record only on a linked form

    Thanks for the prompt response. The subform was set to single previously. I have just tried setting it to continuous but it does not appear to make any difference all events are still available when all I want to display is the most recent. Perhaps I have to do something with the underlying...
  6. hibbie0762

    Forms: displaying latest record only on a linked form

    My database is centred on two main tables - a table of user details, and a table of events (approval dates). I have created linked forms (with underlying queries) to bring up the User detail records and then show an associated event form with one or more records for user approval dates. I now...
See more

Part and Inventory Search

Back
Top