Search results

  1. L

    last row

    will give it a try, cheers mate
  2. L

    last row

    hi, i know this is stupid of me but how can i select the data in the last row of one table and then search another table for that value? in one smooth operation / query cheers for any help
  3. L

    DoCmd.RunSQL

    thats cool, but for the fact i do`t wont to and will get my arse kicked if i delete data. so is there any way of reading one row of data into corresponding variables then inserting that into the new table i have done a similar thing to this in ASP when at uni but that was year ago and that not...
  4. L

    Copying records with vb

    ignore last message posted to the wrong topic later
  5. L

    DoCmd.RunSQL

    thanks for that, i got that to work but that replaces all the fields in the new table, what i need it to do is add new fields to the end of the table. is it possible to use variables and read data into them so i can validate it, and then insert it to the new table? if so how? cheers again
  6. L

    Copying records with vb

    thanks for that, i got that to work but that replaces all the fields in the new table, what i need it to do is add new fields to the end of the table. is it possible to use variables and read data into them so i can validate it, and then insert it to the new table? if so how? cheers again
  7. L

    DoCmd.RunSQL

    does anyone understand this coz i have been playing about for a awhile and being kack at VB i keep getting errors, so could someone do a quick example of this statement and explian it coz the only one i can find is in the help file, and that is no help at all. cheers again.
  8. L

    Copying records with vb

    hi, i need some help as me and vb are not brill, so here goes: i need to copy selected fields out of one access file and place them in another table in another file, the way i thought of doing it was to link the tables all in to one file and the write some code to copy these rows out of one...
Back
Top Bottom