Search results for query: *

Please disregard this post, I have read a few other postings which explained how update queries work with .adp databases and I think that update queries will be the best way to accomplish the task. Thank you!

I am trying to create a stored procedure that I can call when I have completed data entry for the assessments that occurred for a patient at a visit. I want the stored procedure to update the tbl_Patient_Visit with the FK identity columns found in each assessment table. Thus far I have...

I have a table, Patient_Visit v_id (auto_id) (PK) date rater columnA(FK) columnB(FK) columnC(FK) with a 1:M relationship between multiple assessment tables. Each assessment table has a Unique Primary PK which is a FK in tbl.Patient_Visit (ex. column A[FK] There is also a FK (v_id) in each...

Thank you, I figured it out. Apparently, a trigger command which was being called at a similar time was conflicting with ability to call a similar named procedure. Thanks much!!

Thank you for taking time to look at my code: This VB code calls the stored procedure to update data. Private Sub Update_Record_Click() Dim cnn As New ADODB.Connection Dim cmd As New ADODB.Command Dim rsConsent As New ADODB.Recordset Dim param1 As ADODB.Parameter Dim param2 As ADODB.Parameter...

Yes, when calling the update stored procedure with the triggers in place, it responds unable to connect to 'mydatabase' OR it will state error 'invalid item' and will not edit data. However, if I remove the Update trigger, the command to call the update stored procedure will edit data without...

I have an update trigger for each column in my tables that log when items are inserted, updated, and deleteted. I am also calling a stored procedure to update the tables and there seems to be a conflict. Both programs work when isolated but not one with the other. Does any one know how I may...

I have an update trigger for a table and a VB command procedure which calls an update sql proc for editing of table fields. I am receiving an error message when updating fields noting that database is not available. However, if I delete the update trigger, and then populate the update...

I have an Access form connected to data located on SQL Server. The Access form contains a command button to call a SQLServer sproc. The command button works fine in another form that has the following datatypes: int and smalldatetime. However when adding the connection string in another form...

I am trying to call a SQLServer 2000 proc to update .adp record columns. We are able to complete task for data and int columns but have run into difficulty in passing nvarchar and char columns. We are receiving error "Cannot open database"mydatabase" requested in login. Login Failed. The...

I am having the same problem. I have an Access (.adp) project and all forms are unbound. My tables are located on SQL Server 2000 and communicate to Access Forms via ODBC/ADO. I have changed the property setting 'uniquetable' to the appropriate recordset for each form. Fields of tables on...

Thank you much! lt

The enterprise manager states that the syntax is acceptable. However, I have a cmd procedure in VB that calls the proc_ConsentUpdate from an Access, 2003, Form (.adp). The table has the following fields: icd_id, pt_id, vdt_con, cons_dt, vdt_hip1, hipa_dt. I wish for the procedure to update 1...

Thank you, very much. I have made all revisions and continue to be at a dead-lock. I am currently receiving message "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another". I have revised information from the ADO mapping site, as recommended. I...

I have copied the following code for updating/editing sql server 2000 table data, which has errors that I do not understand how to resolve. I would greatly appreciate guidance. CREATE PROCEDURE procConsentUpdate( @icd_id int = NULL, @pt_id int = NULL, @RetCode int = NULL OUTPUT, @RetMsg...

Thank you, HTH. However, it is still not working. I think it has something to do with my procedure, although the sp passed the syntax check via Enterprise Manager.

I need to update a sql server 2000 table from an Access adp form. The form record set property 'unique table' is assigned; however the fields on the many side of the relationship are not updateable. I have developed VB code to call a SP via ado with lots of issues. Most currently I am stuck on...

Thank you, the code is: CREATE PROCEDURE procConsentUpdate( @icd_id int = NULL, @pt_id int = NULL, @RetCode int = NULL OUTPUT, @RetMsg varchar(150) = NULL OUTPUT) AS DECLARE @vdt_con smalldatetime DECLARE @cons_dt smalldatetime DECLARE @vdt_hip1 smalldatetime DECLARE @hipa_dt...

I have created a sql sp with a cmd prompt to run sp with parameters to update form and receive error "parameter is improperly defined. Inconsistent or incomplete information was provided." I have posted code below and would appreciate input. Thank you! Private Sub Update_Record_Click() 'Declare...

I wish to update database data housed on sqlserver2K via Access 2003(.adp) front-end. My current codes is noted below for table: Consent:icd_id (int), pt_id(int), vdt_con (smalldatetime), cons_dt(smalldatetime), vdt_hip1(smalldatetime), hipa_dt(smalldatetime). My code thus far is not...