Northwind - customer labels dialog form/macro

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

I liked the Customer Labels Dialog form in the Northwind database so I
thought I would try to make my own for a contact management database. I
thought I would use it to print labels for the various contact types in my
database. Really it is just an experiment in using this type of form with a
macro and learning more about Access generally.

I designed the form exactly as the Northwind one and copied the macro group
to my own database.

I renamed every instance of SelectCountry to SelectContact (which actually
referred to the contact type field) in my own database - as well as renaming
various items.

The problems started when I tried to click the 'Preview' button. The button
did open my contact labels report. However, when I tried to select a contact
type from the combo box, I got this message:

The object doesn't contact the Automation object 'SelectCountry'.

You tried to run a Visual Basic procedure to set a property or method for an
object. However, the component doesn't make the property or method available
for Automation operations.

In other words I was unable to view the labels for a specific type of
contact.

I have spent ages trying to figure out why it doesn't work. In particular I
am puzzled about the 'SelectCountry' bit as I thought I had removed all
mention of this. Does anyone have any idea what could be going wrong?
 
Hi,


It is probably mentioned in a GROUP. A report stores the GROUP and the
SORT (order by) internally, you can display them using the appropriate
button (Sorting and Grouping) from the toolbar, in design mode for a report.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top