Search results

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

Dears; Need help, How to filter the query to show only last record by date, as the filed name DATE_. thanks

Dears; I have a table" Listing_of_documents_of_Purchas" I created a query named " so I need to add a column in the query to get the number of record with status "pending" . and Voucher1 match each other . i tried below but not working. as take long time to run. Pend...

Dears: i have created a form that contain a search textbox, once user update then it will filter the form. i have applied the below code but it apply the filter on both form and subform . so can you please advise me how to correct to filter form only. Private Sub FindCode_AfterUpdate() On...

Dears; I have a sub form that contain Date Filter filed ( Date_From and Date_To). so i tried to filter the form with below code and work fine. but i clear the filter by clicking on button, got error message " The Search key was not found in any record" so how to avoid this error. Private...

Hi I have a Subfor " Table2" as it have 2 date filter field [ Date_From] and [Date_To]. the subform has Date filed [Date_]. so i want to filter the form between the 2 dates after updates. how to modify this code to apply it filter date. Private Sub filterThisForm2() Dim S1, S2 On Error...

Dears; I have created Inventory form "Table1" has a sub form "Table2" so the date filter filed ( From ) (to) present in table1 . i want to filter the subform "Date_" after updating date filter filed to get record between selected dates. so can you advise how to do it. thanks