Search results

Dears; kind support, as i have a form where I want the once scan the QR code on medication to extract the Expiry date and batch. 1- For expiry date to extract and place it in [Expd final] in "yymmdd". 2- For batch number want to see if the code start after "10" more than 2 then take the 2nd 10...

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

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

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

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

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

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

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

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

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

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

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

I need a help: i have a form , i need after update clinic, it will Dcount all record from in field "total". so i tried belwo code but still getting error: Me.total= Nz(DCount("*", "[MRN_number_Of_PO]", "[Location - Clinics Code] =" & Me.Combo2 & " and [Year22] = " & Me.Year1), 0) Also Dcont...

HI i Have a form which filter after entering code number, as code below; but i wannt to show msg box if no record found and cancel filter, how to modify the code below: Private Sub filterThisForm1() Dim strFilter As String On Error GoTo err_handler If Len(Trim$(Me!Combo79 & "")) Then...

Dears; I have created a form "Clinic" and sub from "Delivery_Number" , there is a field named "Delivery" , user update "Delivery_Date" so I want this field "Delivery" to auto update with serial number starting from (one) after updating "Delivery_Date". repeat the cycle with every new record...

Dears; I need a help, I have a form named : clinic Subform form: Delivery_Date so there a field in clinics form named (Number of delivery) , so i want to limit the number of record in subform based on the number in main form. for Example, if (Number of delivery) = 3 then the user can add only...