Recent content by empire03

  1. E

    VBA Recordset Update Error 3049

    Vila I have to admit I was skeptical about your suggestion as my Add Columns code was a seperate module that didn't seem to explode the file size by an signifigance when ran it. However when I did put the additional sequencing fields into my MTQ and then ran my code to populate the fields, it...
  2. E

    VBA Recordset Update Error 3049

    LOL, gotta love those tablets! I do not have access to any other tools than the MS Office Suite and a tool call Qlikview... which is actually where I will be pulling reports out once I can get the data churned and setup the way I need it in access. Anyhow bottom line I am limited on resources...
  3. E

    VBA Recordset Update Error 3049

    Good afternoon. I have a table that is generated from a MTQ (Mate Table Query). The table that is generated has 7 columns and around 650,000 records and growing each day. Due to the reporting nature I have the need to add sequence #'s and record counts to the table. I am doing this via 2...
  4. E

    Subsequent subtraction, if the field is null subtract from next one in sequence

    Hi Lidya, do you have an example of what you want for your output??? If possible can you post your file here so we can take a look?
Top Bottom