Search results

  1. S

    Exporting reports using a macro

    I have a table within my database containing records that relate to a customer ID. I have a parameter query that prompts for a customer id. What I want to be able to do is export these reports as rtf's automatically for all my customer id's in seperate files. Any Ideas ?
  2. S

    Query

    Right I want to group results in this table "URN" "Flag" URN is unique to a person and a flag is a combination of two letters this is from a legacy system .The output from the legacy system means that for every flag attached to a URN a seperate record is created what I want to do is this...
  3. S

    Select record

    I have a form with a sub form what I want to be able to do is use the main form and search on postcode surname and display the records that match in the subform and then allow the user to select which record to add additional data to ahhhhhhhhhhhhhhhhhhhhh
  4. S

    Table validation rules ok ?

    Question I am looking at some annoying Access database for a charity and got stuck on trying to make something work that they believe used to Two Tables Venues pK Venue ID Venue Name Venue Capacity Booking Venue Name Addr1 Addr2 Addr3 Ect They have a query call capacity check which does the...
  5. S

    Validating a dropdown

    Question I am looking at some annoying Access database for a charity and got stuck on trying to make something work that they believe used to Two Tables Venues pK Venue ID Venue Name Venue Capacity Booking pK Venue Name Addr1 Addr2 Addr3 Ect They have a query call capacity check which does...
  6. S

    Validation query

    I am creating a database for the local arts centre here is my question we have several venues each with a limited capacity i am trying to create a booking system so when a venue is selected it checks for capacity at the venue. This is a one off event with one event being held at each venue so...
Back
Top Bottom