how to link buttons within access

i need to know how to link a button which is on a form to bring up a database within access.
thankyou

How is this related to reporting?

What do you mean by "bring up a database"?

erm like click on a button then that loads up a table or form

Are you doing this in VB6 or Access only, or ???

What do you mean by "bring up" or "load"?

i am doing it in Access only. By "bring up" i mean" i want to click on a button and a database will appear

The same database or a different one?

Access VBA question moved to Office Development.

So, you want to load the contents of a table into a....

Listbox?
Combobox?

What?

same database

You really need to explain a bit more of how and what your trying to acomplish.

If its the same database then its already displayed.

I think what he wants if im not mistaking, is to show the data in the table? Like he pushes a button...and the same thing happens as it would if you double clicked 'tblWhatever' in the tables tab.

VB Code:

Private Sub Command1_Click()
    Application.DoCmd.OpenTable "Table1", acViewNormal, acReadOnly
End Sub

:)

That's it Rob...oh...I guess thats what *she* wanted....didn't see 'helen'.

right i want a text box that searchers for something within a database when inputted.
for example i want to search within 2 databases for the word "helen" this will work via a button

Hi helen,

You might want to view this thread and refer to post #4..It's a simple database I attach using search.It uses combobox and not textbox.However, the concept for searching is applied...

http://www.vbforums.com/showthread.php?t=392838

:) :) :)

When you write "databases" do you actually mean tables in a database? It would be considerably more work to search 2 separate databases than to search 2 tables in one database.

Hi,

I agree with salvelinus..You might be referring to two tables..Apply relationship to the tables and you might want to manipulate the data using SQL Query..

:) :) :)