Well, I gave up on this line of thought. [banghead]
Instead, I now have users highlight the records they intend to copy, using the record selector. They can then switch from the Form view to Datasheet view. From there they use CTRL+C or Edit>Copy from the menu bar and then paste into another...
That's a great idea Ian. Thanks.
I ran with it and added some VB code to update the label captions in the forms On Current event.
Bundles_Count.Caption = "Total Bundles: " & Format(Me.RecordsetClone.RecordCount, "#,###")
(The label won't update however, if the form is filtered and the filter...
I should have explained in my post above, that I tried various combinations of "yes" and "no" settings for the Enabled and Locked properties but the text box information from the form footer is still copied.
Max
My Access 2000 database has a number of continuous forms. Some users want highlight records using the record selector, and paste those records into MS Excel or e-mail messages. This is done either by copying and pasting or by choosing Tools > Office Links > Analyze It with MS Excel from the...
I am new in the Access World, so pardon the basic question. But what is the expression that will allow my report to list only one line item with the total number of simlilar items next to it, as opposed to listing every instance of that particular line item seperately?
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.