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.

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

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