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

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

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

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

Hi all. I have several days fight (with myself :)). Problem is this: need to create Invoice from Offer...lets call it like this. So, from tbl_Pon and tbl_StavkePon need to create copy to tbl_Rn and tbl_StavkeRn with same data. Document numbers don't need to be the same. I can copy "header" but...

Hi all! I would like to create access UI like in this video on YT"POS Built with Microsoft Access - Overview".(youtu.be/Yjf6AB0iHZo) What he used? Buttons or navigation? How did he managed to have full screen and centered forms? Just need hints some hints where to start.

My name is Davor from Zagreb-Croatia. I'm currently busy working on 2 projects including MS Access(Didn't for years!). My job position is IT Officer in very small finance consulting company. Joined this forum cause search engine in the most cases redirect here for answer so I decided to join...