It must be an issue with that table then check the data and make sure that the integrity of the table is sound. Verify all lookUps, and check your indexs. Verify that there are no duplicates in fields designated as such and the fields designated as required actually has data. It is possible that I am missing something but beyond this I could only say that it could be corrupted somehow. Maybe you could try it on a different table or different database....
Limitation of DoCmd.OutputTo acOutputQuery
Collapse
X
-
Originally posted by DenburtIt must be an issue with that table then check the data and make sure that the integrity of the table is sound. Verify all lookUps, and check your indexs. Verify that there are no duplicates in fields designated as such and the fields designated as required actually has data. It is possible that I am missing something but beyond this I could only say that it could be corrupted somehow. Maybe you could try it on a different table or different database....
thanks for the help. I tried a different in table in the DB, and it exported the exact same number of rows. I will try and figure it out I guess. Thanks for all of your help and time.Comment
-
Yep solve that and you should be good to go, I wish I had more suggestions for you to look for but at the moment I can't think of anything that may cause this issue. Good luck and when you figure it out let us know I am curious as to why this could be hapening.Comment
-
Originally posted by DenburtYep solve that and you should be good to go, I wish I had more suggestions for you to look for but at the moment I can't think of anything that may cause this issue. Good luck and when you figure it out let us know I am curious as to why this could be hapening.
HOORAY HOORAY:
I have solved the mystery, I update this line:
Code:DoCmd.TransferSpreadsheet acExport, 8, "Voyager2Table", strFolderName & "\MyFile1", True
Is there a way to prompt the user to change the name of the file before it is saved?Comment
Comment