Search results

Hello, I have a scheduled task that opens a version of Access 2000 and runs a process. This process includes sending reports to clients via outlook and redemption. When I log into the server to take a look at the process I see literally 100's of the same report trying to open and the process is...

Hello All, I have an Access Front End System sitting on top of a SQl Database. There is a name search item in which the user selects a name from a combo box and clicks "Find". The combo box uses a queried name list, with the name built LastName, FirstName. The problem is that the combo box only...

Hello All (and happy March Madness - GO ILLINI!!!) I am exporting an access report as a word document and the exported file loses an image that the report contains. Is there an easy way to ensure that the image is not lost? The process generates an rtf file and the rtf version of the report...

Hello, I have several fields on a form. Some fields are general numbers, some are currency. The data in the general number fields line up right justified as do the currency fields. The currency fields, however, do not line up ALL THE WAY to the right. My client thinks it looks "funny" and the...

Hello, I have several fields on a form. Some fields are general numbers, some are currency. The data in the general number fields line up right justified as do the currency fields. The currency fields, however, do not line up ALL THE WAY to the right. My client thinks it looks "funny" and the...

Hello, Is it possible to automatically export an access report in a PDF File format? If so, how? Thanks!

Hello, I am using the Outlook Redemption Object and seem to be running into an issue. The error I'm receiving is "Array Index Out Of Bounds" and the debug points to this line of code: Set oItem = Outlook.Session.GetDefaultFolder(6).Items(1) This is the strange thing...the process is run on a...

I know this isnt Access related, but perhaps on e of you out there can help. I'm updating a small financial web site using ASP (VB Script). I need to recreate the Pmt() and Rate() functions found built into Access using VB Script. I found something I can use to compute Payment, but the Rate...

Does anyone know the vb code behind the built in Rate() function? This is my situation. I'm developing a small financial site using ASP. I need to recreate the Pmt() and Rate() functions found built into Access using VB Script. I found something I can use to compute Payment, but the Rate...

Hello, I have an automated email sent out via code in my application. The problem is that everytime one of these emails is generated outlook asks to click yes or no to confirm that the email should be sent out. Is this a security setting in OutLook itself? If so, can this setting be turned off...

Hello, I have an automated email sent out via code in my application. The problem is that everytime one of these emails is generated outlook asks to click yes or no to confirm that the email should be sent out. Is this a security setting in OutLook itself? If so, can this setting be turned off...

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...

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...

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...