Search results for query: *

well, i still don't understand the conflict totally, it seems to be between xp_sendmail and access97 updates sent to remote linked tables... but i did do a workaround.. changed the trigger to insert email notice rows into another table, then scheduled a job to run every minute to take the first...

...CHANGE THEN EXIT if not update(approved_by) begin return end --DETERMINE IF PO WAS SELF-APPROVED AND REACHES LIMIT OF $1000 IF EXISTS (SELECT * FROM INSERTED WHERE APPROVED_BY = INITIATED_BY AND TOTAL >= 1000 ) BEGIN --EMAIL CODE DECLARE @EMAILMESSAGE VARCHAR(255), @LOC VARCHAR(2), @PO...

Has anyone experienced this error with Sql upsized Access DB's? I have a purchasing system upsized from access to sql and it's been working fine for about 1 1/2 years, then about a month ago, people started getting errors. The screen would freeze (about 40% of the time) when a record was...

Has anyone experienced this error with Sql upsized Access DB's? I have a purchasing system upsized from access to sql and it's been working fine for about 1 1/2 years, then about a month ago, people started getting errors. The screen would freeze (about 40% of the time) when a record was...

I am developing in Access 2002 (file format of Access 2000) and saving down to Access97. None of the DAO Objects are being recognized "Dim Db as Database", does anyone know a reason why?? The Tools..References option on the client's Access 2000 is greyed out as well, so i can't check...

oh, nevermind...it was easier than I thought, thanks for listening though. In the Untyped Dataset Properties, you need to manually add a table and the appropriate columns. Then the datagrid will be able to "see" the appropriate columns, then you can add those columns to the datagrid...

I have a stored procedure i want to use, but the dataadapter won't generate a dataset, because it doesn't recognize the #tmp tables the sp is using. How can i use an untyped dataset to accomplish this. Normal SQL: SqlDataAdapter2.fill(Dataset21) Datagrid1.Databind() '''where the Datagrid's...

looks like I have a fix, go to "picture properties" of graphic and enter absolute address to graphic on hard drive, i.e. drilldown through C: to file:. Then when saving, it will overwrite the relative site file with this "new" embedded graphic. Kind of a pain to do for all...

Anyone experience this problem and know how to fix? When in design view, the images won't show, neither in preview but when I upload site, image links work fine, and display fine. Whole site is stored on my http://localhost with XP and uploaded to web server. Import images into local site...

Has anyone had this problem? If you are working in VS.net, I've got some .aspx files open and i can toggle between design/html view. But I went to duplicate this file, and did a "Save As", and typed in a new name. Well, form1.aspx closed and form2.aspx the "save as" file is...

That worked Perfect! thank-you! nstouffer

I am working on a group by query: Original Table: -pk- -pk- AssetID TsfrDate TsfrFrom TsfrTo 1522 09/01/2002 <null> TX 1522 10/01/2002 TX NV 1523 05/01/2002 MN IL 1523 06/01/2002 IL MI 1523 04/01/2002 <null> MN...

thanks for the options, that solves it for my if..then statements, BUT, here is where I was hoping to apply it: As a filter on the open event of a form, such as... Me.Filter = &quot;Status = 'Open' AND ApprovedStatus = 'Not Approved' AND LocID in (&quot; & cLocList & &quot;)&quot; Me.FilterOn...

Access VB won't compile (recognize) the following simple SQL operator: in() How do you perform this needed operation in access vb. Ex: Dim Loc as Integer Dim sLocList as string Loc = 20 sLocList = &quot;20,21,22,23,24&quot; If Loc in(sLocList) then ''do this else '''do that end if It just...

Worked excellent! Thank you so much! nstouffer

I have a date field &quot;RecheckDate&quot; in SQL. I need to update the Day to 15 for all rows. 05/31/02 will become 05/15/02 06/24/02 06/15/02 08/23/02 08/15/02 What is the best function to use to accomplish this? I had trouble using the...

You might be able to accomplish what you need in one report instead of using a subreport. You could insert a group on user, and sort the records by username, then type. In the user's group footer you could list both the number of fin and non-fin problems that user had by placing...

Does anyone know if I can force a particular doughnut slice color to always be a certain color? I can change the color but CR is only storing my colors based on listing of categories in my group..i.e. First = Red Second = Blue Third = Yellow I would like it to be based on name...i.e. Medical...

thanks for listening to my ramblings.... I found that the Web Assistant wizard added SQL Code to my triggers on that specific table...so i deleted that line item and everything is back to normal!!!!!

I think it has to do with IDC files, does anyone know where these are, or how to delete them??? thanks.