|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
April 17th 08, 02:53 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
delete query with custom form
I found a solution. Here it is if anybody cares. I just had the syntax
wrong: Set rst= CreateObject("ADODB.Recordset") Rst.Open "Delete FROM tblNonStockParts WHERE PartID = " & Trim(Item.UserProperties("PartID").value) , _ oADOConn, adOpenKeyset, adCmdTable "Joel Allen" wrote in message ... Hi, I run a Select query within by form that works fine. Set rst= CreateObject("ADODB.Recordset") rst.Open "Select PartID FROM tblNonStockParts WHERE PartID = '" & Trim(Item.UserProperties("PartID").value) & "'", _ oADOConn, adOpenKeyset, adCmdTable I changed it to a Delete query and it tells me that the PartID could not be found. Any ideas? Set rst= CreateObject("ADODB.Recordset") rst.Open "Delete PartID FROM tblNonStockParts WHERE PartID = '" & Trim(Item.UserProperties("PartID").value) & "'", _ oADOConn, adOpenKeyset, adCmdTable Thanks, Joel 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to delete a custom form in outlook? | Creeno | Outlook - Using Forms | 1 | September 21st 06 09:02 PM |
| Custom form display query | MikeH | Outlook - Calandaring | 0 | September 14th 06 04:16 PM |
| How can I delete a custom contact form? | DustyRocket | Outlook - Using Contacts | 3 | August 11th 06 10:22 PM |
| Delete a custom form in Outlook contacts 2003 | Jamie | Outlook - Using Contacts | 1 | March 17th 06 09:49 PM |
| can't delete custom form | Sue Mosher [MVP-Outlook] | Outlook and VBA | 0 | February 1st 06 04:32 PM |
Hybrid Mode
