Coded Append Query doesn't append all info?

B

Bumbino

I have an append query that moves all of the records from one table to
another and it works fine. However, in my form when I code the query to run,
not all of the fields get moved. All of the records are there, but some of
the fields aren't. Help????
 
B

Bumbino

Sorry, for got the code I am using.

Dim strAppend as String
strAppend = "Append" 'Name of Query

DoCmd.SetWarnings False
DoCmd.OpenQuery strAppend, acNormal, acEdit
DoCmd.SetWarnings True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append current records in subform 0
Append Query help 2
Append Query Issue 0
Access Macro Repeat Expression using value of a field in table 0
Form based on an Append Query 7
Clear form after append query 1
Append Query Re-run 3
Help with Append Query 1

Top