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