dynamic query

  1. R

    Import from access query (adding input boxes to satisfy the rilte requirements)

    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...
  2. M

    Dynamic Query

    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...
  3. L

    automate yahoo finance query refresh from html

    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...
  4. D

    Newbie question for Access 2003

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top