Search results

i have a query contains [ID] and [Amount] i wrote in vba Dim BulkTotal as integer BulkTotal = DSum("Account_Amount", "[qry_Bulk_Total]") am getting this error Runtime error 6 Overflow any help?

thank you all. I rewrite my code in the best and healthy way but the main problem that I found is the toggle name (Double) reserved name everything work right now and sorry for taking your time

am inserting data into a table table fields name is correct form textboxes names is correct strsql101 = "insert into tbl_Clients (ClientName, Username, Phone, RegistrationDate, RechargeDate, ExpiryDate, Address, Section, Account, AccountDealerCost, AccountResellerCost, AccountResellerSell...

works perfect. thanks

hello, i have a continuous form for now i can search just one field with this code Dim strFilter As String If Len(Trim(Me.txt_Search.Value & vbNullString)) > 0 Then strFilter = "Clientname Like '*" & Replace(Me.txt_Search.Value, "'", "''") & "*'" Me.Filter = strFilter...

Bossssss. big thanks

hello i have unbound form two unbound text (txt_printed) (txt_not_printed ) i put in the control box of txt_printed = DCount([Printed];[qry_Invoices_Printing_Data];[Printed]=True) txt_not_printed =DCount([Printed];[qry_Invoices_Printing_Data];[Printed]=False) when i run the form the two...

hey guys sorry for bothering and thanks for helping me i solved my problem by just using criteria in my query where i add my 15 records table in a specific range at ID field criteria = <= [forms]![form1]![id] so i should delete the post?? thanks again

hello guys congratulations for the new look :love: i have a table with 15 record each record have a unique name 1-A 2-B 3-C . . . 15-X in a form if i choose from a combo box for example letter D and run the query (or vba code) i want to get all records from D and before so i will get 1-A 2-B...

hello i want my database to tell me when the same person bought the same product 20 times If DCount("*", "tbl_Personal_Sanctions_02", "[PID] = " & [PID]) = 0 Then MsgBox ("congratulations") Else End Ifthe product field is (Sanction_Code) the type of...

i create a small database to upload it but the problem is resolved i dont know how i recreate the form in my own database everything is work fine what could be the problem btw the vba code i copy paste it from the old form to the new form thanks for your effort

nothing appeared i will try to make a similar database just to show what i want to do and i will upload it tomorrow. thanks for your effort

this is the code in the double click event DoCmd.OpenForm "frm_Personal_Main", acNormal, , "[PID] = " & [PID] when the personal main open i have many command button inside this form it's like a mainboard for the staff the the codes run based on the PID one of this commands open a continuous...

and it's in arabic language

frm_Personal_Main is Form1 this form is based on another form form 0 is contiunous form that contains the list of the staff i double click on any staff so form1 will open and ID textbox will get the id of the stuff form 2 is working fine without the criteria form 2 contains the in and...

hello i have form1 - form2 - table1 - query1 form1 contains textbox with specific value query1 bring data from table1 form2 (data source query1) show data from query1 (ID like the textbox on the form1) if i run the query1 it will ask me to give input so i add any number the query...

perfect work like a charm

hello i have a listbox bound to a table that show the id of the records i want to print all the records showed in the listbox with one command https://ibb.co/xDgXGxY any help?

hello i have a list of clients each with recharge date for example i have a recharge date for client 01/05/2019 (april) i want to renew the subscription so i should have a new date 01/08/2019 (august) i renew every month with this expression...

hello i have a report in arabic, in this report i have a textbox that will change whatever the client enter a new data the problem is each lines at the right a letter or two disappear https://ibb.co/Vv3hZkk please look at the red circle in each one there is two letters that are not existed...