Search results

actually the MOQ if fixed for every product. as the user can request any quantity with multiple of MOQ, for example if MOQ is 20 then can accept 20, 40 ,60 or any number multiply of MOQ without decimal. like if 15 , 25 , or 35 will not accept . so i tried below code; Dim D11 As String D11 = QTY...

yes you are right. this what i mean.

yes it is, example Qnty = 24 but MOQ (Min OQ) = 21 . so 24 / 21 = 1.14 . which is not accepted, as i want the use to adjust the quantity to get zero decimal.

Dears; I Have Created a form where the user enter the quantity to request in Pcs. as i want after entering the value do a calculation by divide the Number on MOQ. and if there decimal number then show a message box and cancel and if the result without decimal them accept it. can you guide me...

thanks, but can you also apply this to Receive Date form, so the user will not be able to add any record before adding receive date.

th thanks you sir, really appreciate your support.

Dears; I have created a form and subform to track stocks movement. so in subform there is list box if items, once user double click on , it copy the data to new record in subform. but i want the below: 1- Field Number to be updated with serial Number starting from 1. 2- Record count show...

thanks solved, appreciate your help

thanks solved, appreciate your help

Dears; can you help me to correct the blew code , i got error message, as i want to count the numbe row in 8-Expiry_List table with similar LinkID. Expr1: DLookUp("CountofLink_ID","Find duplicates for [8-Expiry_List]","[location code] = " & [8-Expiry_List]![location code] & " And [item_code]...

am not sure about string length. can you advise and help to write all code.

Dears; I Have created a Form " 6-Inventory_Data" and on the top of the form added 2 Combo box and 2 fields for date selection, once I applied below code it did not work. can you please guide me; Private Sub filterThisForm8() Dim S1, S2 On Error GoTo errhandler 'n = 1 / 0 ' cause an...

Dears; I want a way to Update a field in a table after the user click on check mark in the form. so I have Check mark Named ( Qny_HQ) in table (MRN) which has a (item_code) and (Location_Code). and when the user open Response form and click on Check mark (Aknwledge) want to update the check...

Dears; I have a continues form for items list that has an image for each item inside the form. so when i placed in shared folder some time gets slow to display all images. so is there a way to display image only on clicking on image field? thanks

Done below code, DoCmd.OpenReport "Items", acViewPreview, , "[ID] = " & Me.ID, acWindowNormal DoCmd.RunCommand acCmdPageSetup but getting a message to enter parameter value = ListID . how to correct this.

yes , but the ribbon disabled for user, but i want once to open the report in design view, show page setup.

thanks But i need to show page setup where user can Edite the Margine once and not do it every time.

Dears: I have a Form for label printing, each location has a different printer, so i want to make A button on the form, then after clicking, it will open Pahe setup for the label where user can select the printer and edit margin. is there any way to open page setup directly through a button...

hi: I figured it out, thanks alot you are amazing team. this is how i did it; Me.sum2021 = Nz(DCount("*", "[MRN_number_Of_PO]", "[Location - Clinics Code] =" & Me.Combo2 & " And Year(Date_) = " & [Year1]), 0) thanks