Get Unit Rate from Web site directly to MS Access

[mobarak ahmed]

Hi dears
In form invoice
i want to get US Dollar (Unit rate) in case the Project currency is USD from this site
for example invoice to : AC Boilers EGYPT -- Project name : Cairo West E USD 10089-CP-105 / Electrical I&C Supply and Installation
to be paste on "Currency Unit Rate" Text box
* date is the same date as today
* Buy rate

 

[mobarak ahmed]

What is the code you are using?

I want the code . I don’t have one

 

[Gasman]

I want the code . I don’t have one

So no attempt to try for yourself?
I think you might have to wait for @arnelgp to see the post. He has done some work with webscraping and tends to write all the code for people who do not want to do it themselves.
I had a look and you also have to put in the required currency to start with? Looks very interactive when you use it, no explicit url to pick up on?

 

[mobarak ahmed]

I have tried but I failed.. the url when you choose date and currency and click show data .. doesn’t contain the choices
I have looked up in the inspect but it’s very complicated for me

So no attempt to try for yourself?
I think you might have to wait for @arnelgp to see the post. He has done some work with webscraping and tends to write all the code for people who do not want to do it themselves.
I had a look and you also have to put in the required currency to start with? Looks very interactive when you use it, no explicit url to pick up on?

 

[Gasman]

I have tried but I failed.. the url when you choose date and currency and click show data .. doesn’t contain the choices
I have looked up in the inspect but it’s very complicated for me

Probably to avoid exactly what you are trying to do?
Have you looked at other sites where you can supply values to get an actual url where you can scrape the values?

 

[mobarak ahmed]

Probably to avoid exactly what you are trying to do?
Have you looked at other sites where you can supply values to get an actual url where you can scrape the values?

Unfortunately this the only official and approved site in our work field

 

[mobarak ahmed]

i am sure he will
@arnelgp

 

[arnelgp]

test your Exchange rate (buying dollar).

 

[mobarak ahmed]

test your Exchange rate (buying dollar).

your are the best no doubt , thank you , thank you for everything

 

[mobarak ahmed]

Have you looked at the documentation on this page?

Central Bank of Egypt

Central Bank of Egypt

www.cbe.org.eg

The papers are in Arabic so I can't tell if they are insturctions. Look for things that talk about REST which is a common interface protocall.

thank you for helping me , i think we don't need to know , but thank you i appreciate

 

[Gasman]

test your Exchange rate (buying dollar).

@arnelgp
Any chance of a 2007 version please?

 

[arnelgp]

i removed my vmware so only office 2021 x64 is installed.

 

[Gasman]

i removed my vmware so only office 2021 x64 is installed.

Ah well, not to worry.

 

[mobarak ahmed]

test your Exchange rate (buying dollar).

could we link the date of Exchange rate with invoice date , as i tried to change the date but still have the same rate

 

[arnelgp]

i download the excel file exchange rate from 2020 upto Oct 4, 2021 and
import it to tblExchangeRate. these rate are historical, so it will not
change. this is to prevent going to the site everytime an old invoice_date is typed.

 

[mobarak ahmed]

i download the excel file exchange rate from 2020 upto Oct 4, 2021 and
import it to tblExchangeRate. these rate are historical, so it will not
change. this is to prevent going to the site everytime an old invoice_date is typed.

so should i update this table every month or period ?
i think if it possible to link invoice date directly to the site it would be better
as it will be automatically updated

 

[arnelgp]

i think if it possible to link invoice date directly to the site it would be better

you can't link it, the site is a Form, so you need to fill up the
form first before you can Download the excel file.
if you are not creating an invoice, retro-active, you
do not need to update the table.

 

[arnelgp]

it now save to tblExchangeHistory the data after
getting it from the web.

 

[mobarak ahmed]

sorry arnelgp but I have made small change in invoice form ,
i have add combo box combo260 under combo12
now the (buying rate against egp) not working Lol
another thing if you have time
when i type the value in item_value_current and press move the value button to move it to current field i have to click on it to make the afterupdate event take effect .. i want the event happen when i press the button

 

[mobarak ahmed]