Hi,
Chris Here, I am using the ddesend function to send information to an excel sheet from Access 2000. I have made text boxs with ddesend expressions in them on the form and made them not visable. when I first open the form the ddesend works great. but if I close the form the ddesend does not resend unless I use a sort or filter to make it refresh. Is there a way that I could use a button to make ddesend refresh and send on demand? The normal refresh button does not resend the command, and using the sort command changes the view of the data. I would like the data to reman in its view and have a button resend the information to excel.
Thank you so much
Chris Pearson
cpearson@optimumwindow.com
Chris Here, I am using the ddesend function to send information to an excel sheet from Access 2000. I have made text boxs with ddesend expressions in them on the form and made them not visable. when I first open the form the ddesend works great. but if I close the form the ddesend does not resend unless I use a sort or filter to make it refresh. Is there a way that I could use a button to make ddesend refresh and send on demand? The normal refresh button does not resend the command, and using the sort command changes the view of the data. I would like the data to reman in its view and have a button resend the information to excel.
Thank you so much
Chris Pearson
cpearson@optimumwindow.com