Search results

What am i dooing wrong? :banghead: Set rstSubForm = Forms![qpocetnostanje subform]![qpocetnostanje subform1].Form!Stanje.Recordset Do While Not rstSubForm.EOF If Me![qpocetnostanje subform1].Form!Stanje = "Ne žigosana" Then MsgBox "Izveštaj NE SME da sadrži ne žigosanu robu. Molim Vas vratite...

I tried that code but it only works if the first value in subform column Stanje is equal to Jeste

Button is on main form and it opens report. But if there's a value Jeste in subform coluymn Stanje i whant to display msgbox

at button click

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:

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"

It wont work. Its said that expression is typed incorrectly or that is too complex

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?

My subform have a value that is neaded for some others values in my main form. I have two tables "Unos" and "Bod". I made query that gave me a value from "Bod" table for column "Vrednost" where id =1. I made a subform based on that value. In my other table wich is my main form i also have...

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

Can you explain me by example what to do because i didnt understand you wery well. :(

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

THANKS JZWP22. Thats exactly what i need :)

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:

My table2 was empty so i didnt get any value. But now when i add values to my table2 i only get result for table2 but not for table1

Thanks for replay Plog but that didnt help. Now i get null value

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

:)Thanks. That helped

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