Ask Experts Questions for FREE Help !
Ask
    esperanto234's Avatar
    esperanto234 Posts: 5, Reputation: 1
    New Member
     
    #1

    Jan 19, 2010, 10:52 AM
    Fill Userform From Database
    Hi, This is the Ultimate Question!!




    I already finished my program in VBA, it has a userform for filling data into Word.

    It has a bunch of textboxes.

    But people has to fill de information into the textboxes every time they open the userform. Information that is already in a databse in excel.

    My question is: How can I do to fill automatically some textboxes in the userform, when it's open, base on a database in excel?

    This databse has in every line a unique ID, so it's impossible to repeat the same subject.

    For example:

    ID NAME ADDRESS PHONE
    1234 Phill Smith Street 0987655543
    1443 Eddy Lincoln Street 0923455668




    TEXTBOXES NAMES:
    Id.text
    Name.text
    Address.text
    Phone.text




    THANK YOU VEEEEEEERY MUCH
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    Jan 19, 2010, 11:44 AM

    You need to connect to the database. This can be done in a number of different ways. I would search the WEB for examples of connecting a VB app to an external database file.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Toilet continues to fill but it does not fill [ 4 Answers ]

My toilet continues to fill and fill but it never does get filled. I googled this and found a lot of help and have searched this forum but I couldn't find an answer. - I noticed a leak at the top of the tower which has the rod then the ball thing attached to it, I tightened those screws at the...

Bathtub Dap-out -- to fill or not to fill in? [ 5 Answers ]

Here is my situation: I have a house on a concrete slab that unfortunately sits right on top of an underground spring (we have several springs on the property). This was discovered by finding 4-6 inches of water throughout the entire finished basement (and destroying everything down there) right...

Database [ 2 Answers ]

Hi there! I would like to have some detailed information about This topic:- Specify the hardware needed to support Database system, supporting your reasoning with argument and a detailed rationale. Waiting for your reply Cheers Reetika


View more questions Search