New to access - want to create a summary page based on selection

[fekish]

Hello,



i am new to Access, although i was at an advance level in Excel.

I created a database with a list of companies, with many details in separate tables linking them - shareholders, directors, address etc.

Now i want to create something where the user will be able to just Select the company, and the information would be shown below just for that company. I would want to design of course in order to appear nice.
I am trying everything the past day, but with no success!

Any help please?

[ranman256]

make a form, this form is a SINGLE RECORD form connected to the company table, tCompanies. (use the wizard).
now on the form, put a listbox.
The listbox is connected to a query, say, qsCo. this query pulls the list of Comanies and their ID only. select COname, CoID from tCompanies.
set the name of the listbox , lstCO (in the property NAME)
set number of columns, column count = 2
Set the listbox columnwidths to: 3;0. (so the ID is hidden)
set the listbox.boundcolumn = 2. (the ID) user will select 1 of the comanies in the list. Then the form will filter on ONLY that company.

in form design, select the list box. in the event: AFTERUPDATE (of the list box) put this filter code:

Private Sub lstCO_AfterUpdate()
Me.Filter = "[coID]=" & lstCo
Me.filterOn = True
End Sub

user will select from the list, this company will now filter.
to go back to seeing ALL companies in the form, click the APPLY FILTER icon at the top menu bar (turns filter off)

[fekish]

Thanks,

i tried, but couldnt do correctly anythign from the above. Will try again a bit later being more concentrated!

[fekish]

I tried, but couldnt do your solution in the end.

I think my easiest path, would be to create each table as a separate Tab in Excel, and with Formulas do what i want in a Excel...

Access doesnt seem to be my best!!

[Homegrownandy]

Dont give up!

[fekish]

i know - but i cant figure out anything from the help i got above!

I just want to select the name of the company and then show the information from various tables just for that company! Arghhhh

[Homegrownandy]

use the form wizard to put all the information you require onto one form.

make a search form or one were you can select the company.

add a button and open form showing specific record.

[fekish]

use the form wizard to put all the information you require onto one form.

make a search form or one were you can select the company.

add a button and open form showing specific record.

Thanks,

i did a form using the wizard, to be precise:
Now i can see a Form with a table showing:
FULL NAME - Secretary - Start Date - End Date

However when i click to select a company in FULL NAME, nothing changes in the cell next to that.
Is there a way to link Secretary, so it would show the data depending on FULL NAME?

[Homegrownandy]

change it to a list box mate. also on that form you need a control field.

basically you need the link between your records on the form. Lets say your link or key is Company ID. you need to have on your search form a text box with this information. You can turn visible to no, so it cant be seen.

then have company ID on the form you want to open and the information is pulled through that relationship.

I'm sure I haven't explained it very well, but hopefully it helps.

[fekish]

In the end, transfered all data to Excel, and in an hour managed to do what i wanted, and works flawlessly

Thanks everyone for their efforts...

[Homegrownandy]

Haha, at least you have what you needed.