Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Barntek

    VBA code in Access adp stops running half way through, out of memory

    Hello, I have not tried not using the syscmd but will do - is this lightly to make a difference? The application is new and has always had this same issue. I am running Office XP (2002) with SP2, and Access 2003. I was talking to someone last night about this issus and he suggested that the...
  2. Barntek

    VBA code in Access adp stops running half way through, out of memory

    Hello, Initially i did create a single connection, run all the code and then disconnect once finished. However, the problem occured and since then i have tried a variety of things to try to make it run. One of these things was to keep disconnecting and reconnecting, which was intended to make...
  3. Barntek

    VBA code in Access adp stops running half way through, out of memory

    Hello, The code is below, with the function listed below that. Thanks for your time Barney ****************************************************** Public Sub Profile_Click() On Error GoTo err1 Dim CON As ADODB.Connection Dim rstGROUPING As New ADODB.Recordset Dim i As Integer Dim a As Double...
  4. Barntek

    VBA code in Access adp stops running half way through, out of memory

    Hello, I have written some VBA code in a adp in access using a SQL2K database. The code runs mostly SQL statements using the '.execute' command. There are several loops in the code which also use some recordsets in the data. The code runs fine on my machine, taking about 15 mins to run...
  5. Barntek

    VBA code in Access adp stops running, out of memory

    Hello, I have written some VBA code in a adp in access using a SQL2K database. The code runs mostly SQL statements using the '.execute' command. There are several loops in the code which also use some recordsets in the data. The code runs fine on my machine, taking about 15 mins to run...
  6. Barntek

    SQl 'insert into' in VBA not writing to tables

    I am attempting to use VBA in access 2003 to run a SQL 'insert into' command. The SQL command is part of a loop such that the code updates with a variable string on each pass. The code runs and works, however when running over several passes the SQL does not update the required tables on all...
  7. Barntek

    SQl 'insert into' in VBA not writing to tables

    Thanks for this, i am trying to find the equivalent in ADO but can't so far, can anyone else help? Thanks Barney
  8. Barntek

    SQl 'insert into' in VBA not writing to tables

    I am attempting to use VBA in access 2003 to run a SQL 'insert into' command. The SQL command is part of a loop such that the code updates with a variable string on each pass. The code runs and works, however when running over several passes the SQL does not update the required tables on all...

Part and Inventory Search

Back
Top