Search results for query: *

I am continually getting an error with some pretty basic code. The error is "error 3061 too few parameters expected 1" which normally means there's a problem with the SQL. The code is below: Private Sub Command11_Click() On Error GoTo Err_Handler Dim strReport As String Dim strMailTo As String...

I have a string, KC1055-SP11#B5-BLK/SMK, that I need to map only the data to the right of the # sign. Unfortunately, the length of the data varies as does the start position within the string. I know there is a way to set it up to look for the character and map the information there, but I'm at...

I am working in Excel 2007. I am trying to define and select a range using a variable for the last row. The variable is defined (mouse over shows the right number), but I am getting an "application-defined or object-defined" error. I am new to VBA in Excel and doing anything with ranges and...

I have a form that doesn't allow the user to print a label if the data for the label has not been updated/verified in the last two days. It is a simple If/Then statement based on a date/time stamp field. I have been asked to change this to they can't print if it has not been updated each...

I am getting the following error: 42000:[DataDirect][ODBC PROGRESS driver][PROGRESS]Syntax error (7587) [Database Vendor Code: -20003] whenever I try to run the following command in CRXI: SELECT "abs_mstr1"."abs_shipfrom", "abs_mstr1"."abs_par_id", "abs_mstr1"."abs_shipto"...

I am getting the following error: 42000:[DataDirect][ODBC PROGRESS driver][PROGRESS]Syntax error (7587) [Database Vendor Code: -20003] whenever I try to run the following command in CRXI: SELECT "abs_mstr1"."abs_shipfrom", "abs_mstr1"."abs_par_id", "abs_mstr1"."abs_shipto"...

We are running Outlook 2007 on XP Pro computers. I have all of the users setup to archive e-mail in .pst files on the file server (running Server 2003). When users periodically are asked to delete files from their archives (pst files), it seems it takes a random amount of time for the .pst file...

I am using CRXI and have an issue retrieving data from a table. The data in the table is stored in the following format: 2.3454;0;0;0;0 24.35;0;0;0;0 2.32;0;0;0;0 I need to only retrieve the first number from the array. Thanks John Green

I am trying to run a query from Crystal Reports using a max SQL command. All I get is a syntax error. The code is below: SELECT DISTINCTROW Max(comh_corder_version_head.covh_due_date) AS LastOfcovh_due_date, Max(comh_corder_version_head.covh_order_number) AS MaxOfcovh_order_number...

I am setting up a new form in Outlook 2003 and when I go to send it, the e-mail shows up in the inbox blank. When you open the e-mail item, it shows the form. I know there is a way to show in the preview window that it can't be displayed in preview, but must be opened. I just can't figure out...

I am trying to create a field on a form that will start with a value entered as a parameter and displayed on the report and add one to each subsequent record (add one to the first, two to the second, etc...). I have started with this formula: VAL ({?Ticket}) + Val (RecordSelection) The formula...

Below is the code. I get an error message saying the object does not support this property or method where I have the code "Reports(stDocName).Printer = prt". I have used this code elsewhere (on other forms) and it works fine. I am using Access 2003. This code looks at a ComboBox and sets the...

I have a query that searches two tables. I want results if there is no value for a persons last name in the second table of if the attendance code is either a FWP or PA in the second table. The key value is the Clock Number, which I have the two tables joined by. John Green

I have a Calendar application (found it here and modified it for my use) that when I import the tables, forms and modules into a new database it starts giving me a "Compile error: Method or data member not found" Here is the code: Option Compare Database Option Explicit Public db As Database...

I have written code that "prints" a report to Adobe and then gathers e-mail addresses, creates an e-mail, attaches the PDF and then sends it. The problem I seem to be running into is Access can't find the PDF because it is still in the process of being created. I need some way to pause the code...

Does anyone know where the value is stored for the internet history when it is entered in the IE control panel? All of our computers have this feature disabled through a recent update (the whole general tab is gone) and I need to check the settings. John Green

I have some code I am trying to get to run that goes through a list of e-mail addresses and adds the addresses to a string based on specific criteria. What is happening is the SQL that specifically calls out a value works, but the SQL that references a form for the value does not pull the work...

I am continually getting Run-Time error '3061': Too few parameters. Expected 2. Here is the code: Function PNPullTogether() As String Dim strPN As String Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("qryPartNumberWO", dbOpenDynaset) strPN = "" If rst.EOF...

I have two tables that have a one to many relationship based on the WorkOrder fields. The main table records information on the WorkOrder and the part number table only collects part number information in the fields named "Prefix", "Body" and "Suffix". There can be multiple part numbers for each...

I have a listbox on a form that gets values from a combination of comboboxes used as filters. I am trying to set the default value of the listbox to be the first value in the list. Since this value changes depending upon the choices made in the comboboxes I am at a loss. I know this should be...