Recent content by JosjaWillems

Then you may assume that I'm using forms. Now I will reiterate my question: Data is added in Field B. How can I programmatically add the value of Field B to the current value of Field A and delete the value of Field B afterwards?

Of course. I've drawn it out in the attachment. This shows what I'm basically trying to achieve.http://www.mediafire.com/imageview.php?quickkey=snfv8er1fjjir59&thumb=6

Hello, I have a little bit of experience in using VB for Excel, but now I'm starting something new in Access. Somehow, using VB in conjunction with Access seems to be much more difficult to me, so please excuse me for being a terrible noob :) What I'd like the subroutine to do is very simple...

An error without message still occurs sporadically, though not as regularly as error 4605. Perhaps using the 'Dim wd as object' sucks up too much capacity, causing the subroutine to crash sometimes. Also, the IT-infrastructure here is known to be unstable. I don't know if this is relevant, but I...

I'm sorry I hadn't responded yet, but it didn't work. Thank you for your input though. Meanwhile, I've tried using the following line to copy the stuff: Range("A1:B100").SpecialCells(xlCellTypeVisible).Copy I'm thinking Word can't paste hidden cells. That would explain the vague error of the...

So once again, after a few days of use, the same old problem is back. The code currently looks like this: Sub ExporteerZakelijkeBevestiging1() Dim wd As Object Application.ScreenUpdating = False Set wdApp = CreateObject("Word.Application") wdApp.Documents.Add...

I've found it! The cause of this problem lies in copying and pasting multiple times: even though you copy once and paste afterwards, the copy remains on the clipboard. So after copying and pasting more than once, the computer won't know what to paste anymore. Solution: add a...

Right now, VBA even breaks down with a code like this: Sub ExporteerZakelijkeOfferte1() Application.ScreenUpdating = False Dim wd As Object Set wdApp = CreateObject("Word.Application") Set wd = wdApp.Documents.Add wdApp.ScreenUpdating = False wdApp.Visible = True...

As I feared, the error is back. It's the exact same as before. Any other thoughts? The addition of the 'DoEvents' line did change something, however. Sometimes VBA gives me an error that only gives me the options 'Yes' or 'Help' and doesn't give me any information about the error at all...

It seems to work! We'll still need to use this for a couple of days to make sure it keeps working. But for now: thanks man!

Hello, I keep getting the following error while executing a macro: "error 4605: This method or property is not available because the clipboard is empty or not valid" Here is the code (and don't mind the Dutch words: they are irrelevant): Sub ExporteerParticuliereOfferte2()...