Control Button not visible

[fuglyjowls]

Help - I have created a control button in a form using the wizard and in design view it is at the top underneath all the headings (in the form header) but when I go to normal view it is not there. I have checked the properties and it is down as visible yes display always and transparent no. I am now stumped as to why it's not there - any help appreciated!!

 

[KenHigg]

Try format->Bring to front

???

 

[fuglyjowls]

Thanks but that doesn't change anything.

The form header in design view is about 5 cm high with the headings across the top and the button underneath but when I go to normal view the form header is just 1 cm high with only the headings visible - I can't seem to make it any bigger in normal view (I'm thinking maybe the button is hiding underneath but just not visible)?

Any more help appreciated!!

 

[fuglyjowls]

okay - I think I've found the problem there but now I have another - I want to see the button at the top in datasheet view - is that possible?

Thanks

 

[KenHigg]

Hum...

I don't think I've ever seen that...

 

[fuglyjowls]

Ken

Thanks for your help here - perhaps you can suggest another way around - I want to be able to see all the records in rows (like in datasheet view) but with a control button at the top linking to a report so you can click on the row you want then click the button to get the report for that row.

Any suggestions?

 

[KenHigg]

Hum...

Maybe you can do a subform where the flds are lined up horiz. accross the form and then set the 'default view' to display in 'continuous forms' view...

 

[KenHigg]

Hum...

Maybe you can do a subform where the flds are lined up horiz. accross the form and then set the 'default view' to display in 'continuous forms' view...

 

[fuglyjowls]

Ken

Thanks - I think I've found another way - by creating a macro so that when I double click on the name I can open the report. However I've now hit another snag which I think I need help on The report which I want to open automatically asks for name and delivery date. This information is already in the form so I want it to automatically supply this information on the double click - is this possible?

You;ve been a great help so far - can't believe I'm having to get help from the other side of the world though!! - isn't the internet wonderful

 

[KenHigg]

If the form is open when the report opens, you should be able to reference with something like:

forms!myForm!myTextBox

 

[fuglyjowls]

Help needed again please

I have now changed the report so that it doesn't physically ask for the name and delivery date.

I have managed to link the report to the form where you can double click on the surname and the report opens automatically BUT I want the report to only show the data from the record that I have double clicked - at the moment the report is coming up with thousands of pages - one for each record on the database.

Can you help with this? You are a lifesaver if you can!

 

[KenHigg]

You can use the data in the text box on the form as a parameter in the reports underlying query.

Make sense?

 

[fuglyjowls]

sorry it doesn't make sense - pretend I know nothing!

 

[KenHigg]

In the reports underlying query, in the fld that you want to limit on, use something like the following on the criteria row of the query builder grid:

forms!myForm!myTextBox

 

[fuglyjowls]

sorry to be a pain Ken - that works but you have to manually type in the surname. I want it to automatically take the details from the double-click (if you follow me) so that you don't have to input anything just double-click and the record opens.

Any ideas?