Search results

Hi, thanks for the quick reply. I want to run this on a button press, and it will be run once a month. But the amount of records in table 1 will be different every month and have different values. Also the column names between the 2 tables are different. I see how i can add the fields from one...

Hi I really hope someone can help me. I have 2 tables and I need to create a record in table 2 for every record in table 1. The new records in table 2 will incorporate 2 fields from the records in table 1 and 3 fields that will be text not from any table. What is the fastest most reliable way of...

Hi Im having an issue with the following code which copys all .MPG files from a dvd disc to a folder on the pc, while copying a progress bar shows. What is happening is sometimes not all files from the discs are being copyed to the computer. But using the same disc it alows me to copy them...

Thank you for your help but i really need to be able to do this purely in vba the previous code is so close to what i want to do. If a vba genius out there could advise me i would be eternally greatful. Many Thanks

Right take 2. This code works but if there is a file on the F:\MediaLib\Video\ named the same as on the d:\, but if there is a file in F:\MediaLib\Video\ that is not on the d:\. The whole application stops responding. Sub Test() Dim Folder1Array() ReDim Folder1Array(0) MsgBox "checking...

Can somebody tel me why this code does not work please. It scans through a directory looking at each .mpg file, which works but when i add the bit in bold it loops through to the same file forever. because i then want to see if that file exists in a folder. MsgBox "checking files that...

Hi how can i in vba code check if a drive on my computer has more than 8gb of free space left. Many Thanks

Hi what code would i need to check a folder contents to another folder contents, and if any 1 file has the same name then End Sub Many Thanks

Ok Ive just split the function into 2, 1 for artist update and 1 for video update. Take 1 i ran the artist update and it worked i ran the video update and it failed. Deleted the newly added artist records from the table (Restart access) Take 1 i ran the video update and it worked. i ran the...

Hi I have copyed my 2 complete sql tables so i have 2 non linked tables with exactly the same data as on my sql server. And it works like a treat. But when i change the table names in the vba to the linked tables only one file gets imported and the second file fails. So your code does work on...

Hi Thanks again for your help. I noticed that your primary key in the video and artist table is an extra field. My first number in both the artist and video tables are the primary keys. But they need to be what i specify in the text file or the whole thing wont work. If you try importing the...

I have tried that too and the same thing happens the first DoCmd.TransferText line gets put into the table and the second one fails. I have also tried including the column headings and change the false to true. But still the same. ~Im confused

As for the linked tables i used the wizard but i think it uses ODBC Here is the Video*.txt 2689,171,3,184,10,,"VDT028543.MPG","RELAX (REMIX)","","2009",1,"0",05/11/2009 10:38:06,0,0,"VDT028543",,"","" 2690,1225,3,98,10,,"VDT028544.MPG","ANYWAY","","2009",1,"0",05/11/2009...

I am a complete newbie at vb but i have bodged together some code that does what i want. The only thing is it sometimes works and sometimes does not. I think i have narrowed it down to the problem of it not successfully adding a record to an sql linked table (sometimes). Can i post my whole...

hi no validation tests are needed. Im trying the docmd.transfertext route now with little success. The wierd thing is im importing 2 txt files 1 into artists table and 1 into video table, when i run my vba code, which ever is first succeeds and the second fails. Any order the second fails. With...

What piece of vba code would i need to add records from a comma delimited txt file to my sql server. i need to use access to ad the records Im really struggling here if anybody can help Many Thanks

Thanks for your reply option 1 i have the user name just not the password. If i am correct the only way to hack the password is brute force. Is this correct? option 2 possible but a pain in the *rse option 3 i cant use another bit of software as the software has been specifically writen to...

Hi im running an sql server and have set up access as a front end with 2 linked tables. I imported a delimited txt file into each of the linked tables with some vba code and it all shows up in the linked tables. But when i view the sql server in mysqlserver manager. No new entrys are in there...

Sorry i keep saying macros. I am only using vba routines. Many thanks

I cannot use detatch as i have not got rights to do so. No one has. The company that built my software that uses the sql server have gone bankrupt. The only thing that has full access to my database is the software. The only way around this is to copy the mdf to my other computer. Attach it to...