Search results

Thanks very much James, very helpful - apologies for the delay in replying, away for a few days... I've now had a couple of successful runs and thought i'd post the code as it currently stands. This code queries a table (tbl_updatelinks - two fields, TableName (text) and Deleted (yes/no))...

Thanks James, unfortunately I know almost nothing about vb and I don't really understand what your code's doing - but I don't want to update all the linked tables as some link to other sources that need to be preserved, just tbl_one needs to be changed. What do you think of:Private Sub...

Change source of linked tables - Solved! I have a db (mydb.mdb) with a linked table ("tbl_one"), currently pointing to a table with the same name in an access db called "sourcedb-feb". I'd like to use vba to open a dialog box for the user to select a new source (like "sourcedb-mar") and to...

Following on from this, is there any way in vba to paste both the values and formats of a given range? I know Selection.PasteSpecial Paste:=xlPasteValues followed by Selection.PasteSpecial Paste:=xlPasteFormats would achieve the same result, but is it possible to do it all in one go? Thanks in...

That's absolutely perfect, chergh - thank you!

Hi Brian - thank you for responding; i've taken a look at offset's help page and unless i'm mistaken it is used within a cell to capture a range elsewhere on the page. What I am looking for is some access-based vba to do the following: 1. Check a table for the "start position" - this is where...

Awesome! Thanks gth, that's very helpful - should be able to do exactly what i need using that. Cheers!

Cheers dk.

I've tried searching the forum for an answer for this but no luck, so posting it... All I want to do is start by selecting a cell, say A1, then selecting a cell say three down and five along. I've tried using: Range("A1").Select Range("R[3]C[5]").Select and swapping out or round the...

Okay, here's the working script: Option Compare Database '------------------------------------------------------------ ' Newham_emailer ' '------------------------------------------------------------ Function Newham_emailer() On Error GoTo Newham_emailer_Err Dim FileLoc As String Dim DraftLoc...

Done it again Chris - thanks so much, it works perfectly! And such a useful thing to know, too. I will post the finished article, well, once it's finished... Thanks again!

Hi again - today's problem: At a given point in a script I am left with an excel document that is linked to data in another excel document; I would like to remove the links and leave only values and to do this from my Access module. I've tried using: objXLApp.ActiveWorkbook.BreakLink _...

Thanks DCrake & Chris - I understand what you and macca are saying about copying first, thanks! The value for xlNormal was also very helpful (- read: made it work :)). I also found a couple of other bits and pieces I was able to copy and paste and I now have a script which extracts the...

Hi Macca - the document I paste into already has the required formatting and summaries; the report is generated on a weekly basis and gets the date included in the filename. I'm not quite sure I understand the second part of your reply - I think you're suggesting running the module in Access...

{1st post} Many thanks to all of you who have helped me in the past, however no amount of searching has given me a solution to this one, so I'm posting in the hope that someone can point out where I'm going wrong... I need a module in Access which: 1- runs a few queries, placing the outputs...