Search results for query: *

How about something like this ? CREATE Procedure sp_SMTPMail @SenderName varchar(100) = 'John Smith', @SenderAddress varchar(100) = 'smtprelay.advance.com', @RecipientName varchar(100) = 'John Smith', @RecipientAddress varchar(100) = 'john.smith@advance.com', @Subject...

The error occurs when I use "execute sp_SMTPMail" from query analyzer. I am not aware of SQL Mail, please tell me more of this. I need to send an automated email, I planned on using a stored procedure to accomplish this so I can schedule it as job.

I am using Windows 2003 Server Standard ans MSSql 2000 and attempting to send an email using this stored procedure code: CREATE Procedure sp_SMTPMail @SenderName varchar(100), @SenderAddress varchar(100), @RecipientName varchar(100), @RecipientAddress varchar(100), @Subject varchar(200)...

The insert VBA code is working fine, I just want to disable the message box alerting the user of the table being updated. The insert code is used to log the error into a table for future actions. Thank you. Err_Command228_Click MsgBox Err.Description DoCmd.SetWarnings False DoCmd.RunSQL...

I am running a VBA query which inserts 1 record into a table. I am getting the message box warning: You are about to append 1 row(s). I have tried using: DoCmd.SetWarnings False But the message still appears. Is there another command I can use to disable this warning ? Thank you.

Hello, I am using MSAccess and Excel 2003 for this example. I am attempting to open, modify and print an Excel document from within inside Access VBA. The open and print functions are working just fine. I cannot seem to figure out how to unprotect the sheet so I can modify a cells color. I do...

Hello, this is dealing with Access 2003 and SQL 2000. I am trying to populate a list box using the following code: Dim cn As ADODB.Connection: Dim rs As ADODB.Recordset Set cn = New ADODB.Connection Dim SQLa As String SQLa = "Select * from turnspec.dbo.turncurrent order by...

I am using Access 2003 to automatically generate and send an automated email message which works fine as long as Outlook 2007 is open first. I would like to verify that Outlook 2007 is currently running before proceeding with the generation and sending VBA code email message. Is this possible ...

I am using Access 2003 VBA to generate an Outlook 2007 email which is working fine. In the .HtmlBody section I would like to have 3 lines of text instead of just one which is what I am getting now. So my question is how to create a carriage return in the .HtmlBody section of the email text...

I forgot to mention the low level is 0 and the high level is 9000.

Hello, I am having trouble with Access 2003 creating a filled rectangle. I am using the VBA code to vertically fill a rectangle for a visual display of liquid within a tank. Me.RectProgressBarRaw.Height = 2500: Me.Repaint The rectangle is filling fine but in a downward direction. I would like...

Hello, I am having difficulity deleting records based on a date. I am using Access 2003 and the following VBA code. I get no errors but the records fail to delete. In the 2 tables PDate is data type Date/Time. DeleteDate = 8/12/2008 VBA code: Dim DeleteDate as Date Path =...

I am using Access 2003 and I am populating a ListView with the following query which is working just fine. Dim rs As DAO.Recordset: Dim db As Database: Dim lstitem As ListItem: Set db = CurrentDb() strSQL = "Select * From ABS_Daily where (Machine > 0) and (Priority < 5) order by PDate desc...

Hello, I am using the following code to print out an Excel document from within Access 2003 and it is working great. If Extension = ".xls" Then Path = "\\server02\Common\emqc\plants\Setups\Winding\" Dim appexcel As Object: Set appexcel =...

Like so: DoCmd.RunSQL "Update SAP_Import set Field8 = Val(Field8)"

I have a text file I am importing into Access 2003. There are numbers that sometimes appear as 62.00 and other times they appear as "62.00" This cannot be helped. The data imports fine into Access all into text columns. I then format the column using VBA to number, double and the numbers like...

The variable is displayed in VBA as "Hours" = Empty

Hello and good morning. I would like some assitance with the following update query please. I am using Access 2003 and trying to update a table using the following VBA code. The problem is that if the variable "Hours" is null it is not updating the table with a 0 as I would like it to. The field...

Using Access 2003 and if FourXSix = 10 using this equation: White4X6 = Int(FourXSix / 3) then White4X6 would = 3 I would like to round this number up to the next whole number as in 4. Any ideas please, thank you.

Using the following code to set priorities for assembly. The code is working fine up to priority #1 sttement but priority #2 statement is over-writing priority #1 and not selecting the next 16 records. Does anyone see any obvious mistakes. Thank you. '4X4 count and set priorities SQLa =...