Search results

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.

I am having a really big problem with the memo field. I have text that has approx 9000 characters. It is stored just fine in the table in a memo field, but when I try to display it in a text box, I get an error # 2179, UNLESS I only put in no more than about 2000 characters. I know it can be...

Hi spacepro, I had the same problem with multiple html files. I don't have the Snapshop Viewer folder on all my machines though, so what I did was to export the report ( which created the multiple files). Then I read the first file into a string variable leaving out the last 2 tags - BODY and...

Newbie here! I have just completed first draft of an app which I have tested on 4 machines in my office. I distribute it to a co-worker off site for testing and he gets this error message when trying to open and read a file which needs to read in a date as a text string and store it in a date...

Did you set a reference to the Outlook 10.0 object library?

Help file I found what the problem was. It was while I was creating the Help project file in Help workshop. Thanks anyway.