Search results

Hi, Thank you for reply Both Amount and Price are number field, but it works to "900" or any other numbers, only doesn't work for "1000" , and when I remove quotes around "1000" it gives error : IIf([amount]<1000,[price],[amount]*[price])

Hi all, I use calculated field in table with formula, but result is not true : =IIf([amount]<"1000",[price],[amount]*[price]) when I type value less than "1000" in [amount] it gives [amount]*[price], while if [amount] be less than "1000" The field must gives [price] for every number in amount...

hi all, i have a lot of text boxes in report and i want to make rounded corners to Text Boxes in access ...i have searched on web but i can't find direct way to do this, is this possible?? thanks in advanced.

hi guys, I want to change direction of form title (caption) and I do it manually with space(" "), is there a way to change alignment automatically to center with vba or function?? thanks in advanced.

thanks, but that's not table or querry, it's just Filtered table records in subform on unchecked checkbox and i change the code to (but it's not working) : DCount("*", Me.child11.Form, "Chk =True") i use other code to count checked item but it's not working too : count = 0 For Each ctl In...

hi all, i use a command for accept change in records of subform, but i want to give a msgbox when click on "ok" button and unchecked any checkbox in records : msgbox "There Is no checked checkbox in subform, Please check at least one of the checkboxes" thanks in advanced (sorry for my poor...

Thanks arnelgp, but i don't have button, i want to add with keyboard shortcut from combo box directly.

hi all, i make a combo box and i want when i open the list of combo box and press {enter} key from keyboard add item of list to other subform datasheet...is it possible?

thanks all, yes june, i change control name in my form, but i use image instead button in form and i change it to image name. Forms!frm_Date2!Child111.SetFocus With Me .RecordsetClone.Bookmark = .Bookmark .RecordsetClone.MoveNext If Not .RecordsetClone.EOF Then...

thanks june, i use your code but i get error as below image :

hi all, i make tow button to next and previous records in subform , now i want to msgbox when select first and last record by button. is it possible???