Search results

thanks Mstef, im busy applying it, it makes sense just by reading it.

:banghead:if the command copy is'nt currently available , then what is available to perform the same task as COPY.

could i link a current form to another form, these would be to seperate enties but the client may be the same so all documents (forms) from the same client would be linked together and visible.

Thank you MR BIG BOOTY, most helpfull, i was definatly on the wrong path...

thanks, the idea is to have 2 of the same records.

The OpenQuery Command Runs only once a part is selected, then the Remove and Refit, Paintwork,Labour and Outsourcing that goes with that specific part are automatically filled in-in the SubForms labelled Labour,Paintwork and Outwork (this is because each part is different and some parts has too...

upon Edit (OnDirty) access should copy the current information in the SubForm then create a new record and paste the copied data into a new record(form). this is my current code but it doesnt work on the SubForm, i'm assuming its because the subForm is Query Based. Private Sub...

hi this is my code that runs a Query on Update of a field the 2nd half is suppose to delete the query once information is removed which triggard the query to run but it doesnt reverse the query, i know my bottom half of the the code is wrong but i cant see where, please help me fix it...

RainMan I Have a SubForm And Its Data Is Based On A Query, Is It possible For Me To Copy From This SubForm, Because currently I Get The Error Message: Command Copy Is Not Available.

thanks Rainman it works like a shoe that fits perfectly.

Good Morning is there a code to apply alternative row shading to a Report and its SubReports

thanks.will do.

due to an unlocated token it cannot be uploaded. Thanks for being willing though.

you've definatly been of great help, if i uplaod my db to late you can have a look at it 2mrw, thanks again:)

ok, looking at my code above could you help me with the delete queries, my employer would like to see that today, then i could redesighn 1nce he has seen his delete queries. this would be great. how do you want me to send you my db.

hi RainLover the idea is not to repeat data, all parts has different R&R (which is populated in the R&R SubForm), all parts has different Paintwork, Some doesnt need Paintwork, this data is populated into the Paint SubForm. Now when a part is selected on the Parts SubForm, the relevant...

HI Eugin, below is my current code Private Sub Product_AfterUpdate() Dim subform1 DoCmd.SetWarnings False Me.Descriptions = Me.Product.Column(1) Me.PartsPrice = Me.Product.Column(2) If IsNull(Me.PartsPrice) Or Me.PartsPrice = "" Then Me.PartsPrice = 0 End If...

Good Morning... I have a sub form named Quotation Parts, When parts are added into the fields a query runs and automatically the next 3 subforms are filled in-in the respective fields, however when i remove the part from the quotation Parts Subform i would like the it to reverse what was added...

hi Bob, thanks for your help, i see now only that my reply earlier this afternoon was not successful. I've applied the 3 guidelines that you've given me, but there is 1 line in the code that i cannot get to work, ive been battling all day trying to edit it until i get it right but to no...

hi BoB yeah its not good at all, im at the stage of giving up. i have 1 form Quotations and 4 subforms: QuotationParts, QuotationLabour, QuotationOutwork, QuotationPaint. now instances arise where we need to edit a quote but we would like access to save the origional quote upon some1...