query breaking

  1. V

    URL Query Loop Freezing Excel 2010

    Hello all, I am in the process of creating a VBA macro in Excel 2010 to scrape text from a list of websites to examine the frequency of words. Ideally, I would like to plop in a list of thousands of websites and let the macro run overnight. I’m running Windows 7 64bit. Ill post the entire...
  2. M

    query that does not include specified expression...

    When I run my query, I'm getting this message: "You tried to execute a query that does not include the specified expression '([Net Amount]-[Accrual Amount)]/[Net Amount]' as part of an aggregate function." The fields [Accrual Amount] and [Net Amount] are in the Total category of "Sum" and the...
  3. J

    VBA ADODB query within Date Range

    Hi, I have a function in VBA 2008 which returns the results of a query within the requested date range. This query works beautifully if I remove the where statement. Otherwise, I receive the error "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires...
  4. S

    Query breaking for NO reason

    When every I run a Append query I get a error " The INSERT INTO statement contains the following unknown field name: 'Scac(BKG/FRT)' Make sure you have typed the name correctly, and try the operation again." The field name is correct ie - Scac(BKG/FRT). If I edit the query by just selecting...

This Week's Hot Topics

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
Top