Search results

I have some material ciodes that ends in Z5 an in a calculated field I wish to add a surcharge, here is my stab at it. IIf([MaterialGrade] Like "*Z5",([PriceofRM])*1.1,[PriceofRM]) I can not understand why it does not work when true Thanks again for all your help, this is a great Forum John.

Thanks, works a treat

notepad

Hi, This is working fine, but I wish file to open so we can copy and paste prices. Thanks for all your help. John. Private Sub Command180_Click() Dim FSO As New FileSystemObject Dim myarray1 As String Dim myarray2 As String Set FSO = CreateObject("Scripting.FileSystemObject") Set...

OK, thanks again

Hello, Thanks, problem with this is you have to look down the long list of blanks and pick correct blank, prone to errors. I used VB in excel to do it, so I am sure this can be automated either using sql or vba but my knowledge is not good enough. Thanks again for trying to help. John.

Exactly and price so I can work out raw material cost

Sorry, MaterialNumber based on grade OD , ID and length ideal blank for sizes in form is 10081614

MaterialNumber based on grade OD , ID and length ideal blank for the sizes is

Hi, Thanks for your reply. I think you have misunderstood what I am trying to do. I wish to use the sizes on the form to return this blank in the field BlankMaterialCode from this I can get cost of blank and work out raw material cost. Field where you have put combo box is part number for...

Hello, Thanks for your reply, I have made the corrections. In the PricingForm I have entered some data in record one ideal blank I wish to populate field BlankMaterialCode is 10081614 from table tblBlankList, how do I do it

Yes you are correct the blank is a tube Outer Diameter , Inner Diameter & length. The component has to be able to come from this blank, IE OD smaller than OD of blank, ID bigger than ID of blank and obviously length smaller than length of blank. If you look in the attached data base you will...

I have a pricing tool I use in excel, works well but would be better in access. I have set some tables up and one is Blank sizes, OD , ID and length. My components are all round rings On my form I wish to query this blank list by putting my part sizes in OD, ID and length, then search my...

I am quite new to Access, but have used sql before, so no the basics of a database. I have a pricing toll I use in excel, works well but would be better in access. I have set tables up and one is Blank sizes, OD , ID and length. On my form I wish to query this by putting my part sizes in OD...