Search results

Thanks DBGuy...well, for the normal (nonSP) network share the txtLink holds the full share path of the file, so in my environment that's an S:, but i've got the Sharepoint root folder (\\teams.tees.ac.uk@ssl\sites\6\1) mapped to a T: drive. So for example on SPoint UNC it would be...

Hi, I'm a little unsure of which direction to go with this. I'm not sure it's possible, I've looked all over but can't find a clear replacement for the code below to work with a SharePoint doc library. (I've been using it for years just fine with standard network folders) What I'm trying to...

And a beauty it is too - he has such elegant scripts that fella. Worked exactly like I needed it to with not too much adjustment at all.

Hi, - I'm a bit flummoxed as I edit table data in query based forms all the time, but I just seem to have hit a brick wall. I'm guessing the way ive got the tables set up is not really very good, but I've done much worse and been able to edit table data through a form based query. I included a...

Ah, brilliant, thankyou Gasman and Cronk. I couldn't get the nomatch to work, but then I think i may have missed off the Do While...I'll have a good look at the link you gave me as well, and bottom out this looping function. All I have to do now is get it stop giving me the 'Run-time error...

Hi - Thanks Gasman and Cronk for your contributions I have amended the script in line with your recommendations - posted below. I'm not sure how to get it to loop through all files though as you suggetsed, My understanding of looping needs work - I'm reading up on it at the mo'...Any hints as...

Thanks Gasman...it does appear to loop through both sets of records as it successfully matches the File name in Windows with the UUID in the recordset, then replaces the File name in windows with the more friendly 'Title' field in the recordset. It just stops after replacing 5 filenames...

Sorry - yes, the form is actually the query dragged onto the form, so it functions like a recordset - so the recordset is referenced as "frm_qryChangeFNameRS_subform", but that subform's underlying query is actually "qryChangeFNameRS". The Subform is on the main form frmRenameExportedFiles...

Hi, I got the below code to work. But it didn't loop automatically, I had to keep pressing the command button to make it find the next match and change the name. Also, After changing the file name fine the first 5 times, it gives the error the 6th time: "Run-time error '53': File not found"...

Thanks for prompt reply! I have to nip to dentist now, but I'll tidy up what I wrote when I get back. By 'Recordset' I meant the name of my recordset, which is actually 'frm_qryChangeFNameRS_subform'. Many Thanks, I'll post again shortly.

Hi, I'm struggling to concoct some vba to rename some files in a folder. The problem came about because a web portfolio system at work exports files for students with a SQL UUID - meaningless string - instead of the Title. So they have a folder full of files they don't recognise without opening...

Oh, lovely - thanks! I didn't think to do this using duplicate values, I was getting lost thinking about different numbers for each value. Simples!! Many Thanks

Hi - Is there a way of forcing a value in a listbox or combox to the bottom of the list, even though though the rest of the list is sorted a-z? It's a two box conditional combox thing, the list in Cat2 is selected from the Cat2 table depending on what was selected in Cat1 cbobox, so I can't...

I've had this problem too a few times, and it normally goes when I compile the database, which in my case at least usually finds code referring to now deleted controls for example. Delete the control reference from the code, and recompile until no more issues found.

That's just utterly brilliant of you to help me so quickly, and of course it runs like a Rolex. Many Thanks! I can do some serious tidying up now on my other DBs and any new ones.

Hi - I think the answer to this will mean much leaner databases for me in future.... In a nutshell, I have a form that looks at an attendance table, and all data can be amended on the form if needs be except the User, as it has a foreign key in the attendance table, but I need to reselect by the...

Hi to all. I've been using access for about 5 years now, but I learnt from books and hence have loads of bad habits, yawning gaps, naïve code etc, but I am able to get stuff doing stuff for people! I'm trying to improve my skills, and become more professional with the code I use. I guess I'm...