Moonshine
Registered User.
- Local time
- Today, 19:51
- Joined
- Jan 29, 2003
- Messages
- 125
Hi All
Im trialing a new ADP, linking to a SQL database, with 30+ tables in it. I know i can create recordsets and SPs and add to a table that way, but that would take a while with what i have.
So, is there anyway of using the MDB code, in an ADP?
For a record add my code would be something like this:
Can something like that be done in an ADP?
Im trialing a new ADP, linking to a SQL database, with 30+ tables in it. I know i can create recordsets and SPs and add to a table that way, but that would take a while with what i have.
So, is there anyway of using the MDB code, in an ADP?
For a record add my code would be something like this:
Code:
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset(SQL Statement or Table Name)
With Rst
.AddNew
Me.Text1 = .fields![Fieldname1]
Me.Text3 = .fields![Fieldname2]
Me.Text3 = .fields![Fieldname3]
.Update
.Close
End With
Can something like that be done in an ADP?