I tried using XCOPY but it didnt work. I looked it up and the code should be something similar to
XCOPY "N:\tam\ins.dbf", "C:\Horizon\ins.dbf"
I am programming in visual basic within access and I get an error that says "sub or function not identified" and it highlights XCOPY. Any help on how...
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 tried
DoCmd.RunSQL "SELECT mid([rec],3,6) AS alias FROM driver ORDER BY alias"
also and it still gives me the same error.
A RunSQL action requires an argumnet consisting of an SQL statement.
Is there maybe some sort of library I need to use order by. This is the only part of my program...
I tried
DoCmd.RunSQL "SELECT mid([rec],3,6) AS alias FROM driver ORDER BY rec"
DoCmd.RunSQL "SELECT mid([rec],3,6) AS alias FROM driver ORDER BY driver.rec"
neither one of these worked either. If anyone still has any ideas, please help.
Thanks
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.