Search results

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

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.

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

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 arnelgp I will check this.

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

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

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

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

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:🥰

Helou. Its me again :) I need to copy form to new form. Problem is in subform when i have two or more rows of data, I get only one row copied (if is only one row in source sfrm) or last record copied. How to after loop through fields go to second row on new subform? Code i got is this: Private...

Its not that. I've changed names of tables...Sorry didn't mentioned before. :oops:

Thanks Mike 4 replay but now I'm getting confused cause I'm not excellent in VBA.

Hi. Situation is next: tbl_StavkeRn (target child) is populated but tbl_RnT(target master) is not. I use this for run: fnCopyRecordMasterChild("PonT","StavkePonT","PonID","PonID",[PonID].Value,"RnT","StavkeRnT","RnID","RnID") Help.

Thank you very much. It works without error!!!! You saved meeee!🥳🎉👯‍♀️👯‍♂️ I have 1 more question: can <thePonID_Number> or SourceMasterPKValue be set to look at current (opened) form PonID value? Something like "Forms!Opened_form!PonID"?