Search results

It is because i need to copy over my .mdf and .ldf files and i cant do that when the server is running. There is only one user anyway.

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

Using Call returns the the original macro when the called macro has finished. I need to start a macro without returning to the original macro. I have also tried that but no luck Many Thanks

vba Many Thanks

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 Now im getting this error after the change you suggested syntax error (mising opperator) in query expression "1225 , 'Armand van heldon + ducksauce','','');" Many Thanks

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

I have sorted it. If anybody wants to know i was using access 2003 sp3. There is a known bug in sp3 that causes problems like this. I had to install microsoft hotfix (945674) This solved my problems.

Sorry, Just figured it out. The true at the end needed to be changed to false. Thanks you for you help

Ok I have done as you have said. The code in the first post works as it exports all the records. Its when i call the records back in that it misses the first record from each file. Here is my import code DoCmd.TransferText acImportDelim, "CompanyNames", "CompanyNames", Environ("USERPROFILE") &...

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

Just checked them both and compared. They seem exactly the same, no differences. You are talking about Control panel regional settings arnt you? Many Thanks

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

Wow that does more than i could have hoped for. Could you briefly just explain what that line does. Ive got if something is greater than 0 Thank you so much

It is so small i can post it just copy it into a text file called text.txt # ALEXANDRA BURKE – Bad Boys # DAVID GUETTA FT AKON – Sexy Chick # MADONNA – Celebration # EVA SIMONS – Silly Boy # DEADMAU5 – Ghosts ‘N’ Stuff # LA ROUX – I’m Not Your Toy # CHERYL COLE – Fight For This Love #...

Ive changed it from " - " to "-" and it still is stopping on that line? Wierd Any other ideas Thank you for helping by the way

# JAY SEAN FT LIL’ WAYNE - Down This is the line it is breaking on according to the immidiate window and it is split by a - Any ideas Or another way i can split the line in question? Thanks again

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