.addnew works in A2003, not in A2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I added functionality to an A2000 mdb linked to SQL Server, to create
record/row copies from current form row. It works fine in my A2003 version,
but when tried in their A2000, it's not working.

Code is as follows..

With Me.RecordsetClone
.AddNew
![Patient#] = Me.[Patient#]
![Clinician#] = Me.[Clinician#]
![FeeStatus#] = Me.[FeeStatus#]
.....etc.......

In A2000 debug mode, looking at Me.Patient# or any of the form fields, show
null values. In my A2003, the fields show correctly as valued from copied
record.
I'm using SQL Express - them sql 2000.

I've set references to ADO lib, DAO lib, etc in their A2000.

Any ideas as to why not working in A2000 hugely appreciated.

Thanks!
Don
 
Off the top of my head, I can't think of what it shouldn't be working.

Are you getting any error message?
 
There's no error messages..just adds a null record when use A2000. Debug mode
I can see the null field values after the .Addnew statement.


Douglas J. Steele said:
Off the top of my head, I can't think of what it shouldn't be working.

Are you getting any error message?


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


nycdon said:
I added functionality to an A2000 mdb linked to SQL Server, to create
record/row copies from current form row. It works fine in my A2003
version,
but when tried in their A2000, it's not working.

Code is as follows..

With Me.RecordsetClone
.AddNew
![Patient#] = Me.[Patient#]
![Clinician#] = Me.[Clinician#]
![FeeStatus#] = Me.[FeeStatus#]
.....etc.......

In A2000 debug mode, looking at Me.Patient# or any of the form fields,
show
null values. In my A2003, the fields show correctly as valued from copied
record.
I'm using SQL Express - them sql 2000.

I've set references to ADO lib, DAO lib, etc in their A2000.

Any ideas as to why not working in A2000 hugely appreciated.

Thanks!
Don
Click to expand...
Click to expand...
 
Back
Top