Access Database HELP please...?

Question

Ok i have my Access data base, i need to print some labels, but not from all the data base.

I need to extract my Client ID and Post Code and Company phone number which i could bo by their ID number , but how ???

Can i do a search just on my client ID number only , but i need various numbers not just 1 to 100 so example
: 131 / 89/ 335 / 1 / 55/ 741/ 3333/

Does anyone know how to do this please....

Answer 1

The easiest way to get this done would be to add a Yes/No field to the table containing the data for the labels. The new field would server as a print flag. By setting the flag to "Yes" (checked) it will allow you to set up a query for the labels with the criteria for the print flag field set to "Yes" ... along with the other data fields for label printing. This way, only the records that are selected (set to "Yes") will be included in your label run. You could even create another update query to automatically set all the print flags back to "No" after running your labels.

Good luck!

Answer 2

This is difficult to answer without knowing the structure of the database tables. But it sounds perfectly do able.

Is the Client ID, Postcode and Company phone number all in the same table ?
if they are then create a query listing only those 3 fields (or any others u want) and add the condition to the client ID field 'Between ValFrm To ValTo'

Also something to consider for future use - perhaps post ur questions in an Access help forum. This would get your answer quicker with very few spammers.

Answer 3

Warlock is on the right path there, a 3rd option would be to say create a button on an input form so that when you want to print a certain record out that you click this button and it will print out only that information.

However, the drawback with this is that you'd have to be on the record you want to print as it would not print any others.

Or create a form based on a query that prompts you to enter the record ID and then it will locate the details and print them.

Answer 4

Two possible ideas:

(1) Create a form to allow a number range to be given which will in turn run the report that prints the labels

(2) Add a "GroupID" field to group the records together so that you can run a label report by group

The Warlock

Answer 5

Design a query using your table, which looks for only those numbers:-
Field = Client ID
Criteria = 131
or 89
or 335
etc.

Save the query, then create a label based on the query.

Answer 6

i does not matter, you see that small x in the top right hand corner of the screen? I invented that, but got no credit for it . . . . .