Search results

  1. C

    Upgrade advice for a retired DB programmer

    Hi About 5 years ago I had a bit of an I.T. breakdown and gave up I.T. following a 27 year career as a database programmer. I changed career to become an ecologist, which is where my passions really lie. In the past 5 years I have done all I can to actively avoid anything I.T. related, because...
  2. C

    Dynaset form speed issue

    Hi, I'm having a speed issue with a form, and wondered if anybody can help me. I'm using Access 2007 as a front end to a SQL server 2005 database. The record source for my form is an ODBC linked SQL view, called vwStock, which itself is built from three other views. Two fields in vwStock are...
  3. C

    Copying all records from an object to a local table

    Hi, my application has a MS Access 2007 front end and a SQL Server 2005 back end. I also get data from sage line 50 using sage data objects. What I want to do is populate a temporary, local table in Access with data from a sage table. I could do it by reading the sage table a row at a time...
  4. C

    Can I use a query in VBA if it has a parameter?

    Hi, Can you help me?? I'm using Access 2007. I have a query which uses a number of sub queries in order to build up its data. A couple of the sub queries use a control on a form as to get their parameter (i.e. the year). Everything works fine, except that now as well as displaying the data on...
Back
Top Bottom