Search results for query: *

thank you

haha.. yes, i know.. thank you for your fast reply, you mean create a temp table with that criteria?

hi guys, i hope you can help me, there is a stored procedure that i used in a filter form but it keeps timing out when i have over 20 users. I have tried optimizing it but i am stock can anyone tell me what else can i do? set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE...

I got the IP address of where the exchange server resides, i changed it in the activex script ,when i run it i get no errors but i still don' t get the email

where does Tbl1 come from?

how do i get the IP address of the exchange server? what about the port#? does that change too?

hi guys i had created an activex script that sends emails from sqlserver this is part of the code that pertains to my question: 'establish settings for sending of CDO message myMail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendusing")=2...

ok then can you help me put it in a procedure?

sorry i did'nt put the second view it is supposed to check.. I changed some things so here is what i have so far. Original view(it has all the data)= [ID CR Alert] my first view is supposed to check= BillTo second view= ShipTo SELECT DISTINCT TOP 100 PERCENT dbo.[ID CR...

hi guys i am trying to create a procedure that check if data in a column (NumberID) form view [ID CR Alert] exist in two different views i created. If it does'nt exist in view [Existing IDs] then to look in second view [Existing ShipTos], this is what i have so far... in first view i need to...

Thanks! i solved there was an issue in how the user was created in active directory. thanks for all your help.

hi guys i hope you can help me. I have an access form in which i have a jpg in which when i double click i could open it with windows fax viewer from my windows xp computer, using this code: Dim S As Object Set S = CreateObject("WScript.Shell") S.Run "rundll32.exe...

yes i checked. should i add my pager email into the sql server alert or it has to be added in my outlook profile under pager?

thanks for your reply, my phone receives text messages via email, i have cingular so i put: phonenumber@txt.att.net in pager email name in alerts and i test it and i don't get anything, am i missing anything?

hi guys, i am trying to connect to my backend tables in sql server 2000 from my front end access database and i keep getting this error message: Connection Failed: SQLState: 01000 SQL Server Error 1326 [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()) Connection...

I am trying to setup an operator to receive a page when a scheduled job fails. I go to the Notification tab on the Job Properties window and select Page Operator, i added my pager number. After the job fails I never receive a page. I do receive the email, there is a pager tab in my outlook...

thank you! i apreciate it!

thanks for your answer, how would the code change if i only want to delete three of my fields in the row where DistID=" & Me.txtDistID.Value without deleting the whole row?

hi guys. i hope you can help me, i am trying to create a delete button in my form. Basically what this form has to do is delete the row from my main table and then insert that row into my history table. Main Table: tblDetails DistID (PK) SalesNumber SalesStatus (is always active) Notes...

Thanks i apreciate all your help!