Search results

Hi I have a form which runs off a query. So when I select a box, i.e. box1 from a combo box and press the ok button the form closes and opens another with a list of all the tools in that box. Now here is the problem... When I search the box only the first tool in the box comes up. I have tried...

my boss told me now that he wants to be able to select a pallet form the combobox which populates a listbox or some other method.. basically after selecting the pallet from the combo box, he wants a list of the tools in the pallet to display on the form and then the user can click on a tool if...

i have a combobox with the names of the pallets etc. how do i set the rowsource of the list box to display the tools in the pallet depending on the pallet i selected from the combobox? this is the code im using and i know the spaces in the names is messing me about!! :( the combobox with...

well firstly i have a dialog box that when i select a pallet name it runs a query and opens up a list of all tools in another window.. is there any way i can have that list display on the form instead? Also from this list, can i select a tool and automatically be brought to a form with all that...

Hi everyone!! I have a form which uses a combo box. When i select an entry from the combo box it runs a query an returns several results. A list of tools to be exact. Is there any way that I can click on one fo the tools on the list and automatically be sent to a tool data form which is the...

subformcontrolname... is that the name of the textbox containing the name of the pallet?

the subform is based on a query. the name of the field is "Assigned Pallet"

Just 1.. It has a list of all the names of the pallets i.e c-c45, c-c46 etc. All data is text format. and i dont know how to reference a combo box from a query...

its in datasheet view. When I select the pallet from my combobox it just gives the first tool in the list of tools meant to be in that pallet and not all of them! Any ideas??

i have the combo box working, such that it only reads unique values i.e only each pallet once. The problem i have is i dont know how to display the info. When I click on a entery in the combo box (a pallet) i want a list of all tools in that pallet to appear in the form but i got no clue how to...

That link is not working :( it says service unavailable

Any ideas Mr. B?

I have done this. But how do I set it up such dat when i Press on the pallet im lookin for all the tool no of the tools within that pallet make a list on the form?

Hi vbaInet Would you be able to have a look at my post "Display several results!!" and tell me what you think? I really stuck on this one! Thanks in advance, Jer

hi smig how do i use the grouping option? I have no idea!! :(

Hi Im back again!! So i will dive straight in. I have my db nearly complete but I have to create one more search form. I created a form form my list of tools. Each with a serial no, tool no and unique id. However all these tools are stored in pallets and several could be stored in one pallet!! I...

Hi vbaInet, Sorry for the late reply, I got it working in the finish with a bit of code. Thanks for all your help!! could not have done it without you. :) Thanks again Jer

when i preview the current record to a report, there is one problem. Any tools with the same tool number, when i preview it in report it previews the first record only and not the others! but when the tool numbers are different it works.. any ideas?

My bd is too big, will i delete the image controls or is that pointless because these are what im trying to get to change with the report.

Hi vbaInet Sorry about the delay but it wont let me upload my db.. any way I can email it to u??