Using buttons with macro in report

[CIIIHAN]

@Robeen


Thanks for going trough all of this!

But if I call the overview page 'ShipmentDetail' and put an openform to ShipmentDetail, won't that just open the already opened page, namely the overview?

But I see what you are trying to do
I'll play around with this one

@TinaCa
No, not quite.
I'll try to explain it again.

I have a database with to many info to show in one instance.
to split it up, I have created a form that shows ALL of the records (See previous post for screenshot).

If one of the record is selected, I want a second form to pop up and shows all the details of that ONE record.

[TinaCa]

Access relies on what is called normalization. Basically don't repeat things you don't have to.

So if you have, for instance a company that ships things you would have the companies it ships to in one table and what was shipped (to each company) in another so you would not have to repeat the company information on each line like on an excel spreadsheet. If you could split the shipping details (what was shipped) into one table and who/where it was shipped to in another, you would put the shipped to at the top of the form and the items or details at the bottom of the page. i.e. form/sub form. I could see this better if you could send me a print screen of the table in design view showing all 24 fields.

[CIIIHAN]

Thanks for your reply!

We have been through the normalization phase. Using one table is the best since non of the shipments have identical information they are all unique.

Creating more table isn't necessary.

FYI the shipments are huge containers so the only info about the product is:
What the boat ships, how much of it and the total price.
This applies to each shipment
Even if the same product is shipped twice the prices vary daily


Thanks for your feedback though it's good to see you're trying to 'fix' the basics.
But the only thing I need to achieve is to op en the selected record and show further details.

[TinaCa]

In that case, do the two forms. You can format them any way that works. You can double click on a specific field (say in a datasheet view) just put the code in the OnDoublClick event (so someone doesn't accidentally open the second form it they just want to click on the record ) Make sure both forms contain the unique identifier for the record. One form has what you need to decide if thats the one you need more information on, the second form would just have the fields you can't see on the first form (Plus the unique identifier).

When I was starting I would create a button to open a form to a specific record then copy the code from the macro and put it in my VBA code so I could keep all the code in one place and it was easier than trying to write it myself.

I would suggest, since you don't want to scroll left and right, that the second form not be a datasheet so you might be able to get all of the other fields on the second form. If you are in Access 2010 you might want to try one of the split screen forms. It would be a datasheet at the top bottom or side and details in the other section of the screen.

Good luck

[CIIIHAN]

Thanks for your suggestions.
I'm making use of Acces 2007.
I've made something like Robeen had suggested yet some users have low res screens.
Because of that its nearly unusable for them.
here is a screen:

(On my screen it show nice )
This one is useless

So there has to be a second form.
I have created a dataview page where the File no is dblclickable
(Just like the screen in post number 7 )
It has this code attached to it.

Private Sub No_DblClick(Cancel As Integer)
DoCmd.OpenForm "detay", , No.Value = Me.No.Value
End Sub

'No' contains a unique code but is not the primary key.
The primary key is the ID which is not shown anywhere

The second screen with details show up, but the 'where' filter doesn't work.

Both the fields where the file no is in are called "No"
I get the right file no when I use MsgBox (No.value).

[CIIIHAN]

I finally got it to work!!

After trying dozens of diffrent ways using VBE and macro's.

Using a macro did the trick.

Thanks for all your help and support

[CIIIHAN]

Guess I had to revoke the 'solved' stamp.

First of all the program works on my laptop like a charm, yet I've sended it to my colleagues, they receive a 'enter parameter' prompt.

why is this?

next I have another question I have outputted the records in an list (as seen at post #7)

Is it possible to put a checkbox infront of each row and change the backcolor of that row to green when the checkbox is checked?
What happens now is that Access looks at the value of the first checkbox if it is checked the backcolor of ALL rows are changed to green.

(Should I open a new thread for the second question or is it ok to put it here?)

Thanks in advanced