Access 2013 adress card

Hi, i need to build for a customer something in access.

he has a small brother label printer and he want to print an adress card when a repair comes into the shop.

he has his customers in exell. how can i create a form fitting on the label with a drop down list of the customers so that he can choose and print a adress label of the customer he needs.

or is there other software available for this? or does anyone already created somthing like this?
Rik Van LierCEOAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
1.  you could link the Excel spreadsheet into Access using the "Get External Data" item on the Ribbon.

2.  Once you have done that, create a form that is based on that linked table.  If you use the form wizard, it will allow you to select the controls from the table that you need to see.

3.  Then create a report the same way.  But when you create the report, you will have to identify the size of your Paper (label).

4.  Then go back to the form, add a dropdown in the form header using the control wizard.  At some point, it will ask you what you want to do with the selected item, indicate you want to go to a record.

5.  Then add a command button (Print) on your form using the wizard.  It will ask you what you want to do indicate you want to print a report.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
<No Points wanted>
he has his customers in exell
Then follow what Dale posted, ...but later, consider *Importing* the data to Access, ...(instead of linking)

Once the data is in Access, then he does not have to use Excel anymore.
You can design a form in Access that looks like Excel (Datasheet view)
Once he sees the level of control you have over the data (in Access), he may not ever think of Excel for tasks like this anymore.
(Which will translate into more work/$ for you...)

But again, get this all working with linked tables first, following the steps Dale has outlined above.


Rik Van LierCEOAuthor Commented:
when i do step 4 and i print the form he prints everything. also when i select 1 customer is step 4.

i also want to add somehow the problem discription for the repair. this has not to be saved but printed on the form.

i added my creation in zip.. with dummy customers.
Dale FyeOwner, Developing Solutions LLCCommented:
Couple of issues.

1.  You didn't use the control wizard when you created your drop down list.  If you had, you would have had a rowsource assigned to the dropdown list and would have had code (macro) in the AfterUpdate event of the button to filter the current recordset to the selected name.

2.  I added a button which opens your report to the currently selected record, but this report is based on a piece of paper, not a label.  You need to click the Label button in the Reports section of the ribbon.  Report labelThis will popup a label wizard which will allow you to select the size and type of your label and select the fields.  Once you have designed your label, you should use the control wizard to create a new button to print your label.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.