Re: error 3022 when there are no dupes
- From: Rich P <rpng123@xxxxxxx>
- Date: 14 Aug 2007 19:06:44 GMT
Hi Jan,
When you say that you are writing to the server -- do you mean you are
writing the data to a Sql Server table? Or is it a backend mdb that
resides on the server?
Well, it looks like your problem is occurring before you get to the
server part.
For starters I would not use RecordsetClone. Use DAO or ADO to set your
Recorset object
Change this
Set rsSource = Forms!comps_frm!UtilitiesSub.Form.RecordsetClone
to
Dim DB As DAO.Database, rsSource As DAO.Recordset
Set DB = CurrentDB
Set rsSource = DB.OpenRecordset("Select t1.* From tbl1 t1 Join tbl2 t2
On t1.someID = t2.SomeID Where somefield = 'something'")
...
Or if you are going to eventually write to a sql server table -- use ADO
and the ADO command Object.
to the
Rich
*** Sent via Developersdex http://www.developersdex.com ***
.
- Follow-Ups:
- Re: error 3022 when there are no dupes
- From: Jan
- Re: error 3022 when there are no dupes
- References:
- error 3022 when there are no dupes
- From: Jan
- error 3022 when there are no dupes
- Prev by Date: Date code
- Next by Date: Re: Date code
- Previous by thread: error 3022 when there are no dupes
- Next by thread: Re: error 3022 when there are no dupes
- Index(es):
Relevant Pages
|
