Re: Macro for Error Message

Steve,

I will attmept to send the database as a zipped file. The email will come
from jrisk at hsc dot wvu dot edu. Please let me know if you do not receive
it. Our email system (groupwise) has a tendency to strip off certain
attachments because it thinks it contains a virus. Hopefully, zipping the
file will prevent this.

Thanks.

"Steve Schapel" wrote:

Risikio,

Thank you for the very full explanation. I am sorry, there must be a
simple explanation, but for now I can't see where the problem lies. It
seems to me that everything is clear and correct, and it "should" work
as expected.

If you like, you can email me the (preferably zipped) .mdb file and I
will have a look at it. Send it to steves at mvps dot org

--
Steve Schapel, Microsoft Access MVP

Risikio wrote:
Hi Steve,

On the form, the textboxes are unbound. The actual names of the textboxes
are [First Name] and [Last Name].

The database itself is really nothing more than an address book. The users
are required to print mailing labels from this database. The form is
intended to allow the user to either print a single label - [First Name] AND
[Last Name] OR a group of labels - [catergory]. These are the only three
fields/textboxes on the form and all are unbound. Below the textboxes are
three buttons - Print Labels which runs the original macro you helped me with
(null vs. blank) and then prints a report (the actual labels). The second
button resets the form, because I found that the textboxes would work fine
the first time through, but if the user simply deleted what was entered and
entered new data, the labels would not print. This mostly dealt with the
[category] field/textbox. The third button simply closes the form.

I am not sure if the following information will help, but I have included it
just in case it provide some extra light on the subject.

There are four tables in the database - categories, Main, Switchboard Items,
Titles.
There is only one query - Label
There are three forms - Label (the enter information into the database),
Criteria (to enter information to print labels - This is the form we are
discussing), Switchboard.
There is only one report - Labels

The "Main" table has the following fields - Title, First Name, Last Name,
Address, Address2, City, State, Zip, and category.

The query for the report has the following fields - Name: [Title] & " " &
[First Name] & " " & [Last Name]), Address, Address2, CityStateZip: [City] &
" " & [State] & " " & [Zip]), Zip (not shown but sorted ascending for bulk
mailing), category (in the or: row of the criteria
[Forms]![Criteria]![category]), First Name (not shown but in the criteria:
row [Forms]![Criteria]![First Name]), and Last Name (not shown but in the
criteria: row [Forms]![Criteria]![Last Name])

.