Thanks! That makes sense.

Sam

Aaron:

This is an old question so you may have answered it by now. How is your subform related to the main form? Are you linked on a particular field? If you...

ling: If you're just getting started, I'd recommend Mary Chipman's book. You will find it extremely helpful if you are using SQL backend with MS Access frontend:

http://www.amazon.com/exec/obidos/tg/detail/-/0672319446/qid=1115168066/sr=1-1/ref=sr_1_1/103-4027661-1675058?v=glance&s=books

Here are a...

Thanks, Kathi.

I found the issue, in case anyone else encounters this. It had nothing to do with key violations. One of the columns was NOT NULL and a value was...

If you open an Access project (.adp), it will automatically convert your queries to either stored procedures or views. You can then edit or revise the stored procedure from SQL...

I just can't believe it! Yes, SCOPE_IDENTITY was the issue. THere is a trigger on the Appointment table as you suspected. I wish I had put this out there two...

Thanks, guys. Those are some of the names I had come up with also while searching the web.

Appreciate it!!

Sam

Private Sub YourFunction()

    Dim Conn As ADODB.Connection

    Dim cmd As ADODB.Command

    Dim rst as ADODB.recordset

    Dim rstSQL as String

    Set Conn = New ADODB.Connection

    Conn.Open fstrCnn()

    Set rst = New...

Appreciate it. Reseeding... yes, that's what I am doing to do. 🙂 I think I've got it licked.

Sam

I really appreciate the input. I will let you know how it goes.

Hi Keith:

Yes, after I told you not to use the master I got to thinking about it and realized I was wrong. But you figured that out. I can't read...

Hi Keith:

1. Make sure that you have a value for each input parameter the SP is looking for. If if needs 5 input parameters, you may want to input copy...

1) open Student table in design mode

2) on toolbar at top, look for and open icon for "manage relationships"

3) create a new relationship

HTH,

Sam

You don't need a pass-through query to run a SQL stored procedure. This is how you would accomplish the same thing with ADO. If you need the ADO objects,...

Calvin: yes, thanks for this article. I posted this same question on the MSDN newsgroup and got thoroughly "burned" for the same reason. So I plan on making some changes.

But...