Recent content by Dazza666

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...

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

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...

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...

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...

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...

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

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

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...

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

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...

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

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

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

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...