[AccessD] Data copied to both tables????

Your first comment didn't make a difference.  The 2nd one is code that runs
after the problem...so I haven't tried that yet.  In fact, I've got those
lines as comments, at the moment....

Thump, thump, thump, crunch {ouch....that was my nose}.  Lol  :)

Keith E. Williamson
Ashland Equipment, Inc
phone # (410) 273-1856
fax #     (410) 273-1859


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R Mattys
Sent: Friday, August 27, 2004 4:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data copied to both tables????


> Can someone please tell me why the code below adds data to BOTH the 
> tblfax table AND the (tempfax_& currentuser) table??????
>
> I'm at wits end here. All the fields being added to recordset 
> "mytable2"
are
> from unbound fields in the open form. The intent here is to copy an 
> empty table "tblfax" (which has no data), and call it "tempfax_" & 
> current user.....copy the forms data to this table...and use it for 
> the data
source
> for a report. For some reason...the data is being copied to both 
> tables. I can't understand why. Any ideas???
>
> Dim db As Database
> Dim stDocName As String
> Dim mytable2 As Recordset
> Dim sqlstring As String
> Dim recSource As String
> Set db = CurrentDb
> DoCmd.CopyObject , "tempfax_" & CurrentUser, acTable, "tblfax" Set 
> mytable2 = db.OpenRecordset("tempfax_" & CurrentUser)

Keith,

No idea why, but two things you can try:

1) After DoCmd.CopyObject, try db.TableDefs.Refresh
2) Make sqlString = "Select * From tempfax_" & CurrentUser & chr(34)
     and use db.OpenRecordset(sqlString)
----

Michael R. Mattys
Mattys MapLib for Microsoft MapPoint http://www.mattysconsulting.com


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com