Search results for query: *

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

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

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

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

Hi How do I make my report print to a specific printer and return an error dialogue box if that printer is not installed on the computer? Many Thanks, Karl

Hi I have a simple report which is grouped by Postcode area (Fieldname - Postcode1) (NG1, LN1) etc and under each postcode, lists the people who live there (Fieldname - NameFull). What I get at the moment is a report which overlaps postcodes - ie a few of the people from NG2 are on the NG1...

Hi. I have a form with a date on. The date box is 'Text196'. What I want to do is make it so that when this text box gains focus, the user MUST enter a date. If the user doesn't then a dialogue box is displayed and the focus stays set on the 'Text196' text box. This is what I have at the...

Hi I have a button that runs an update query called 'Query1'. In my code for the button I use the 'DoCmd.SetWarnings False' command as I set my own dialogue boxes, and use the ''DoCmd.SetWarnings True' command at the end to turn it back on again at the end. When I run an update query manually...

Hi I have a button that runs an update query called 'Query1'. In my code for the button I use the 'DoCmd.SetWarnings False' command as I set my own dialogue boxes, and use the ''DoCmd.SetWarnings True' command at the end to turn it back on again at the end. When I run an update query manually...

Hi All Ok, I have a button on a form that collects data. When the data has finished collecting, a normal vbInformation box comes up so the user can click OK. However, what I want to do is have a box that comes up whilst the data is being collected saying that the data is being collected and...

Hi, Sorry for the rubbish title I gave you, hopefully I can explain better here. I have a table called 'tblBalloon'. This table contains a true/false field for 3 colours. The field names are 'Red', 'Yellow' and 'Blue' respectively. in each field, -1 stands for True and 0 stands for False (this...

Hi I'm trying to put some sideways text into my Access report and I can't find a way of doing it. I've already tried making an image of the text and pasting it in but that looks a little pixelated. Can anyone help? Thanks, Karl

Hi I have a table called 'tblEmployee'. When I press a button I have in a form, it runs a query which brings up all Employees from 'tblEmployee' that I have put a tick next to. What I want to do is so that when I press this button, it automatically puts these employees into a table called...

Hi In Windows Xp - especially when I surf the web using IE6 and scroll up or down - my display will freeze for anything from 1 second to 10 seconds, and then it will flick (just like it does when changing resolution/refresh rate) back to normal. When its flicked, the resolution or refresh rate...

Hi, Ever since I'ved used Windows Xp Pro (on several machines) I've come accross a problem with all of them. After about 20 minutes of leaving the computer, there is lots of hard drive activity for roughly 5 minutes and then the cycle starts again. Indexing is turned off, there are no...

Hi, I'm using Excel 97 and was wondering if theres a way of making more than 3 conditional formats which the 'Format -----> Conditional Formatting' provides. Many Thanks, Karl

Hi Is it possible to have an IF Statement within an IF statement and if so how? (ie with brackets or speech marks?). Please give simple example if possible. Thankyou, Karl