Search results

  1. O

    Table Relationships affecting Form

    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...
  2. O

    Combo Box Searching

    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...
  3. O

    Smart Searching using a combo box

    Thanks JDraw I have caused a little bit of confusion and am going to re-post 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 for as a...
  4. O

    Smart Searching using a combo box

    Hi In my macro I have ="[NM_CD_2303] = " & "'" & [Screen].[ActiveControl] & "'" Anyone know how I can convert JDRAW's Like [first3chars] &"*" to macro speak? Cheers, Greg
  5. O

    Smart Searching using a combo box

    Hi JDRAW Thats what I wish to have please. Cheers, Greg
  6. O

    Smart Searching using a combo box

    Hi Due to the lack of my skill set, I just can't seem to do it. I get a bit confused with some of what he is saying due to a lack of experience. Just have to get this sorted and my database in finished. Can you help out?
  7. O

    Smart Searching using a combo box

    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...
  8. O

    Memo field to separate lines

    Thank you JHB Works fantastic, really appreciate the help Cheers, Greg
  9. O

    Memo field to separate lines

    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...
  10. O

    Hi

    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
Back
Top Bottom