Recent content by KoskeKos

  1. KoskeKos

    Compare data from two tables

    Hi people! I need to compare dates in two tables. TMP and VALID. What i need is: If date from TMP table already exist in VALID table - stop execution. Else Continue with code. I know how to iterate trough tables but dont know how to set up to compare dates. Thnx in advance.
  2. KoskeKos

    acCmdZoomBox opens with font size 1 on some Office365 installs and the Font button causes a crash

    Hi all. The problem crashing Access on clicked Fonts button still persist... Try on opened ZoomBox, hold right CTRL + mouse Scroll Button to change font size. I hope it helps.
  3. KoskeKos

    Loop and set form field value

    Thanx @plog. 1. But why? Why 1/0 instead of a checkbox? --> Actually it doesn matter where its yes/no or 1/0. I get data from excel sheet. 2. What's the big picture--how is this form to be used, what does 1/0 allow you to achieve? --> I work on financial risk algorithm. I have 130 evaluations...
  4. KoskeKos

    Loop and set form field value

    Hi! I need to loop through table and check client field [answer]. If answer is "yes" then put value on form (SEC) 1, otherwise put 0. I hope i explained well.
  5. KoskeKos

    Solved Sum total 1 column

    Sorry for lack of info. Data come in once a month. I need to sum last column "InitExposure_Gross". Thats why i posted second picture (first time i did it in hurry :) ). I realized that i had Date field for "anchor". I will try to use XPS35 solution cause i think it will do the job. And if dont...
  6. KoskeKos

    Solved Sum total 1 column

    Thank you all and Sorry for delay...This is situation: I have I need sum InitExposure_Gross column and use that value for further calculations.
  7. KoskeKos

    Solved Sum total 1 column

    Hi. I need to run trough rows, sum total value in column and use that value for further calculations.
  8. KoskeKos

    Solved Customers with more than 1 address, select 1 for report

    Once again, I would like to thank everyone and especially to arnelgp 🤩say that I managed to solve the problem. Addresses are in separate table so i can have many for one customer. Long Live Good (Read: access-programmers.co.uk) People! Customer name < Naziv kupca Adresa < Address :) Odaberi...
  9. KoskeKos

    Solved Customers with more than 1 address, select 1 for report

    Thank you arnelgp I will check this.
  10. KoskeKos

    Solved Customers with more than 1 address, select 1 for report

    Thank you all for effort. :love: Let me present you the real situation: Company 1 have 5 address. I need to send 3 invoces on that Company 1. I must be able to create all three and print them with same company name but differrent addresses. For learning pupose I have: t_Customer...
  11. KoskeKos

    Solved Customers with more than 1 address, select 1 for report

    Hi all. I got to point that cant finish: I got some customers that have more than 1 address and they are in separate tables -customers and addresses. Customer is selected via combobox. If customer have more than 1 address, pop up form will show all addresses with checkbox to select <<< im...
  12. KoskeKos

    Run-time error '3075' (syntax error- missing operator)

    Just to say i figured it out. My mistake. (How strange is that :eek:?!?!). Data types of IDs weren't the same in two tables. Anyway thank you all. 🍻
  13. KoskeKos

    Run-time error '3075' (syntax error- missing operator)

    Thnx for answer. Tempvars is number and when checking with msgbox it shows a number. Ill check.
  14. KoskeKos

    Run-time error '3075' (syntax error- missing operator)

    Hello 2 Everyone! I have problem with first line of code (syntax error- missing operator) and can't figure it out: Here is code: If DLookup("[HasAccess]", "tUserAccess", "[UserAccessID]= " & TempVars("UserType") & " AND [FormName]='" & Me.Name & "'") = False Then DoCmd.Close acForm...
  15. KoskeKos

    Copy form and subform to new from and subform

    Duplicating forms: yes. Its something like: pre-invoice to convert into invoice on click. And YES! Thats it! Its aLIVE!😱 How can i thank you? :love:🥰
Top Bottom