Search results

Hi all, I have inherited a database that has some comments associated with the buttons in many of the forms, such that as the mouse pointer is hovered over it, a comment is displayed next to the pointer about where the button takes you to/what it does. I need to amend what some of the comments...

Thanks for the suggestion with regard to DCount. I had just started looking at that as an option myself, but was sketchy on how to get the best out of this..........I then thought of a workaround. By creating another report that only lists each bit of equipment that the report generates, and...

Dear all, I'm having problems with a count expression in a report. I have a series of items listed, with subdata against each one, in some cases this subdata is one rows, in others it is many rows. Anyways, having listed these items and there subdata sets, I want a count of the number of items...

Dear all, I'm having problems with a count expression in a report. I have a series of items listed, with subdata against each one, in some cases this subdata is one rows, in others it is many rows. Anyways, having listed these items and there subdata sets, I want a count of the number of items...

Dear all, I want to generate a different drop down box dependent upon the criteria of another selection on a form. For example, when the user selects "fish" from the drop down, the query criteria lists only those animals whose animal type is fish. If the user selects "reptile" from the first...

Dear all, I want to generate a different drop down box dependent upon the criteria of another selection on a form. For example, when the user selects "fish" from the drop down, the query criteria lists only those animals whose animal type is fish. If the user selects "reptile" from the first...

Dear all, I want to generate a different drop down box dependent upon the criteria of another selection on a form. For example, when the user selects "fish" from the drop down, the query criteria lists only those animals whose animal type is fish. If the user selects "reptile" from the first...

Thanks Doc Man - unfortunately the same bit of kit can appear at different levels - sounds like it is as complicated as I feared it might be. Cheers for the guidance though, I might have to think about ways around it! Steve

I stand to be corrected by mroe experienced users - but I too have had problems adding jpeg files - however, if you can convert to a bitmap you can use bmp files instead - might be a bit laborious to change a large number of files though. I am approaching a potentially similar situation - so...

Dear all, I have an equipment database, within which I am attempting to create associations between various items. The items are distinguished as level 1, 2 or 3 depending upon where they sit in the equipment hierarchy, level 2 being sub-equipments of level 1, and level 3 being sub-levels of 2...

Thanks Thanks Lagbolt - works a treat - think i was trying to overcomplicate things! Always the way!

Dear all, I'm trying to incorporate a combo box in my form to navigate through records. The plan is to select a piece of equipment listed in the combobox, and that record will then be displayed as an "after update" action. However, I have tried through coding I have tried before and utilising...