Append Queries

[Mark Richardson]

I have created an append query to transfer some data from one table to another. This works fine but For some unknown reason it is not picking up all of the data. It is leaving out one row of data. The query picks up data that has been ticked off as complete but when i go to move them across, by closing the form., the query only transfers 3 not 4 of the records. Any suggestions. I could just be being thick. Someone has suggested i need to go to the next record before the query will pick up all the data but as the form only shows specifcly requested data that will not work.

 

[neileg]

Sounds as if the form is closing with the record still dirty ie changes not saved. How are you running the append query?

 

[Mark Richardson]

Append

Using a Command Button. The macro i am running with it saves the data first then runs the append query.It works when you tab out of the check box to the next blank record but i was hoping to have to avoid telling people to do that, you know how forgetful people can be.

 

[neileg]

I'm guessing a bit here since I'd rather use code than a macro, and I don't know what your macro is, anyway!

I presume you have used the macro command Save. What object have you specified? If you leave it blank, it will save the form. I'm never very sure what happens when you save the form, but in a macro you don't have the option of saving the record.

However, closing the form definitely saves the current record. So I would amend your macro by taking out the Save and closing the form before you run the update query.

Hope this works!

 

[Mark Richardson]

CHEERS WILL GIVE IT A GO.