Recent content by lekmall

Thanks, CannDoIt! Yes, it is the case where I have memo fields with a great deal of text. What I ended up doing was just writing the report manually with VB to a text file. I found that I had more control over the formatting that way. I will hold on to your code. It looks like a great...

Hi! Here's what I have so far. I was able to use the Word object model from MS Access to at least get the document and embed it in the email. That's great! But, it loses it's formatting. Dim oWord As Word.Application Dim oWordActiveDoc As Word.Document Set oWord = New Word.Application Set...

Does anyone know how to create a report with a table of contents that includes page numbers and be able to save the report? I can create the report OK if the user wants to preview or print the report by running the report twice - first to get the page numbers and store them in a table and then...

I have looked on the site here forever and can't find a way to email a report in the body of the email. I tried: Set myOlApp = New Outlook.Application Set myItem = myOlApp.CreateItem(olMailItem) DoCmd.OutputTo acOutputReport, "rptShortReport", acFormatRTF, strOutputFile If...

Thanks, Kraj Much appreciated. and yes..I will try to make it look pretty.....

Thanks, thePrez. I do allow the user to not have to select from the listbox because I have 2 radio buttons - one for 'All' and one for 'Selected'. The report query is 'Select * from ...'. How can I change the query if the user selects certains items in the listbox?

Help please. I have a report that is based on a query which selects all the records in the table. Sometimes, though, the user will want to select certain records from a listbox and then see the report. I have tried setting the report filter property to a public variable - strvar - which...

Found a solution, Rich!! Before running the Spell Checker on the text box, I add a chr(32) to the beginning of the text. Works great! Before displaying a message to the user that the spell checker is done, I remove the space. ???? Thanks for your help.

Rich, Thanks for getting back to me. I'm so frustrated with this and my boss really wants a spell checker. I have a multiline textbox that I want spellchecked. I have hardcoded the text from this box to go directly into the spell check code for now just for testing. When I type something new...

Thanks, Monkey Man. I thought of that, but can't do it. When the file has been opened with Notepad, it will have the .txt extension. The user may want to save the file while it's open and they will be confused when they see that the extension is not what it should be and I would get calls...

Rich, I highlighted the text, clicked on F7, got a message box telling me that spell check was complete, but there were mis-spellings in the text. How to relate the spellchecker to the text to be checked? I did not try running the code. For example, highlighting the text and letting the user...

here's the solution! I found this solution at: http://vbnet.mvps.org/index.html?code/shell/shellexecute.htm works great if anybody needs it. Thank you!

Does anyone know how to add a SpellChecker to a form which allows the user to enter text? Thanks Again!

Does anyone know how to open a text file with a specified application? The extension of the file that I want to open is not .txt and it won't be registered on the user's computer. I just want to call 'Notepad.exe' and then specify the file it is to open???? Thanks!

Thank you, llkhoutx. I'll try it.