Search results

Hi All i have tried in different way and its work fine so i need support in below: 1- in Inventory Transaction form : When used choose the item Davita code drop list or update the quantity then want the balance get updated value from Bal_Val. thanks

Dears, I hope this email finds you well. I'm currently working on a system to track item movement and balance. The system involves two primary forms: Item Addition: Users scan a barcode to add an item to the inventory. Item Transaction: Users scan a barcode to record a transaction (e.g...

Hi teams: Good afternoon i need a kind support on below: I have a form connected to shared folder, sometimes has a problem with network which can stop staff from entering the data. so I want to do if has network issue and user can't login to Open another form which place in frontend and if...

but them code will not work

Dears kind support for below code, as i do not want to show the message. how can modify it. On Error GoTo Err_LimitChange ' Purpose: Limit the text in an unbound text box/combo. ' Usage: In the control's Change event procedure: ' Call LimitChange(Me.MyTextBox, 12)...

HI, thank it work only when i update Findcode but what about if there is 2 criteria. so mean either filter by item name or code. File attached, where i want user to filer by medication or code.

thanks that work what if want to add additional dropbox named "Item_name" so want to filter either by code or item name.

thanks that work what if want to add additional dropbox named "Item_name" so want to filter either by code or item name.

Dears; i would like to ask a support. I had a form where the user scan the bar code in text field, so after scanning need to find the code in 3 different filed and filter the form. IF code not present in Field 1 ( Code1) then search in field 2 If code not present in Field 2 (Code2) then search...

after applying the filter enable to extract the filtered data into excel file. by clicking on a button

thanks all, but is there a way to extract the data with applied filter. thanks

Dears; I need your support, as I have a form with multiple un-bound combo-box and need to filter the form based on the user selection. as i tried below but not work Properly. and will not filer the form. so can you guide me how to solve this, File attached. Private Sub filterThisForm2() On...

Dears teams; Hi, I would like to seek your help, i Have a report and want saved it with current date as month and year and account name. as i want to create a button, once the use clicks it then it will create a folder on Desktop Named " Evaluation report" and save the file as PDF inside this...

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