Search results

I've got a number of different append and delete queries running on command on one of my forms, in which it makes a copy of all of the data on that form and included subforms, copies them into another table, and then deletes all of the data from that record. When this runs, I get an error saying...

Ok i'm using this: Dim FSO Dim sSourceFile Dim sDestinationFile Set FSO = CreateObject("Scripting.FileSystemObject") sSourceFile = BackEndLocation sDestinationFile = strFolderName & "BackEnd.mdb" FSO.CopyFile sSourceFile...

haha well yea :P with that link what does it mean when it says : Note you need to include a reference to the Windows Script Host How???

Does that work for UNC names though? Basically what i'm using it for is making a copy of the backend that is currently linked to a location that the user specifies, but on some of the machines, the backend may be located at something like: //PC1/documents... Will this still work??

Not really sure tbh. When i was first looking for solutions, this was the easiest (that I found) and got working. Now it doesn't work and I don't know why? :( Do you have a link or the code for the FileSystemObject??

Got a slight problem with a file copy function in my System. I have the following code in a separate module: Option Compare Database Option Explicit Declare Function apiCopyFile Lib "kernel32" Alias "CopyFileA" _ (ByVal lpExistingFileName As String, _ ByVal...

Ah don't worry people, have sorted it out now :D Thanks so much for all your help, really appreciate it :D Aidy

Thanks KeithG, unfortunately in access 2007 there is no tools menu. They've COMPLETELY re-vamped the entire thing so yea. haha. WayneRyan i've had a look around and found some code, so will try and get that to work. Thanks for all the help people, really appreciate it :)

Yea i'll fiddle around with that. I may do what i'm currently doing (only recently) where as if there is no picture to be linked, the picture box is hidden, and the embedded picture is visible (as it is underneath) so I may just say for that half second to hide it, then if there is a picture to...

Hiya, thanks so much! Seemed to work perfectly :D Was becoming a complete pain. The only slight glitch with this is that for that half second it keeps the old picture there when you change records but this one I should be able to solve :) Thanks again Aidy

Thanks for the responses people, really big help. WayneRyan I don't know if that code works as it is giving me the error "Object Required" and then highlighting the "For Each tdf In dbs.TableDefs" line ?? This is the code i'm trying to use now: Dim BackendLocation As String BackendLocation...

Alright cool thanks. I'll look through, see if i can figure something out. Will post back later. Thanks :)

Alright i'll give it a go. I'll try later today, as I've gotta try and find (again) where the setting to show system tables is as i've forgotten, then will have to alter things as the data that would be required for the query is currently stored in a variable so at current it can't be done. I'll...

Yea i'm pretty sure they were and someone else said that they were, but I thought i'd give it a shot before i posted here. Guess it wouldn't work which sucks :(

nah, still giving me the same error with this: DoCmd.RunSQL "UPDATE MSysObjects " & _ "SET Database = '" & strInputFileName & "' " & _ "WHERE (((MSysObjects.Database) Is Not Null));" :(

I've looked all through this Forum and through Google and found a few solutions but have struggled to get them to work exactly as I'm after. What I'm looking for, is some code that runs when the system is launched, which checks to see if the backend exists. If it doesn't, then bring up a file...

Oh right. May be a new feature on office 2007. Does it have to be the ctrl+F search function? If not you could create a custom function and get it to run that instead?

Nah that's still giving the error of Invalid Syntax :( Basically i've created a function where as it checks to see if the backend of the system actually exists, and if not, forces the user to select a back end file, and then use that code to write the new location into the table to access knows...

I'm using the following SQL to update a table, however it is throwing back an "Invalid UPDATE Syntax" error message. DoCmd.RunSQL "UPDATE MSysObjects " & _ "SET Database = strInputFileName " & _ "WHERE Not IsNull(Database) ;" Could someone possibly help me as to what...

brilliant! Works perfectly. Thanks so much. As i say i had tried to do it with a loop as they're better, just couldn't :P Thanks very much, big help! :) Aidy