Search results

  1. S

    IF value from column in subform

    I have subform on my main form. Subform is showing as datasheet on my main form. I whant to if some value in my subform column "Stanje" is equal to "Jeste" to display msgbox. is that possible?:confused:
  2. S

    Select multiple values in where expression

    I want to make subform from query . I have a form and user enter values that he want subform to show. I was wondering if user could select multiple items from a list and that subform show that values?:banghead: Form name is "PocetnoStanje"
  3. S

    Subform year from textbox

    I wan't to user enter only year in form text box and that my query where statement be between 1.1.(year from text box) and 31.1.(year from text box) Is this possible?
  4. S

    Disable add ing new record to subform

    I have main forn and on open event i have code DoCmd.GoToRecord , , acNewRec Now i also have subform in my main form. Is there any solution to open only main form in new record and my subform to retain value that it has? Or is there any solution to textbox in my subform go to first record in...
  5. S

    Nine message boxes

    I have a code that wont work. If i click add button when all field are null then i see message box for first if function. Then if i fill the first field and left all other field null and click add button i dont see any message box and record is added to the tables. Anyone know why is this...
  6. S

    Update if exist else insert

    I have a form with some ID. I have made update query and add query. Now if ID from my form exist in table1 for example, i want to run update query, and if ID from my form doesn't exist in my table1 then run add query. :banghead: Any help guys :confused:
  7. S

    Inner join sum from two tables

    Heres the code I am working SELECT nz(sum(table1.PDV1),0)- nz(sum(table2.PDV2),0) AS Sum FROM table1 inner join table2 ON table1.id1=table2.id1 WHERE table1.date>= #1/1/2013# and table1.date<=#30/4/2013# I cant get code to work. I dont know where i am wrong :banghead: i keep getting 0 as a result
  8. S

    Display custom error if field is null or zero

    I have a code Private Sub Dodaj_Click() DoCmd.RunCommand acCmdSaveRecord DoCmd.SetWarnings False DoCmd.OpenQuery ("updateDodaj") DoCmd.SetWarnings True On Error GoTo Err_Dodaj_Click DoCmd.GoToRecord , , acNewRec Me.DatumKnjizenja.SetFocus Me.DatumKnjizenja = "" Me.Kom = 0 Me.Gr = 0...
Back
Top Bottom