Recent content by Dazza666

  1. D

    show when more than 1 value is true

    Hey, I completely agree with you, normally I would have a drop down box with the options stored in another table, however we need to be able to select more than one option? I'm not really sure how to go about that so I decided to build the options in to the table. The reason I say the options...
  2. D

    show when more than 1 value is true

    Hey thanks, yeah I probably could have designed the table differently but I needed to be able to select more than one and since the categories are specified from a framework they will not change in the life of the database. Your solution worked perfect thanks for that
  3. D

    show when more than 1 value is true

    Hey, i've got what i thought was a really simple query thats proving hard for me to suss, search turned up no results. I have a query that has the following: First Name / surname / diabetic? / physical disability / learning dificulty /Other disability / apart from first name and surname...
  4. D

    Query by form groups

    Hi thanks for responding, the building table is only a used like a lookup table and can be used by multiple clients at once. it is only used to provide rent information and the building name for drop down lists so it only has 1 record for each building the table looks like: ID BuildingName...
  5. D

    Query by form groups

    Ok I might be on to something, I've disabled the limit to list property and creeated an option group that depending on the option selected changes the value of the drop down to something that resembles a where statement i.e. "'building 1' or 'building 2'" the code works but the query by...
  6. D

    Query by form groups

    Hi, I have a load of queries set up and a form that accepts building name, start date and end date, all queries get criteria from the form. I need a way of using the drop down box for more than one building i.e. an option of 'CANADA' meaning all buildings in canada. I figure i could do this...
  7. D

    Supressing errors on sub forms

    I'm gonna research error trapping because I don't have a clue, Also there isn't a line of code generating the error as there is no VB in these forms
  8. D

    Supressing errors on sub forms

    Hey thanks for your response, I placed the statement as suggested but the damn message keeps appearing anyway!!!
  9. D

    Supressing errors on sub forms

    Hi, I've got a few sub forms as datasheets imbedded in my main form. The sub forms contain information from other tables and are related to the main form with a primary key. Sometimes the sub forms will contain no records i.e if the client on the main form has no children there will be no...
  10. D

    Help losing the plot

    lol great It's always something silly I find. thanks for saving the day!!!
  11. D

    Help losing the plot

    Hi, I've been working on loads of queries for the past few weeks and have finally lost the plot. I can't get the simplest queries to work anymore, please help! I'm using Query by form but even replacing the form field with a static date I can't get the below to work. New Referrals 16-18...
  12. D

    Output to a custom excel sheet

    cool I'll keep this in mind :) cheers,
  13. D

    Output to a custom excel sheet

    Brilliant! I'll enjoy learning about this now. Thank you once again for your help
  14. D

    Output to a custom excel sheet

    Thank you very much for that, I found enough information to give me a leg up, i'm happy to work out the details. Just quickly, is it possible to copy data to a worksheet from serveral access sources? (such as multiple queries and / or tables) thanks
  15. D

    Output to a custom excel sheet

    Hi, I've seen people output data from an access database to an excel spreadsheet. This is not a standard export though this is exported to a custom sheet with totals etc. This would be great for us, I was curious how this is accompolished, it it through XML? We use varying versions of excel...
Back
Top Bottom