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 Chriss Miller 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: *

  • Users: iroosma
  • Content: Threads
  • Order by date
  1. iroosma

    delete duplications

    I am joining two tables together and my final product has many duplicate entries. How can I delete all of the duplicate entries. Thanks
  2. iroosma

    FileCopy for access in vb

    I am trying to copy several files from a network to the C drive. I am currently using this code. FileCopy "N:\tam\ins.dbf", "C:\Horizon\ins.dbf" This works sometimes on some files but not on others. I am copying all the files by just changing the 'ins' to whatever the dbf file I am copying...
  3. iroosma

    copy table to hard drive

    I have created a table in access and now I want to copy that table to the C drive as an individual DBF file. I am using visual basic in access and I can not figure out how to do this. Any help will be greatly appreciated. Thanks
  4. iroosma

    SQL make table query

    I am trying to update code from an old program. The old code is SELECT ins.CNAME,ins.ATTN,ins.STREET,ins.CITY,ins.ST, ins.ZIP, policy.BCO, policy.POL, policy.EFF, policy.NEXP, ap3dbfb.YEAR,ap3dbfb.MAKE,ap3dbfb.MODEL, ap3dbfb.VIN, ap3dbfb.ST, carrier.CNAME, ins.REC INTO...
  5. iroosma

    SQL order by problem

    I am currently using this line of code to oder a table based on the values of rec. DoCmd.RunSQL "SELECT mid([rec],3,6) FROM driver ORDER BY rec " When I run this it gives me an error saying that what is inside the quotes is not an SQL statement. Can someone help me out and see what the...
  6. iroosma

    add column of data to table

    I have a table that I need to add a column to. I have the column in another table. I basically need to copy it from the original table and put it on the end of the other table. When I do a SELECT INTO the data gets put at the bottom of the new column, I need the data to be at the top of the...

Part and Inventory Search

Back
Top