how to link buttons within access

**helen85** · Mar 29th, 2006, 07:51 AM

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

**Hack** · Mar 29th, 2006, 07:59 AM

How is this related to reporting?

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

**helen85** · Mar 29th, 2006, 08:03 AM

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

**RobDog888** · Mar 29th, 2006, 08:15 AM

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

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

**helen85** · Mar 29th, 2006, 08:20 AM

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

**RobDog888** · Mar 29th, 2006, 08:24 AM

The same database or a different one?

**Hack** · Mar 29th, 2006, 08:27 AM

Access VBA question moved to Office Development.

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

Listbox?
Combobox?

What?

**helen85** · Mar 29th, 2006, 08:34 AM

same database

**RobDog888** · Mar 29th, 2006, 08:37 AM

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.

**LostAngel** · Mar 29th, 2006, 08:59 AM

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.

**RobDog888** · Mar 29th, 2006, 09:02 AM

VB Code:

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

**LostAngel** · Mar 29th, 2006, 10:43 AM

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

**helen85** · Mar 29th, 2006, 10:48 AM

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

**KGComputers** · Mar 29th, 2006, 11:23 AM

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

**salvelinus** · Mar 29th, 2006, 11:50 AM

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.

**KGComputers** · Mar 29th, 2006, 11:57 AM

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..

Thread: how to link buttons within access

Thread Tools

Display

how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Re: how to link buttons within access

Posting Permissions