Recent content by mattwebb

hi, after spending a long time searching these forums and fiddling with my queries i have found a way of achieving my goal (albeit in a sloppy manner) through using conditional formatting and displaying the status fields through lookups in my record source queries. Many thanks to anyone that...

hello, i am trying to diaplay a message in an unbound control on a continuous subform that indicates to the user if any related records exist to each continuous row. In real terms what i am trying to do i display a list of swimming events in a subform with a box that says either "Selections...

many thanks for the advice...this is exactly what i wanted.

hi, any help on this would be appreciated. I have combo boxes on a form, sometimes they will be populated and sometimes they wont. What i would like to do is display a message to the user explaining why there are no records to chose from in the drop down list on the combo box when they click...

Hello, I have a datasheet subform and was wondering if anyone knows of a method to lock the column size and permanently hide columns. At the moment the users of the form will easily be able to drag the column sizes to what they want and also reveal the hidden columns... I've tried the Hide...

hi, yes inded this works a treat....thanks very much for the tip

Hi, I have a standard delete button on a data input form. I have cascading delete enabled one some relationships but not on all. In order to display my own custom delete message i have used.. DoCmd.SetWarnings False ...so as not to display the access warning messages when deleting records...