Recent content by jdgreen

It runs fine SELECT CustData.Email FROM CustBrandsFlat INNER JOIN CustData ON CustBrandsFlat.CustID = CustData.[customercode] WHERE (((CustBrandsFlat.Brand)=[Forms]![frmEmailing]![Combo2])) GROUP BY CustData.Email HAVING (((CustData.Email)<>IsNull([Email]))); John Green

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

Using Gentran 5.1 John Green

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

I use a method of only listing one exception. The code runs through and stops at the first exception displaying a message box. I had tried putting them all together with carriage returns, but the users like this method as they don't have to remember as much. John Green

You can try Access security, but depending on your level of knowledge about VBA there are some much better ways of doing it. I use a custom security system that doesn't require the cumbersome Access security. If you do use Access security make sure you set it up to where the shortcut assigns...