Search results

Thank you, That has been one way I have added the information on the report (e.g. Like ([Location]&”*”)) and I enter location. Is there another way to achieve this? This will help with question #2 and for question #1 have you ever set the Parameter Value Box “on close to reopen? I use this...

1. I have reports based upon parameter value in a query. What do I need to add to this that will keep open or reopen the parameter value box after I close the report? 2. How do I format the parameter value box to make the entered information (e.g. Begin & End Date, or Location) appear on the...

Thanks for the help. JWT

Queries: What would be the best way to, I have two tables that do not match. I put in this Expr 1: Right([P/N].2) that is the only item to return data to match the other table. Want to know how to trigger or make the other table enter only the information needed. The small table has eight items...

Here is what I hope to achieve, I have a report/label that I put in a part number using an unbound text box, in another unbound text box I enter a customer number. All the but the customer number comes from one queries and just too many customer numbers to add in to its table. Have a...

Hi, I have a report that I want to Print/view on one page. The report is set to two columns with a total that uses report footer. Sum = ([items]) The total appears on the next page and I would like it to be at the end of the second column. What do I need to change to do this?

Change Print Color If Less Then Zero. Working with Access97 and company is upgrading to Office2000. I would like to have the color change to red if the amount is <=0. Can this be set to view and print red for zero or less but black if >=1? Would Office2000 let me run this type of report? Can...

Hello again, With some work and all the help I was able to get this format to run. Now I have another problem, labels will show on screen the way I have set my skip/print lay out but having trouble at the printers. When sent to our HP LaserJet III the number of labels to skip will not work...

Wish I could get this to work but on luck so far. I ‘m hoping that I can get a step by step lay out of how to set up a way to pick one item to print and be able to skip or print what I need. When I remove the section that allows me to select just one item to print it works but it starts at the...

Thank you Chris, About: ACC2000: How to Skip Used Mailing Labels and Print Duplicates (Q231801) I had set this up about a week ago and hoped it would work. With the first Label report I would click on and put in the box my stock number only one label would appear. With this (Q231801) in place I...

Hello, I want to solicit an item from an inventory Query and use Avery 30-label sheet in Reports/ Label Wizard to print 30 of the same item. I have set up a “dummy” table as decried by Pat Hartman posted 12-4-01, but I have not been able to get it to repeat. This is how I have my query set to...