Recent content by Susan Allen Wyoming

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