Search results

Pat, Again you come to my rescue. I didn't even know that I had a problem and you fixed it. Everything is great now!! You're the best. Hope all is good with you. Stephanie :)

Shadow, Hmm... well I don't know what I did, but as I was stripping down a version to upload, I fixed the problem. It now only opens the current report without asking for the RequestID. Yeah!! Yes, the fabulous people on this forum have been amazing! What a great place to learn!! Thanks...

Shadow -- You are a star!! That works!! Yes, the RequestID is the primary key and on the form. So, now when the button is pressed, a dialog box requests the RequestID and the report is that alone. Perfect! My gratitude to you and Tim for your expert advice. Whew! Now I can close these huge...

Dear Tim, Thank you for the help your suggestion does open the report, and but each form is not its own report. It makes all of the information in the underlying table into one report. It does not recognize any parameters for the report. What I would like is to make it so that each form is its...

I have a form where information is entered into one db. I would like a button on that form that would take the information being viewed at that moment to a report in Preview mode. I have already set up the report. I have a button on the form that opens the report in Preview mode, but it allows...

Thank you for the input. It still didn't work, but I used DLookup and now it is working great!! All fixed. Just in case anyone is interested here is my code for that (I actually have two items it is looking up): Private Sub ProductName_AfterUpdate() On Error GoTo Err_ProductName_AfterUpdate...

OK, I have been looking at other posts and using some of the suggestions there. Unfortunately, the ones that seem to answer my needs have problems, but are so old I don’t think it appropriate to contact the posters now. So here goes… I have a table called tblProducts. I then have a form called...

Jon, Thank you that did the trick! Now if I could just get the other equations to work I would be a happy camper! Best to you, Stephanie

Dan, Now I have a bigger problem with all of this. Not only can I not seem to get the two events to happen when put together, but now, I can’t seem to get the auto fill code that was working to work. Any thoughts? Here is the autofill code for filling the Spoilage and the Freight fields (yes...

Simon, Thank you! It all seems to be working great now! Best to you, Stephanie

Does anyone know, can I have two AfterUpdate events happen from the same field? I have a “Distributor” field which is a combo box. This box triggers a cascading combo box effect so that once the Distributor is chosen, the “Warehouse” field, also a combo box, only allows for the choices...

I've got a query that I have copied from the Northwind database in an effort to understand how they have calculated their subtotals on their order form and order subform. I have changed the names of the fields (obviously) to match the names of my fields. Here is the SQL of the Query: SELECT...

I am having a strange problem I cannot figure out. I have a main form for sales orders, with a subform where the products sold is entered. On the subform, there is a combo box for the products. I have created a one-to-many relationship (with enforced referential integrity checked) between the...

Tom, OK, this is not working. I have two concerns, first when I add AmountDiscounted & ExtendedPrice (respectively) to their control fields, they become the control field and I loose the equation that was driving those fields. If I put it before the = sign, I get “Error” in the field. So, I...

Russ, Thank you very much for your help. I have to run at the moment so I will look at it later. I have found out that what I was looking for was called "Cascading Combo Boxes" I put another question out there on the forum once I found this out. Some very helpful people have also posted...

Chris, You are a life saver!!! I only have a moment right now, but it opened great and I was able to take a look at the querys and events and it all looks very simple and do-able!! I can't thank you enough! Stephanie :D

Perhaps I’m super lame, but I couldn’t find anything on Cascading Combo boxes at the MS Download Center.

Tom, OK, I wrote the Select Query, but now I don't quite understand what I need to have as the control source for my Amount Discounted field, and my ExtendedPrice field. These are both line items fields, then the Sum is a sum total for the subform. But I would actually rather the Sum be on the...

Rich - A combo box wouldn't work because I need the numbers to be taken from the Distributor information directly. Not every Distributor has spoilage or freight allowances and this way the data entry person doesn't have to look anything up. Less chance of making a mistake and quicker too. Paul...

Cascading Combo Boxes, yes another question on these. I know that there is a lot of information regarding Cascading Combo boxes, but I cannot seem to find exactly what I need, so I hope someone out there will help me out, as so many of you on this forum already have. First, you must know that...