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...

Do I just put the function in my utilites? I have never done this before. I'm also having difficult with some of the syntax with respect to what is something I need to do to wrap the code onto the next line at what is actually code. I'm really overwhelmed right now. Do you know anybody who...

PS I am getting too many price tags. Not....not.

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...

PS - - Why is the folder red? This question isn't all that urgent? Sue

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

Here are the case notes from my case with Microsoft regarding filter problems. Hope this sheds some light. Sue '''''''''''''''''''''''''''''''''''''' Hi Susan, Good news! I discovered why you were having the problem and why I wasn't. But, more importantly, we have a workaround to this...

'Ol dopey me.....I just found out that I have to have DAO 3.6 Object Library checked in the Tools, References of the Code window. Thanks for your help. Adding spaces to the code stopped the syntax error too. Muchas Gracias

Thank you!! R U working with 2000 or 97? I am in Access 2000. I see AsAccess, AsInteger...everything but AsDatabase. sue

PS - I feel like a total idiot!!!

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 I understand why I need the where clause? Is it to link the form and the report or to create the duplicates. I have tried creating a table through a make table query and then deleting the contents each time I print new price tags, but the code is frightening. I'm willing to do...

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...

Chris - - It works great, but I would also like to be able to put in "fer" and still get "Fertilizer" Is there a way to put a "Like" operator in the code so the user doesn't have to type "*"? Also, how do I get out of the filter? A button that has code with something like DoCmd.RemoveFilter...

Thanks Chris....I'll try it out! Susan

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...

Thanks you guys, it makes perfect sense!!

The reason why I wanted to change the calculation from $ to % is because some of my suppliers charge freight based on a dollar amount and some based on a percentage. I think I've given up on that part, I can just use a calculator, but..... I'm still not clear on the first part. Right now my...

Rich - - Was the article supposed to be a hyperlink? If so, I didn't get it. Can I view it by going to the "all knowing" Microsoft Web Site? Susan