Search results

Hi all I have designed an access data base with the attached table structure. If someone could review and advise if it looks correct please. My goal is to have eventually have a form based on the table Materials automatically display the "ProbRisk" and "CritRisk" based on what's selected in...

Hi all I have caused a little bit of confusion with my earlier post and am re-posting my question sorry. I am wanting to get the combo box to display the multiple search matches in a drop down as I type each letter. Then I select the appropriate one from the drop down to display the details on...

Hi I have a form with a combo box in the header so to search and return results. It works when I type, but when I click the drop down it displays all the records from that text on-wards. I would like it to allow me to type the first 3 letters and then display only the search results in the...

I have an access database and need to split my memo fields (Source Data.png) into separate lines as per the results in (Output.png) I have attached pictures to visually show what I am trying to do, its easier that a lot of confusing word's I have also attached the sample access database which...

Hi I'm Greg from Australia and I am here because I am stuck with an Access problem. I have a lot of experience in the drag/drop functionality but not too much in programming. Cheers, Greg