Search results for query: *

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

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...

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

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...

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...

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...