Search results for query: *

I have a trigger that is supposed to send an e-mail notification but on rare occassions it fails which causes the record not to get added. This is definitely not something I want to have happen. What is the easiest method to just ignore the error so the transaction is committed? Thanks for...

Hi all, I have a datagrid that is linked to an Access database. I can pull in the values and update the Access table based on the values entered just fine. My problem is that I want to also be able to update a hidden column to the user's e-mail address to track who is making changes, but I...

I'm looking for a way to send a mail from a SQL Stored Procedure that allows me to specify a reply to value. I'm using SQL 2000 but will be moving to SQL 2005 within three months. Suggestions? Thank you

I'm trying to add a new workbook with only 1 sheet. When I attempt to delete the two extra sheets Excel throws warning messages that I don't want. Does anyone know how to suppress / hide these warning messages? My code: Set appExcel = CreateObject("Excel.Application") Set...

Hi there, I have a detail form with a list box that need to be able to allow a user to select multiple entries. I was able to find the code to store the values in the child table, however that code is missing the option to remove values that are unselected. Also I don't have the code necessary...

I'm trying to run a single formula to put all of my address lines together to eliminate blank rows on my report. The problem is that even though data appears in formulas with just the single field listed it does not in the formula below. I just get no value. Help please...

Hi all, I have a report with two sub-reports. The first subreport works fine and restricts based on the child/master property. The second sub-report however isn't not working correctly and displays all records. The first one that is working has used field A and field B to link. The second...

Hi All, I have a SQL view that contains a CASE statement to identify is a given value is not null in which case the result shown is a simple asterisk, otherwise nothing. This is used to identify a primary contact that is linked to an organization. The problem is that while helping the users of...

I've tried searching for this one and I'm not finding the answer I'm looking for. I have a form that has a list box that shows employees. I need to know how to allow a user to select multiple employees in that list and save them in a related table as independant records. For example the...

I have an Access database with tables linked to SQL. It works for all users except one who occassionally gets a login error. Normally the error only occurs in the morning. I've never encountered this scenario before so I'm looking for any ideas on what might be causing this? ERROR...

Hi all, I have a report with multiple section and the final section needs to display at the bottom of the page. The result is a section of nothing in the center of the page. The problem is that they have a vertical division line down the height of the report about 2.5 inches in. I need a way...

I have a database that was justed upsized to SQL 2000. All of the fields in the Access database with a data type of memo were successfully upsized to SQL with a data type of ntext. However when the tables are linked in Access the data type for those fields is text instead of memo so the data...

I'm attempting to update a row in an Informix database through a SQL task. I have the following line of code working: UPDATE SYNC SET LASTSYNCEDATE = '1-3-2007' WHERE TABLENAME = 'X' My problem is that I can't seem to find something similar to Now() or GetDate() in the Informix world. Any...

This is in SQL 7 (Please don't ask). I have a record that I cannot delete. In the table I'm able to delete other records, but this one just sits (I've let it run for over 6 minutes). The table only has 28K rows. Other records in the table can be deleted. This record also has certain fields...

I'm attempting to query against a table to pull only records where the number in a particular field doesn't have a decimal. Data ProjectID OutlineNo 1234 1 1234 2 1234 2.1 So in the case above I don't want the record with an outline number of 2.1. The following is the...

I'm hoping that someone can give me code sample to get me going on this. I have a connection to a UniVerse database in my DTS package and I'm unable to get it to use any variation on Date() to get the current date. My next idea is to set the SQL Task SQL Statement using an Active X script...

I have a value that is displaying in an error message and I need to update it. The problem is that I can't seem to locate the value. Can someone suggest a method to cycle through all of the tables and fields in a database and attempt to find a given value? Thanks!

I'm attempting to transfer data from an Informix UniVerse database into a SQL table using a DTS package. My source SQL query has two fiels with phone number (phone and fax). Both field values display correctly in preview. The problem is that when I attempt to transform the data the phone...

I'm trying to do some quick updates without writing queries each time. I was told that there was a way to set a value to null in Enterprise Manager in the query view results pane. Does anyone know the command for this? Additional Information: In Enterprise Manager right-click a table and...

I have a stored procedure that needs to process some 1.3 million records. So that the transaction log doesn't fill up can how can I commit each record as the update SQL statement is given?