Search results

When I use the Round Function in Access 2000 I come up with some discrepencies. If I try to round a number (data type is currency), say 24180.5, the result is 24180. Obviously the number should round UP to 24181. What is strange is that if I hard code in a number to read 24180.501 the resulting...

I'm looping through a set of microsoft word documents in a local file. For each document in the loop I am printing, then closing the active window without saving changes. In each case I am checking the background print property before closing the active doc window. The problem is that my code is...

Good Morning! I need to develop a timing loop. The loop needs to run for approximately 5 seconds. Any ideas? I'm using Access 2000...

How do I turn off Name Autocorrect from code?

I'm trying to save a report with a specific page setup. The report needs to be printed landscape. I have tried opening the report in design view and setting the page setup property there. I save it and run the report and everything is fine. The problem is that when I close the db and come back...

I'm sending a file via this code... Dim olkapps As Outlook.Application Dim olknamespaces As Outlook.NameSpace Dim objmailitems As Outlook.MailItem Set olkapps = New Outlook.Application Set olknamespaces = GetNamespace("MAPI") Set objmailitems = olkapps.CreateItem(olMailItem) With...

This should be an easy one. How do I save a report to a file as an rtf using VBA? Is it the TransferText method?

Is there a way to send more than one attachment in an email using the SendObject Command? As it stands right now I am only able to send one attachment at a time...creating three seperate emails and sending to one location. I need to find a way to create just one email with multiple attachments...

Use the Microsoft Common Dialog Control (it's an activeX object). Go to the design view of your form and click on Insert, ActiveX Control.

I'm developing an application in Access 2000 which utilizes Microsoft Word. I have several word documents which require merge fields from records within my application. While looping through the recordset to print these jobs I get an error saying word is currently printing, quiting word now...