Search results

I don't understand how this will work sorry? Perhaps I have not explained the problem clearly enough. The subform is in datasheet view, has 3 columns, first column the user enters a location, on update property of this field is set so a further subdatsheet expands (subform within a subform)...

Hi all I have a subform within a form, on update of the first field (location) a subdata sheet automatically expands to show product and qty stored within the location entered.... All this works fine, however after entering about 4 records, the subdata sheet becomes hidden below the window of...

Can anyone please help me with a small problem I have? On my report I have a list of Pallets numbers, I am using =Count([Pallet]) to show the total number of pallets on the report, however occassionaly their are duplicate pallet numbers on the report (requirred). Is there a way of ignoring...

Worked this out thanks

Hi Is it possible to set the property of a subform to expand when a user tabs out of a field? Carn't seem to get it to work. I can set the subform to be expanded as default but I don't want this. Thanks

I have found a solution to this.

I will try and explain my problem as clearly as possible and hope that one of you are able to help. I have a simple db that is used for stock control purposes. The stock itself is held physically in different locations. The stock items are put into the database via a form with the fields [Item]...

Is this possible, because I just carn't seem to get it to work. I want to set the criteria on the result of part of query, that throws up a msg box if the result is <0 (a minus). Everything I have tried does not seem to work, can anyone help please?