dynamic query

Hello all, First off, the experts on this site have been so helpful in my VBA endeavours. I can't thank you enough. Now, my next challenge..... I have been using the following code to pull data from various queries within my database.... Sub Get_Data () ' pull data from the database...

I’ve been trying to find a way to change location and date from import web page and wondered if somebody could help please? http://www.realtimetrains.co.uk/search/advanced/RAM/2018/09/26/0000-2359?stp=WVS&show=all&order=wtt The two areas are highlighted in bold and “RAM” I was going to use a...

Hello I am using the following code to import historical indices data for 5 different indexes in yahoo finance. Public Sub Import_Yahoo_Finance_Historical() Dim URL As String Dim dateParams As String 'Date ranges from default earliest Yahoo start date (m/d/y) to current...

My experience has been mainly SQL Server. I am working on an Access 2003 database with a simple data entry form (frmNewPatient) for inserting new records into a Patient table. Before executing the insert, I want to check that there is no matching record already in the Patient table. The form has...