Recent content by chrisbrooke

Is there a way to capture microsoft office closing as an event. Ive created a button to close office because I want to time stamp when this event occurs, but inadvertently the main close button at the top of the screen is sometimes used and hence the event is not captured. Any ideas?, or is...

Ive got this update query that only works intermitently, which is a real pain, sometimes it comes back and say yeah ive update x amount of records, other times it just says a big fat 0! Is there a limit on how many records can be updated etc??

Hi, is there a way of showing only unique values, i.e. say the data was 111,2,2,3,444 for a particular field say name, of which is dave. What I want is a query with results that show for name=dave the results should be 1,2,3,4 and not the whole lot - just the different numbers.

Hi, is there a way of showing only unique values, i.e. say the data was 111,2,2,3,444 for a particular field say name, of which is dave. What I want is a query with results that show for name=dave the results should be 1,2,3,4 and not the whole lot - just the different numbers.

Hello, I have a main form with two subforms in it. When the main form opens I want the the two subforms to go to a new record automatically. Any suggestions? Thanks in advance.

Hello, How do calculate how may times a button has been pressed. Ive tried setting a variable say count=0 when the form opens(event). Then simply iterate this count on the onclick (on the button in question) event. However, this dosent seem to work. Any ideas? Thanks in advance.

Thanks for the help on the last one, Ive got an array that I want to display the results of. I know theres a way by setting the row source type to a function (using the function out of the help files - that show how to display 4 mondays in advance) but im struggling with the actual...

I have a field in a record to hold a test case number, for each record I input a new test case number. For a particular device I have 42 test cases. Therefore, when complete there should be 42 records for that device. I already have a query that tells me the amount missing (if any), what I...

I know this sounds like an easy one, and it should be. Im using the wizard to link to a text box in a form to a date field in a table (both configured with a short date input mask). Right, try an explain this...it works fine for dates in July, i.e it brings up the relevant record, but when I...