Recent content by Melhem

Yes sure . like I mentioned the email is sent well , I don't know why there is a runtime error at the end :confused:.. any way I found another solution ;) I write it down

First thank you for your replay, and your PS :) The error is at the end 'End Function' I call the function like that : Print SendEmail(Me.Item.Value, Me.Total.Value) Any way I changed the Function to Sub and it work :D This is the solution : Sub CDO_Mail_Small_Text_2() Dim iMsg As Object...

Hello every one :o I'm trying to send email using VBA code, the function is working and the email is sent, but the problem is when function end 'Run-time error 438 object doesn't support this property or method' appears :( here is the code: Public Function SendEmail(ItemName As String...

Sorry I didn't get it :banghead: I know this is stupid but can you tell step by step how to display query result built based on controls on form!! Thanks a lot :rolleyes:

Hi again :D I changed the Form view to be Datasheet and the same problem :confused: I attached a photo to clarify Thanks

Thank you pr2-eugin .. sorry I'm new on this but I'm wondering: In my case the result is one record .. what If the query returns 30 record ? There is no control that can display the query result as a table ?? Thanks again

The name of Blank form I created is FormTemp this FormTemp will be used in the main form to display query result I attached a photo to clarify ;) Thank you

Thank you CJ_London I meant by cmdSource is combo box with values : Store , Production , Vendor, and no problem in this part :). My problem is who to display the records.

Hello Please help, I have this table ‘Source_RM’: Source.......Raw Material.....Waste Date..... Waste Quantity Store ..........Sugar.............13/06/2013.................10 Store...........Salt...............12/06/2013.................13...