how to link buttons within access [Archive]

PDA

Click to See Complete Forum and Search --> : how to link buttons within access

helen85

Mar 29th, 2006, 06: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, 06:59 AM

How is this related to reporting?

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

helen85

Mar 29th, 2006, 07:03 AM

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

RobDog888

Mar 29th, 2006, 07: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, 07: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, 07:24 AM

The same database or a different one?

Hack

Mar 29th, 2006, 07: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, 07:34 AM

same database

RobDog888

Mar 29th, 2006, 07: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, 07: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, 08:02 AM

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

LostAngel

Mar 29th, 2006, 09:43 AM

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

helen85

Mar 29th, 2006, 09: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, 10: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, 10: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, 10: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..

:) :) :)