Search results

Thanks Bob, ive done it that way and it works now. Got another problem tho haha. The results of my invoice are duplicating. For example. If the results contain 2 rows then it shows all of the detail section of my report twice, 3 rows then 3 times. I just want it to show one data set! Thanks...

Hi Bob, thanks for your feedback. That would be a good reason why they arent showing! I followed your instructions and made a GROUP HEADER and GROUP FOOTER. Thankfully they now show in the subreport, the problem i know have is this... My subreport is an invoice. Each for on the invoice has...

I have a subreport in my main report. In design view the header contains label boxes, the detail contains the text boxes and the footer contains some other details. However in layout view and when i view the report normally it only shows the detail!? I need it to show the details in the header...

I have two boxes, one contains an order date and one contains a required date. I have code that compares these so if the required date is earlier than the order date an error message shows. If this occurs then i want some code to clear the two boxes ready for new dates to be entered. Here is my...

Haha i should have waited! Thanks anyway Mstef! I just managed to work it out myself! Didnt realise there was another way of referencing fields. Thanks anyway!

I have a form called F_Specify_period. It has two boxes on called 'Specify start date' and 'Specify end date'. The users can currently choose dates in this box using the calendar. What i want to happen next is that they hit a 'find order' button. This button will find all the orders that relate...

Thanks again John, Well i have put it in the before update on the form anyway. The only thing is how do i test it to see if it works? The whole reason i want it is so that i can validate the dates are coreect before i confirm the order. Can i assign a button to the before update? Or is there...

The code is currently in a module. Apprently i have to have it in a module. Where is the forms before update section? Thanks for your feedback!

On my main form F_Orders i have two text box's. One contains and order date and one contains a required by date. I want to create a macro or something that will check the validation of these entries before the order is confirmed. In this case if the required date is earlier than the date...

Thankyou so much lcook1974! Works exactly how i needed it to! Think i better look up some of the command and functions so i understand what they do. How come you created a seperate query to compare the ProductID too? Is that the only way you could do it? Thanks again you have been a...

Ok i have attatched a zip file of the database. Let me know if you can open it, Cheers Jay

Re: How to stop duplicate records? Ye i can do that, but the file size is too big i cant upload it all. Could i email it to you?

Re: How to stop duplicate records? Hey look1974, Thanks for the thread link, the thing is, like most examples i have found, they are on tables. I need the code as part of a button. I dont understand how to add the code to my button code. Can i do a 'BeforeUpdate' thing in my button code...

How to stop duplicate records? I have a subform with a button that transfers the data to another subform. At present if i attempt to transfer the same data across it appears with the standard access message. I need to add functionality so that the button notices a duplicate record is being...

Hi Galaxiom, Thankyou very much it works perfectly now. So glad that was more simple then the last one haha!

I have a bombo box that selects product details, once the details are selected a click button transfers the data from one form to another. The problem i have is that when it transfers the data it keeps copying over the same record. What i need is it to appear as a new record in the subform i...

Wow i finally got it to work! I swear i used the method before but never mind its working now. Thanks so much for your help guys! If your interested the final code was... Me.Parent.F_Order_line_subform.Form!ProductID = Me.ProductID Thanks again!

Hi JANR Yes the subformContainer name is definetely F_Order_line_subform. Once again the same error is occuring, it now says it.. 'cant find the field "Parent" in the expression.' Or is parent supposed to be the form name which is F_Order?

Hi JR Im guessing the source didnt need to look for the form since the button was already in there. Hence the Me.ProductID. I think i understand that part so thanks! I tried the code you gave me. Its now saying 'it cant find the field F_Order_line_subform referred to in your expression. Do...

Hey JANR Ok so my new code is as follows... Me!F_Order_line_subform.Form.ProductID = Me!Product_Catalogue.Form.ProductID Target = Source So the source is my Product_Cataogue sub form and the target to copy the ProductID to is my F_Order_line_subform. However i am getting the same...