hi,
i wonder if anyone can help with this problem i cant seem to work out.
i have a bound form linked to an orders table, including some required fields. when i use the navigation buttons of the form to scroll thorugh the orders i can get to the end where the form expects you to make a new order. but i have a button to add a new order.
i want to stop the user being able to go past the last record in the orders...
leemansiuk
Last Activity: Jul 7 '06, 02:58 PM
Joined: Jun 9 '06
Location:
-
MS access form problem
-
thanks for that. it worked if the report went over 1 page long. displaying the footer only on the last page.
but was causing a problem when the report was only one page. i checked the code and it seems right to me. i think there must be a problem / bug with access. with a report of one page in length, the method runs a couple of times with the value of Me.Page and Me.Pages as follows
1st time
Me.Page = 1
... -
still got a problem
Yeah thats right, thanks.
but that still doesnt fix the problem. as it displays the page footer on every page. whereas i jst want to display my message and stamp box on the last page. which could be the 1st page (if a small number of order items) or many pages (with a large order)
does that make sense?Leave a comment:
-
report footer location problem
hi all,
i am quite new to access and have come stuck on quite a simple problem (i think). i have created a report which list items from an orders table etc..
as the report could grow (listing lots of items from an order), i want only the last page of the report to display a message, i.e. Regards, and a space for a signature, along with a box for a autorised stamp.
I tried using the report footer and put...
No activity results to display
Leave a comment: