Recent content by Directlinq

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