Recent content by theinviter

I TRIED BELOW, BUT NEED SOME CORRECTION. Private Sub Scan_BeforeUpdate(Cancel As Integer) Dim blnFound As Boolean Dim s1 As String Dim S2 As String On Error GoTo errhandler: ' check if the Item already exists on the table ' if it exists, go to the record instead s1 = Scan With...

actually ,we are designing this for tracking the number of medication taken from cabinet for each patient. just for number tracking. can you please advise

Dears; good afternoon; i would like to seek your support. as i have created a form to track medication taken from storage. so i want when i scan the item name twice, the quantity changes from default 1 to 2. Form name: Data entry as the user will just scan the barcode to add the item. how...

done as below thanks alot Private Sub Form_Current() If Me.Attachement.AttachmentCount > 0 Then Me.Command236.Enabled = True Else Me.Command236.Enabled = False End If End Sub

i tried below but not working Private Sub Form_Current() If Me.Attachement = "" Then Me.Command236.Enabled = False Else Me.Command236.Enabled = True End If End Sub

Dears; I have created an evaluation form, where user can fill the form online and then print and attached the scanned signed form. so once the user upload the form a button "send" will be enabled and then he can send the report. but if no attachment in current record so the button "Send" will...

thanks all , its solved

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