Search results

Here is an odd one. I have quite a few reports that have been running fine for years on an older WinXP PC (Office 2002). Since switching to a Win7 PC, all of the reports that are sent via SendObject (either in a macro or in a module) are being created correctly but get stuck in Outlook's...

I am currently working on a database that will be sending out multiple reports but they need to be sent from different e-mail profiles. I have the two profiles set up but I am at a loss with how to select which profile to use in my code. Here is a sample: Dim obEmail As Object, obMsg As...

I might be biting off more than I can chew but here goes. I have a form where the Detail displays a list of records with some basic data and the Form Header lists more detailed information for the record that is selected in the Detail. What I would like to do is format the Detail fields so...

I received an interesting request today and was hoping someone here could help. Using Outlook here one of the managers set up a Contact List folder under our public folders to store vendor contacts. These will be used as faxes instead of e-mail though. We are using RightFax, of which I have...

I am trying to copy the text from a Word doc created from a Report to the body of an e-mail that has been opened in VB. I was able to open the Word doc, select all the text and copy it but now I cannot figure out how to paste it into the body of the e-mail. Any help with this one? Also, once...

I have searched through the various means of adding an Access object in the body of an e-mail but I cannot seem to find something that works. What I am trying to do is embed an existing, formatted report from Access into the body of an e-mail. I tried exporting the report as a .html file but...

I currently have a form that displays a number of records and allows the user to double-click on a record to open up a detail screen. The problem I am running into is that as soon as the user closes the detail form and reopens the main form (with all of the records) it goes back to the top of...

I have a main form set up with 4 tabs within. Two of the tabs have buttons that close the form to open a new one. When that open form is closed the system returns back to the main form but it resets itself to show the first tab, no matter which tab was open when the main form was closed. Is...

Out IT department updated to SP2 this weekend and about half of my reports are no longer working. I cannot view, print or go into design mode. The error I am receiving is this: There was a problem retrieving printer information for this object. The object may have been sent to a printer that...

Is it possible to have operators (<, >, <=, >=) in an IIF statement like this: iif([field a] is null, > [field b], < [field c]) This is in the criteria for a currency field. I have been trying different combinations without any luck for the last couple of hours or so. :confused: :confused...

I wasn't sure where I should have posted this question so please feel free to move it if necessary. I am not even sure this is possible and I didn't know where to begin but these forums have always been extremely helpful. What I would like to do is export data directly from Access (via form...

I was searching around for the answer to this but I am drawing a blank. I have a module setup to send an e-mail but I would like to change the "From" field that is displayed on the recipiants PC in Outlook. I cannot seem to find any way to change this. I do have rights in Outlook to to e-mail...

O.K., one of my databases is used to run reports on a daily basis and currently has to be done manually. What I want is to have this run on a daily basis, early in the morning so if I am not at worh the reports are sent out. I setup the following but it does not seem to work: Using the...

O.K., so I am trying to run a macro from another database on our network from a local database so I do not have to copy over the 40+ database objects to the local one. I could not find a way to accomplish this with just a macro so I started writing a module but I think I am missing something...

I tried looking around for this but I am at a loss. I would like to have one of my databases run a macro located in another database. The reason for this is that I do not want to copy all of the objects to the new database and just have it run the macro. I looked in the help file and it...

Please forgive me if the following is confusing. I am setting up a form that contains a table in datasheet view as a subform within the main one. This table will be at the bottom with about 20 fields at the top. The fields at the top match the fields in the form. What I want to do is allow...