Search results

Thanks a lot. I checked the file you provided in your former post and it is working perfectly. Thanks for the help. That was exactly what I needed. By the way what does this (WHERE 1 = 0) where condition do. I failed to understand it.

So nice of you for such an explained post. I will check and update here. Thanks again.

Sorry for confusion. The code I posted in my former post was taken from excel forum and that code works perfectly but I cannot convert it to Access. I thought you're referring to that code in your following post If you're not referring to that code I posted then please tell me which code are...

Yes I tried it in accdb but ActiveWorkbook code did not work in access file.

I am surprised that one thing that is common between excel and access but in excel it can be performed using vba but not in access. There is no equivalent code for ActiveWorkbook.Theme.

Yes I saw it. But is accde and couldn't figure aout how to ise this in my db. It adds theme but I think one have to change theme using access ribbon which in my db are hidden along with the access window.

I've checked the link in post 4 and I found out that it cannot be used in db since it changes all buttons color to same color. I have different buttons with different colors. If changed it to other color scheme (using acces theme), each button's color is changed to respective accent and that is...

Thanks a lot for reply @MajP @isladogs. By going through the links, it seems that changing color scheme provided in access ribbon however alternate method are there. I will look into and try to apply the method shared in the db shared in the posted links. Regards

Thanks for reply @Pat Hartman. Color option m referring to is shown in attached image. Just want to have have ability to change colors while in runtime. Fonts are not being changed.

Hello, There is a color option from which we can change whole color scheme of our database. My question is, can we change that color scheme in runtime by having a combo box on a form to change the theme? Best Regards

Hello, Dear @Ashfaque, thanks a lot for this useful db. I have converted M_2_NumToUrduWords module to support number to Urdu word even when system locale is not set to Urdu or Arabic by replacing all Urdu characters by ChrW with their respective charcod. I am attaching module so that it can be...

Thanks for the link @June7, I had seen that link before but it doesn't contain anything which could explain how to do that except it seems from that page that it isn't possible.

Bump

Thanks a lot @arnelgp for sennding the db. Writing Urdu/Arabic text for labels in the xml is not issue. It can be written directly but I want to change the font of the labels. I want to change to some Urdu/Arabic font. Such text don't look nice when displayed in English font like arial or else.

Hello, I'm working on an Urdu/Arabic project and want to build custom ribbon for navigating for different forms. Ribbon labels will ne in Urdu/Arabic so need to set a font which have better readibility. I search over internet but couldn't find an answer to my query. How can we change font for...

Great post. @NigelShaw can we use different fonts for labels of controls on custom ribbon? Regards, Abdullah

So nice of you.

Thanks a lot everybody for your input and explanation. Stay safe and healthy.

Yes sir I did. I might have confused the question. By text date I didn't mean those dates in which months are text like Jan, Feb etc. I means dates stored as text like CStr(Date). And yes I know the format of those dates that is why I asked for format as input of the function. Do you mean that...

Thanks a lot for replies. How can I do that? It is true I wrote ambiguous date in the post intentionally but in the database date can be any date including the dates where day is equal or less than 12. I am not very good with programming but I wrote a simple function. Any suggestions how can I...