Recent content by Dembrey

Dallr, It's not possible to have more than two events of one object occuring so close together. If the 2nd event follows the 1st by <10mins then the 3rd event on that object will be at least 12 hrs after the end of the 2nd one. If that opens the possibility of another solution I'd be more than...

Dallr, Misread your question. Events of different objects are never to be combined regardless of the proximity of their timing. Cheers.

Dallr, In fact the solution query is a sort of summary view. If the events (which are actually based on orbital mechanics) are so close they must have the same root cause and must be treated as a single "happening" for other post processing I need to do. Thanks once again.

Whoa :eek: I don't feel so bad about having to ask for help now.... Many thanks Dallr, that really is a quite impressive solution! Cheers.

doco, Thanks for the reply but I'm not sure I follow what you mean. The outputted query should combine two records into one (taking the StartTime from the first and the EndTime from the second), I don't see how an ORDER BY clause will acheive this. thanks.

Hi, I'm having difficulty constructing a query for the following problem, anyone know how I can go about this... I have a table which records events on particular objects, with 3 fields: ObjectName StartTime EndTime If the StartTime of an event falls within 10mins of the EndTime of another...

To print the currently active form you can use the command: DoCmd.PrintOut Obviously you'll need to open the form you want to print first to make it the active form. HTH.

You need to look at Crosstab Queries in order to do what you are asking. HTH.

My Company 'leapt' from A97 to 2003 so I have no experience of A2000. If conditional formatting isn't built-in to A2000 it can still be approximated using some slight of hand. Search the forums for some examples there are many posts on the subject. Also some info is given here...

I'm pretty sure what you are asking for can't be done with the standard Listbox object. The only way I can think how to do something similar is to use a continuous subform, I believe Access2003 can do conditional formatting. HTH.

Rename the Exit subs you have to: "ActiveXSliderCtl1_Change()" , .... HTH

It sounds to me that your form should be based on a query that combines the table containing the bound field of cmbCausedBy and the table containing the descriptive text. I guess these tables are linked somehow by the value of the bound field of cmbCausedBy. HTH.

See if this link helps: http://www.mvps.org/access/api/api0004.htm

Try looking at the OnChange event of the text control. this fires every time the contents of a text field changes. HTH.

adickie, Thanks for that. That's what I did eventually. I was just hoping there was an easier way than going through the uninstall/install route. Cheers anyway.