Solved How to display text for a day

[SalmanZeiad]

Display text for a day, and on the next day, set a new value that appears for an entire day, such as the dollar value for today

 

[arnelgp]

for today's day:

Format$(Date(),"dddd")

next day:

Format$(Date() + 1,"dddd")

for exchange rate:

import Currency rates via API | Access World Forums (access-programmers.co.uk)

 

[Mike Krailo]

Maybe use the on timer event for your code to update the text box. Set the timer interval to 3600000 for updating every hour. If the source of your dollar value changes every 24 hours, then this will update it within one hour of the change.

 

[SalmanZeiad]

for today's day:

Format$(Date(),"dddd")

next day:

Format$(Date() + 1,"dddd")

for exchange rate:

import Currency rates via API | Access World Forums (access-programmers.co.uk)

help me how to do that @arnelgp

 

[arnelgp]

try my Exchange Rate.

 

[SalmanZeiad]

try my Exchange Rate.

Thank you very much. It worked well for me

 

[arnelgp]

goodluck

 

[Mike Krailo]

That's a nice chunk of code for exchange rates Arnel. Thanks for posting that.