Ok - this is probably very simple but I'm having such issues with it.
Problem
I used one of the created Access databases (the services database) to create a database for my home business. It's great, and I love 99% of it, but I do have a couple changes I'd like to make, but I don't know how.
I have customers already entered into the database. I also created a report that will print the address on an envelope using these directions...it's setup on the report using the below format:
=Trim ([FirstName] & " " & [LastName])
=Trim ([Address])
=Trim ([City] & ", " & [StateProvince] & " " & [ZipCode])
The report looks great - but it prints every single customer in my database...on separate envelopes, but it doesn't limit the envelope to just the record being shown.
I wanted to create a button on the customer entry form that would link the form to the envelope report, and have the envelope report print ONLY the customer data shown on that form (not all customers). I don't want to have to open MS Word every time I want to print an envelope.
I have already gone thru the process of making sure my database is a desktop not Web based database (copied everything to new)....and I have tried to use this Macro WHERE description, but it again shows every envelope, not the one linked to the Customer Details only.
= "ID = " & Forms!CustomerDetails.ID
Can someone explain how to do this - and explain it in simple terms...I'm still a newbie at Access.
Thank you for your help :0)
Problem
I used one of the created Access databases (the services database) to create a database for my home business. It's great, and I love 99% of it, but I do have a couple changes I'd like to make, but I don't know how.
I have customers already entered into the database. I also created a report that will print the address on an envelope using these directions...it's setup on the report using the below format:
=Trim ([FirstName] & " " & [LastName])
=Trim ([Address])
=Trim ([City] & ", " & [StateProvince] & " " & [ZipCode])
The report looks great - but it prints every single customer in my database...on separate envelopes, but it doesn't limit the envelope to just the record being shown.
I wanted to create a button on the customer entry form that would link the form to the envelope report, and have the envelope report print ONLY the customer data shown on that form (not all customers). I don't want to have to open MS Word every time I want to print an envelope.
I have already gone thru the process of making sure my database is a desktop not Web based database (copied everything to new)....and I have tried to use this Macro WHERE description, but it again shows every envelope, not the one linked to the Customer Details only.
= "ID = " & Forms!CustomerDetails.ID
Can someone explain how to do this - and explain it in simple terms...I'm still a newbie at Access.
Thank you for your help :0)
