Recent content by amir0914

  1. A

    Query based on two criteria ?

    Thank you so much, As your advices, I removed criteria from the query and carried it out by passing criteria with form to report.
  2. A

    Query based on two criteria ?

    to put it simply, I have two forms and one query, I want to reference query criteria to both forms that way if form1 is opened, criteria of query is : [Forms]![frm_InsurancePolicy]![txtInPolicy] And if form2 is opened, criteria of query is : [Forms]![frm_NewInsurance]![txtInsurance]
  3. A

    Query based on two criteria ?

    Hello everyone, I have a query which one field's criteria is refrenced to a form : [Forms]![frm_InsurancePolicy]![txtInPolicy] And Also it is needed to refrence to another form, it means I want to use two criterias for the field of the query. (the query is linked to a report which it's...
  4. A

    Bold word in a setences on a report

    Perfect!! Thank you all for spending time on my issue.
  5. A

    Bold word in a setences on a report

    Great! But as Gasman mentioned I have problem with the words that is not math with the sentence, like : invent | Pneumatic tyres were invented in 1888 by John Dunlop.
  6. A

    Bold word in a setences on a report

    I dont need a form, I need only the report.
  7. A

    Bold word in a setences on a report

    Thank you both, I think it can be done directly on report without changing table foramts, I write a simple function in an unbound textbox (Rich Format) on the report, but it's not complete: =Left([WordExample],InStr(1,[WordExample],[Word])-1) & "<b> " & [Word] & " </b>" As you can see I...
  8. A

    Bold word in a setences on a report

    Thank for your respond., It was Long text and I just change it to Rich text. So what do i do for the next step ? how to show bold the word within the text on the report ?
  9. A

    Bold word in a setences on a report

    Hello All, I've create a report that is included two columns, first columns is words and second is sentences (example for word). Word | Example .................................................. Ensure | The airline is taking steps to ensure safety on its aircraft. invent |...
  10. A

    Justify text

    Hello everyone, In a project on report, All text in a long textbox must be justified, but as I realized that Ms access only has 3 text alignment (Left,Right,Center) and Distribute which is not my aim. My question is that, Is there a workaround with vba or any other way to allign text justfied...
  11. A

    File not found !!

    It's the same theme, but the color of buttons is gray still. I'm changing them manually but it takes time.
  12. A

    File not found !!

    I did it, and it works, the error disappeard, but the color of the buttons on each forms was changed, for example color of buttons in a form are changed to gray. I think it's because of the theme of new database.
  13. A

    File not found !!

    Thanks for your respond. I did the ways as you had done, but I didn't get any result. when I do compact the error appears and also while compiling.
  14. A

    File not found !!

    Yes, I tried it but I got the same error after compacting.
  15. A

    File not found !!

    Hello everyone, There was an unnecessary module (Module1) in my program and I removed it from modules list via IDE. I reloaded the program but I noticed the module is not removed and when I click it to view codes, this error appears : Unfortunately,this error appears on each opening program...
Top Bottom