Recent content by EvilTwinOfAtrus

Yes, I understand that and knew about the macro option but just wondered if there was a way in the make-table query itself but obviously there isn't. Thanks, EToA

Thanks, but that's not really an option as there are quite a few make-table queries that I would all like to run from a macro. Cheers, EToA

Hi I have a make-table query that creates the destination table and fields but no data, if no data is returned by the query criteria. What I would like to do is make is so that if no data if returned by the query, a take is not made. Hope you can help. Thanks, EToA

Hi I have a spreadsheet where A1 is =TODAY() and column H has various dates in it. I have a conditional format set up so that if the value in column H is less than or equal to A1 (todays date) is colours the date (in column H) in red. When this cells text colour turns red, I would also like the...

It's ok actually I've worked it out and adapted it. Thankyou so much for your help :-) - EToA

sha76, can you make that a bit more friendly for me. I'm not too hot on thinking straight at the moment with my holiday next week hehe. Sorry. Thankyou, EToA

Hmm, I'd already thought of that but it avoids the point, I don't want to keep typing in postcodes, I just want a list of them with the count next to it. Thanks for your help. Any other ideas? Anyone? ^_^

Hi All I'm trying to run a query which tells me how many houses are on our database in each postcode (using the COUNT record function on 'HouseID' and the "WHERE PostCode1 is between x and y"). The postcode on the database is split into PostCode1 and PostCode2 for the 1st and 2nd part of the...

Hi I have a form that has a date of birth field in it "DateOfBirth". When the date is entered I want a text box to work out the age of this person. For example, if I entered 19/07/1985 it would return "18". Thanks in advance for your help. -EToA

Hi I know how to hide the close buttons on Access forms but I also need to disable the main 'X' close button in the top right of the Access window so that users are forced to use the proper buttons in the forms to exit the database. How is this done? I am using Access 97. Thankyou in advance...

Heh, sorry, I forgot to mention, it's just a certain range. But the range is the same on every sheet in the workbook.

Hi I'm looking for an easy way of converting all of my formula cells to value cells without having to go through every cell in every sheet. For example, I want '=2+4' to just be the value '6' Over to you :-) Thankyou, Karl

Thankyou so much. This has helped me a lot

Hi I have a query that returns no data at the moment. I have an 'Area' field in the query and then the 'Count'. What I want to do is return the area names and fill in the count as 0 even if the criteria isn't met. Instead, at the moment, it returns nothing at all because there is no data that...

Thankyou :)