hello i have 4 checkboxes in continuous form
i want to get the sum of each checkbox with true value in an unbound texbox
i tried these codes
=Sum(IIf(Nz([chk_Gift];False); 1; 0))
=-Sum([chk_Gift])
=Abs(Sum([chk_Gift]))
but always am getting error any help please
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
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("*"...
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...
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
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...
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