Search results

hmmm - never thought of that - I'll look into it - thanks for your quick response!

The process loops through a recordset and sends reports out that are in that recordset. So no, Access closes only after all reports are sent out - after the loop runs. Do I need to open a version of access for EACH report that needs to be sent out?

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

Yeah... I was hoping to avoid those solutions, but that's what I figured had to be done. Nothing's easy with Access eh? Thanks Doc!

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

Thanks! This works like a charm!

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

You are right on! Thanks for your help!

Try creating a function that passes the month and "renumbers". Function ReturnMonthOrder(vMonth) As Integer Dim tmpOrder As Integer Select Case vMonth Case 1 'Jan is set to 10 tmpOrder = 10 Case 2 'Feb is set to 11 tmpOrder = 11...

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

Wayne...you're good...

In the query set the field your going to search on to either all upper case or all lower case using Ucase([FieldName])

Try to lookup and assign the serial number on the Before Update event?

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