Search results for query: *

Hello All, I have a form that allows the users to select (via checkbox) which sheets they would like to combine into one pdf output. As my title says I am getting an "Error 9 - subscript out of range" error. Any help would be greatly appreciated. Private Sub cmdPDF_Click() 'On Error Resume...

Hello All, The various tables, views and reports all use the "Baseline" field value for their calculations, including "Earned Value". Has anyone created a custom table/view or report showing Earned Value data using Baseline1 or any of the other Baseline"x" values. I can create a custom table...

Hello All, A client has been having difficulty opening attachments that are part of an email which ACT! has stored. The email settings are to save the entire email plus attachments as a history item. When he attempts to open the attachment he gets the following error message: I have found out...

A user (Fred) has the following error message appear when attempting to open an email in the contact history: The email was added to the contacts history from a different user (Tom), however other users are able to successfully open the message. The user in question (Fred) is able to open...

Hello All, I am using the "subtotal" menu command to group and subtotal a list of information. The code created is the following: Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(6,7,8), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=True The issue is that the...

Hello All, When doing a mail merge with output to email and with an attachment we have noticed each contact has a copy of the attachment in the history. Is it possible to do the mail merge with an attachment but only have the history created, but not have the attachment included in the history...

Hello All, I have been looking for a code sample that would enable the user to drag and drop a listbox value to a cell on a spreadsheet. The samples I have found so far are for drag and drop to change the order of the values in a list box, drag and drop values from one list box to another (still...

Hello All, Has anyone else experienced this? I am a single user of ACT! 2007 (9) and it is currently set to check for updates every 10 days. Last week when I started ACT! I was prompted to check for updates. So I said yes and after it checked for updates I was informed that I was up to date...

Hello All, I am trying to find out which table the following fields are from. On the A/R Invoice Entry form there is an "Optional Fields" tab. On this tab there is an optional fields column and it has three values - Lease1, Lease2, Lease3. Does anyone know which table these fields are on...

Hello All, ACCPAC 5.0A I am trying to create a custom version of the GLPTS1 report and I cannot find a non-datapipe version of this report. Can anyone help point me in the right direction. Thank you in advance. Regards, Michael

Hello All, We have just purchased ACT! 2007 Premium for workgroups and I have to setup and configure the following: 1. Multi-user networked setup 2. Create a number of customized fields and create customized layouts 3. Determine Synchronization policy I seem to recall there was a list of "Best...

Hello All, The Crystal Developers User Group of BC (www.cdugbc.org) has been thinking about organizing a Regional meeting or Conference. Three of our members were at the BOBJ User Conference and will be reporting to our members at our next User Group meeting. This Regional User Group Conference...

Hello All, Many of you may not be aware that Business Objects (BOBJ) is introducing a Classroom Licensing Agreement to all training centres offering public Crystal Reports training. This CLA is to take effect June 30, 2005. The following are some excerpts that you may find interesting: "The...

Hello All, I have incorporated the following error handling from the Help files into a form: Private Sub Form_Error(DataErr As Integer, Response As Integer) Dim Msg ' If an error occurs, construct an error message On Error Resume Next ' Defer error handling. ' Check for error, then show...

Hello All, I am creating a Purchase Order form that uses a list box to show the BarcodeNumber, Description and WholeSaleCost of a Product using this: SELECT [tblProducts].[BarCodeNumber], [tblProducts].[Description], [tblProducts].[WholeSaleCost] FROM tblProducts WHERE...

Hello All, I have been trying to figure this one out for some time. . . Does anyone know how to get your Presentation 11 Show to loop continuously? Thanks for your suggestions. Regards, Michael

Hello All, I have created an Access solution that has been split into BackEnd and FrontEnd databases. The client uses Access 2000 runtime for the FrontEnd, with one computer with Full Access 2000 to allow for inhouse modifications. The usual course of events is that I work on the FrontEnd...

Hello All, How would I remove a Module (without saving) with code. I've gotten as far as Application.VBE.VBProjects.Remove The prompt for Remove is lpc as VBProject Of course the computer I am currently on does not have the VBA help installed :-( The reason for this is that I would like to...

Hello All, I've been working on the following and cannot figure out how to get the wkbook variable from the UserForm_Initialize() to be available in the cmdImport_Click() procedure. This is the code I am working with: Public Sub cmdImport_Click() Dim i As Integer Dim wkbook As Workbook...

Hello All, I am using this code to create a new task that appears in the users task folder. However, I would like it to be created in a Public Folder "Common Tasks". Any suggestions? Public Sub CreateTask() Dim outObj As Outlook.Application Dim outTask As Outlook.TaskItem Dim...