Search results

I'm probably digging up an old topic, but here goes. Is there a way to make a report behave like a datasheet and hide different columns? For instance....I have a Purchase Order that has Costs, Retail, Received, Back Ordered, Name, Other Name etc. I need to view this information in umpteen...

I have been working on trying to create duplicate price tags for the last two weeks. I created a button with the following code behind it. It works without any errors, but I'm not getting too many price tags when I preview the report. I tested it with two items on order and I got over 5 pages...

Because I am a garden center, we use things like Feet and inches. I know that apostraphes are reserve characters but what about Pound signs "#"? Thanks Sue

I am trying to copy some code that Chris gave me earlier this morning, but I have no programming experience. Does anybody know why I am getting an error "expected end of statement" with the following code? strSql = "Select DescripName,ProdSize,ProdRetail,ProdID,POID,OrderTotal FROM qryOrders"...

I have been working with Microsoft on a search form and they discovered that there is an bug in the filter that was created with the SR-1 release of Access 2000. The problem doesn't exist without SR-1. They gave me a work around, but it doesn't work. Go figure. I'm at home right now, but can...

I'm not sure if I should be in the Forms forum or report forum....but here goes. I'm trying to view/print duplicate price tags for products based on the quantity on order. In otherwords, I have one line item in the Orders Form that has 10 items on order and need to print 10 price tags for that...

I have been reading previous topics relating to creating a form search and I'm still not clear. I want to create a search/filter for my main form "Products" based on a value and/or values that I enter for CatID, Name, Other Name. I would like to be able to enter one or all of my values to help...

First of all, I would like to say thank you to everybody who helps out with this. I have spent endless hours, banging my head against the wall and talking to MSAccess support engineers for a umhum..."nominal fee." This is the first website that actually makes sense, Thank you, thank you, thank...

I am trying to build an inventory control database for our family business. Thus far it is going pretty well, but I'm stuck on some of the calculations. I was wondering if anybody had any insight regarding the following. Summary: Trying to calculate the units on order for each order by...