Search results

I don't have time to look into this in detail, but I have messed with Word a little. I'll give you the code I wrote in case the reference will help. The following function took a long document that had forced carriage returns every 55 characters and removed the carriage return. It also bolded...

I can go on with life while the batch file runs. The only issue is that the message itself takes so long to get to everyone. If we have something that we need everyone to know immediately, it just won't work.

Thank you. This is actually exactly what I ended up doing. I create the batch file through code and it sends the message to the specefied computers. The only hitch is that the batch file takes a long time to run. If the computer is not turned on, it hangs for about 3 seconds before going to...

The easiest thing would be to use your if statement to run code only when mydb.BOF = False If mydb.BOF = False Then With mydb If .RecordCount Then 'I wasn't sure what this If was for or where the End If was located .MoveFirst Do Until mydb.EOF...

I'm not reading this until much later, so chances are you have already done what you are going to do. But I thought I'd point out that if you use a continuous form, you are not limited to viewing one record at a time and still have all the functionality of a form. cogent1, floating the...

I may be wrong, but I think the only way to do this would be to then open the recordset and insert data into the new field. The following example assumes that you would want to insert the information inot each row of the table: Dim rst as recordset set rst = currentdb.openrecordset(sTable)...

I just figured this out: Dim richStyle As Object Set richStyle = s.CreateRichTextStyle ' where s represents the notessession object richStyle.FontSize = 16 richStyle.NotesFont = FONT_HELV richStyle.Bold = True richStyle.NotesColor = COLOR_DARK_BLUE Call rtItem.AppendStyle(richStyle)

I could really use some help. I am trying to write an agent in LotusScript that will move information from the Lotus database into an access database. I know how to use OLE to connect to an access database in VBA, but I can't seem to figure it out in LotusScript even though it is similar. The...

This code was posted by someone else on this site, and I found it very helpful: Public Sub SendNotesMail(Subject As String, Attachment As String, Recipient As String, BodyText As String, SaveIt As Boolean) 'This public sub will send a mail and attachment if neccessary to the recipient including...

Is there anyway to format the text in the body (bold, different fonts, etc.)? I played around with the RichTextStyle object but couldn't figure out how to get it to work.

I need to rate each entry in a query on a bell curve. The top 10% will be a 5, the next 20% will be a 4, the next 50% will be a 3, the next 15% will be a 2, and the final 5% will be a 1. Is there anyway to write an expression that will accomplish this?

The problem with just dragging the built-in Windows menu to my custom one is that changes made to this menu appear in all Access applications. Also, the changes seemed to be saved locally. The refresh menu item I added did not appear on other computers. I moved refresh to a different menu as...

I am creating a custom menu bar for my application. I have noticed that if I modify the default menu, it changes it for all Access applications; so I have decided not to do this. I created a new menu bar and I have the standard menu items (File, Edit, View, Window, etc.) with only the options...

Can I use SendKeys to interact with a Dos application? I'm having trouble figuring out how to do so.

Thank you. Your code speeded up my application a great deal.

I I went to processes and found that for every time I call either of the functions a WinWord.exe process keeps running. Apparently Set wd = nothing does not destroy the word application object as promised. I preceded this line by wd.Quit and it now appears to work fine. I still would rather...

I found some code online to help work with an ini file. It works and I am able to use it by specifying the path, the section, and the name. There were two functions, one to read the information from the ini file and the other to change the information in the ini file. It uses a word object to...

This doesn't remove cookies and it also doesn't seem to work consistently. I noticed something else though. Assuming I have closed Internet Explorer, when I run my delete function and view the properties of the Temp Internet Files folder it says it is taking up 176 KB (the size of my index)...

I did, and it still was giving me problems. I ended up creating an AutoKeys macro. I had a class in Visual Basic and assigning the shortcut key simply required typing it into the box. I thought it would be the same in Access, but I think I was wrong.

You can't necessarily run the whole module, but you can run functions from the module. Use the runcode command in the macro and then type your function name where specified.