|
Subject:
|
Edit-add new entry to an acces table from word
|
|
Posted By:
|
matpen
|
Post Date:
|
12/30/2005 8:31:38 AM
|
I want to display using vba and Word 2003 a list box that reads an access table and allow me to edit or add an address. The table consists of simply 9 columns of address items. I don’t seem to come round to it?
Thanks in advance!
Elie
|
|
Reply By:
|
penta
|
Reply Date:
|
1/5/2006 12:38:17 PM
|
Hi Elie,
If u want a window that allow u to edit and add an address, u dont need to
use Word. This task is a default task of Access. Click on the form tab of
the access db and on the form wizard after u have built the address table
using the table wizard on the table tab.
Rgds,
P
|
|
Reply By:
|
penta
|
Reply Date:
|
1/5/2006 1:19:28 PM
|
Hi again,
If u want opening a doc on Word and edit-add an address on the doc, i've no
idea if that is possible.
P
|
|
Reply By:
|
matpen
|
Reply Date:
|
1/5/2006 5:18:25 PM
|
Hi Penta!
Sorry but it was not very clear the way I formulated it. I have a small VBA program that types an address in a letter using a database made with access. The programm reads the table where the addresses are stored and pops with a list box with all addresses. The user select one of them and the program types it where it should be. The problem is, if it is a new address, then I have to find a way to now edit (with a pop up form) that table and include in it this new address and it should all happen from Word using VBA!
|
|
Reply By:
|
matpen
|
Reply Date:
|
1/5/2006 5:30:06 PM
|
Sorry it is me again!
I want to say that it is possible from word to read and edit a table, something I am nearly sure of. the problem is time... I am not where I should be and thought maybe someone could have a quick answer to my little question. In the meantime I solved it all except the question of EDITING the table of access directly from word.
Anyway, thanks for your answer!
Elie
|
