Search results

Thanks a lot. Your code worked perfectly. I do appreciate your efforts

This is a sample of the original database i used for analysis. Would be glad if anyone could help me with a fix around it. Thanks

At this point, i tink is best i attach a copy of my initial database for analysis. because am still having vhallenges

I have tried of the form’s Current event but didn’t work the form is an information form

I have tried of the form’s Current event but didn’t work

Thought same But I tried applying the code in the timer but nothing happens. Am sure I didn’t apply the code well in the timer any suggestions?

With reference to this, I tried the code but seems not to work when the form is already opened. Say, the form was opened in the morning and still using it during the afternoon. how will I apply this code to automatically display as afternoon when is 12pm without me having to close the database...

I will like to thank you for your wonderful support. You guys are amazing. Have been able to get it work the way i wanted it.

It didn’t run It gives an error when I tried to run it. That was why I tried to compile and it didn’t work

I noticed the code doesn’t compile. I think there are errors in the code

No suggestions has actually been given from access forums per the request I posted here. my codes works fine Is just the arrangements that am finding issues

Noted

Didn’t know I had to add the link to it. Sorry about that Will add the link next time

@Gasman If you read my description well, I stated that I have already posted in access forums and didn’t get the solution I needed. That is why I am re-posting here

I have a database which am trying to convert amount to words. I manage to obtain these codes which I modified to suite my needs. My only issue is, the words doesn’t appear the way I want it. The current codes, for example, it converts 705.50ghc as “seven hundred five cedis and fifty pesewas”...

W Will do that Thanks a lot

I rechecked and noticed I didn’t copy it properly And yes Your suggestion helped fixed the issue for me Thanks a lot

Hav Have tried this But the code turns red and doesn’t compile

My issue is from the strCriteria. The section for the date is fine

Yes I did cross post as you said. Sorry about that. Needed quick response because I don’t understand the debug print procedure so making it difficult to do that. And it seemed the help wasnt coming as expected so needed to post here too. Maybe someone might be of help.