Search results

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

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

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

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

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

Hi at the moment im running a shell command to stop my sqlserver 2000. This is the command. this will stop my sql server but i cannot start it again. Unless i log off my pc and log back on again.but if i type this into dos command window not in access. It shuts down perfectly and i can start it...

Hi it might sound a simple question, but is it possible to run a macro stopping the original macro that is running. A Call command runs the macro in a macro then returns to the original macro. This is because i got a strange predicament. I have a code that does a lot of different things and...

Hi can somebody please help me find out why this code will not insert the data into the table. I have spent about 8 hours trying to find out why it wont work. CurrentDb.Execute "INSERT INTO dbo_tblArtist (artist_id,artist_name,artist_description,image_filename) " & "VALUES ('" & aid & "','" &...

Could somebody please help me copy the filenames of an entire folder into a text file with each filename being on a seperate line. Many Thanks

Hi could somebody please tell me why when i use the code below it always fails to import the first record of each file. DoCmd.TransferText acExportDelim, "BackupFolders", "BackupFolders", Environ("USERPROFILE") & "\Desktop\VatBooks\DataBackup\" & TodaysDate & "\BackupFolders.txt", False, ""...

Hi i have 3 listbox's on seperate tabs, with multiple columns. None of them show as being currency. But on 1 computer i have, it does show as currency and is perfect. But my other 2 computers just show as numbers. Very strange. But i dont know the differrence between the computers. They are all...

When i try to compile my database i get this error Invalid use of property Private Sub Combo178_NotInList(NewData As String, Response As Integer) Dim db As DAO.Database Dim rs As DAO.Recordset Dim Msg As String Set db = CurrentDb Set rs = db.OpenRecordset( _...

CAn anybody tell me why this code is giving me an error ' Open a text file for input. inputbox returns the path to read the file Open Environ("USERPROFILE") & "\Desktop\text.txt" For Input As nFileNum lLineCount = 1 ' Read the contents of the file Do While Not EOF(nFileNum) Line Input...

I hope you can help? Why is the code causing this error? vididmax = Nz(DMax("video_id", "TblVideo")) dtan = DLookup("[dtan_lib_no]", "[TblVideo]", "[video_id]=""" & vididmax & """") MsgBox dtan Data type mismatch Im trying to look up the highest video_id and get the data from field...

How can i search my video table for a record that has artistid as a string in one column and VideoName as a string in another column but both in the same record. Many Thanks

How can i change this code so if a record in the table TblArtist has the artist string in the artist_name column and has artistid string in the artistid column of the same record it returns false? If IsNull(DLookup("[artist_name]", "[TblArtist]", "[artist_name]=""" & artist & """")) = False...

Is it possible for me to search a table column for a value stored in a variable using an if statement. eg if variable is in the the table column 1 then do this if not do this Is it possible to do this completly in vba Many Thanks

Grab data from text string I have a text string of # akon - dance How can i parse before the - without the # into one variable and after the - into another variable? Many Thanks