Search results

  1. B

    save and update data from access table to google sheet to use it with telegram bot

    hello i want to save my clients data to google sheet so can my users fetch their data through telegram bot could you lead me to how to start or where to start
  2. B

    same code for 48 textbox

    i uploaded a sample my database
  3. B

    same code for 48 textbox

    here is a copy of my database
  4. B

    same code for 48 textbox

    the textboxes in unbound the txt_01 ..... txt_48 just contain the ID the name is in another textbox name txt_01_name ... txt_48_name how to declare getinvoice in your solution?? i put this code in new module Public Function GetInvoice(ID as Long) as String If DCount("*"...
  5. B

    same code for 48 textbox

    thank you sir but do you a link so i can understand more about the parameters and textboxes
  6. B

    same code for 48 textbox

    hello i have 48 textbox in same form to receive invoices from our collector i have a code to dlookup the invoice if paid or not Dim InvN As String If DLookup("ID", "tbl_Clients_Charging", "[ID] = " & Me.txt_01 & " And [AccountPaidStatus] = '" & "Paid" & " '") > 0 Then...
  7. B

    automatic find backend

    Yes your totally right But am so sorry coz i forgot to mention that sometimes i have to edit the frontend so here i want to solve the problem of linking the tables Am really sorry for not giving all the information at the same time and thanks for helping me
  8. B

    automatic find backend

    hey again, to be more clear i made a splitted database i installed the backend on a server (main computer) and i installed the front on three other computers in the same office the owner of the business always ask me to make some updates and to be free i always work from home so i have to...
  9. B

    automatic find backend

    helllo i have a splitted database one Frontend and Two backend any solution to let the Frontend check on load two destinations and the right one will be the backend i dont want something ready if you can lead me i really appreciate
  10. B

    Problem with Dsum

    thanks man
  11. B

    Problem with Dsum

    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?
  12. B

    Solved insert into table error 3134

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

    Solved insert into table error 3134

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

    Search Continuous Form with one textbox

    works perfect. thanks
  15. B

    Search Continuous Form with one textbox

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

    Solved dcount query to unbound textbox

    Bossssss. big thanks
  17. B

    Solved dcount query to unbound textbox

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

    Solved show specified data and all records before

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

    Solved show specified data and all records before

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

    criteria to sum same product for one person

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