Recent content by jenny23

Hello friends, Thank you very much, I appreciated your help so far. I have one more question: Now, when I open the button, it open a report and an outlook message to send out that word document. Woh, I like it alot. However, my question is how to add a message text longer and maybe in more...

Hi friends, I really like this forum. I found right answers each time I posted. Thanks for all your help so far. I appreciated that. I have another question: I created a table like this: TableA id student class -- ------- ---- 1 john his 2 ray eco 3 lisa his TableB Class Stu_id Name...

Woh Woh Woh.... It Worked Perfectly. ___ Is This Your Name? Thanks. Jenny.

Can you modify the code so that when click on it, it open an outlook , then you can enter any email address you want to send? Thanks.

IT WAS PERFECT. THANKS A LOT. NOW, I tried to send this current record to Outlook by a Word doc attachment, but my code doesn't work. Can you please help me this time? Private Sub Command93_Click() On Error GoTo Err_Command93_Click Dim stDocName As String stDocName = "rptA" DoCmd.SendObject...

Hi friends, Thanks for all your help so far. I appreciated that. I have another question: I created a table like this: TableA id student class -- ------- ---- 1 john his 2 ray eco 3 lisa his TableB StuName Address phone -------- ------- -----...

I don't have an Access 97. I am sorry. But that db is just a table with 2 fields and a form. Can you make it up? Thanks.

my db This is my DB. When open it, click on the form, you 'll see what I am talking about. Please help, guys. Thanks. Jenny.

I tried your code. I put a Print command button on the form called Print, then I open this button properties and paste the code on the On Click event, but it showed this error: Run-time error "438" Object doesn't support this property or method and, it highlighted this line: DoCmd.OpenReport...

Hello Mike, I have done that. What 's next? Thanks.

I am really a newbie in ms access, can you please show me in detailed how to do this? Thanks very much. Jenny.

It still prints all records. I really don't know why. It is supposed to be easy. Please help. thanks. Jenny.

I changed the Cycle to Current Record I changed the Control box to No. I created a Print button on the form, and paste your code at the On Click. That's all I did. Help. Jen.

Hello, It doesn't work. It still prints all records. Please help. Jenny.

Hello friends, Can any 1 please show me how to print a current record from form? I tried to create a Print button, but when I click on it, it just print all the records. Please help. Jenny.