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

Some videos you may like

This Week's Hot Topics

Top