Recent content by OrWolf

My goal is to find the problem, but so far it only happens once every few weeks and I've been unable to find the source of the issue. I can certainly write a record, but I'm not certain it will get written as I don't beleive the e-mail is the problem, but the data it's retrieving. I suppose I...

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

Thanks Denny. That worked excellent with very little trouble.

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

That worked. Thanks a bunch.

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

I re-cast the field and it started to work. Not sure why, but it's working. Thanks,

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

Thanks for looking at this. I did not have an index on this table. I added it but the performance improvement wasn't noticeable. Then I found a solution that really worked. I broke the view into two, with the second select statement just being the organization table where the...

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

The way it's built I can add new rows by determining which are part of my dataset. However I need a way to find which ones are un-selected so I can remove them.

For some reason this started working today, perhaps a good old restart was required. The final step in my process is removing records, which I have the logic for, but I can't seem to figure out how to get the value for x. So if I have rows 1, 3, and 4 selected, I need to know the GUID for row...