Append Query ??? 1

[tstowe]

I have two separate dbases that encompass all of my personnel. All of the data that I want to track is coming from this source, but I don't need the amount of information that the original is tracking. So, I created a dbase with like field names and done a simple Append query to pull in the personnel and the fields that I personally need to track.

My question: Personnel come and go on a regular basis and I am wanting access to import the only the new personnel. How do I create an Append Query to ONLY bring in the new personnel into my dbase??

Thanks ahead of time.

Tony

 

[tstowe]

My shortcomings with the VB is very obvious and I apologize for the continued questions.

How do I connect the AppendQry, the Table and the Module (with your code) to run everything and make this happen?

I tried last night but was unsuccessful in making it all come together as I wanted. You mentioned that you had run the code and it worked. . .do you have a sample dbase that I could look through and figure this out any quicker? Thanks.

Tony

 

[hwkranger]

sure. e-mail me at randall.vollen@nationalcity.com

I'll send you a copy of a fake database that does exactly what you want yours to do.



Randall Vollen
National City Bank Corp.

 

[tstowe]

hwkranger's suggestion worked perfectly for what I intended the tables to do. Thanks goes to him for the work. . .If anyone wants the file simply email me at:

tony.stowe@tn.ngb.army.mil