Search results

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

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]

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

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

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.

I dont need a form, I need only the 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...

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 ?

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

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

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

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.

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.

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

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

Bravo 👏👏 Thanks for helping.

Hello all, there is a subform on the main form in my project and I use another form for data entry. Now I want to set focus on last record of subform after data entry, so I added the codes after insert sql : Forms!frm_Main!Sub_Words.SetFocus DoCmd.GoToRecord , , acLast but it doesn't work or...

Great !! What about the next question : "SSMA_TimeStamp", Is the field really needed ?

Thank you all, I have tow other problems : Short Time fields in Access is created as Short Text in SQLServer, I'm using short time (for example 15:23) in my Access program, now I want to do the same in SQLServer, How do I that ? A new field appeared in SQLServer tables after converting that...

Your help is greatly appreciated, I have a problem with converting tables to SQL, SSMA gives error for a field of the table : "Complex Text dataset is not supported" The field type is ComboBox (multiple allowed), I think this type of field there is not in SQL. My next question is : Can SSMA...