Hey guys me again :)
MS Access 2010
Please look at the attached picture to visual what I'm trying to say. Also, this is all one question but with multiple parts as they all tie in together.
I have made a a query in a list box to show all of the information relevant to the table (Equipment List). I have also created a search function so that the user can type in what he is looking for and it will be displayed.
Now what I want to know is how to:
1. When a user clicks/double clicks on one of the fields in the List box/search box, how can I get all of the information associated to that item to display in the fields above it. I can't work out any code for that and cannot find anything specific on the net. I want the information for the item that comes up to be editable ie. the user can alter the information
- I have tried using something along the lines of:
=[SearchResults].[column](5)
This however only displays exactly what is from that column, whereas I have close to 30 columns and I think I can only use 16 in my query? Additionally, using this method I wasn't able to edit the information.
1.1. In my ListBox, the headings/field names aren't showing above the fields. For example, there should be the word "Descriptio n" above chemical injection and heat exchanger
1.2. Lastly, is it possible to create a similar search function in this listbox that is similar to that of excel? Eg, so I can select a column in the listbox and search only characters specific to that column?
Thanks guys been lots of help lately
MS Access 2010
Please look at the attached picture to visual what I'm trying to say. Also, this is all one question but with multiple parts as they all tie in together.
I have made a a query in a list box to show all of the information relevant to the table (Equipment List). I have also created a search function so that the user can type in what he is looking for and it will be displayed.
Now what I want to know is how to:
1. When a user clicks/double clicks on one of the fields in the List box/search box, how can I get all of the information associated to that item to display in the fields above it. I can't work out any code for that and cannot find anything specific on the net. I want the information for the item that comes up to be editable ie. the user can alter the information
- I have tried using something along the lines of:
=[SearchResults].[column](5)
This however only displays exactly what is from that column, whereas I have close to 30 columns and I think I can only use 16 in my query? Additionally, using this method I wasn't able to edit the information.
1.1. In my ListBox, the headings/field names aren't showing above the fields. For example, there should be the word "Descriptio n" above chemical injection and heat exchanger
1.2. Lastly, is it possible to create a similar search function in this listbox that is similar to that of excel? Eg, so I can select a column in the listbox and search only characters specific to that column?
Thanks guys been lots of help lately
Comment