Search results for query: *

How is the best way to delete a table in a Microsoft Access 2000 database in code? I need to be able to do this in an application that I am working on. I want to delete a table in code and then re-create the table and populate it with records from another table. Thanks in advance...

Do you have date1 declared as a string or a date variable?

Phew! That is a mouthful. If you can give me a little more information about how you plan for the user to define the regions I might be able to get you on the right track. Noble

I am assuming that all this is done from Access because the user may or may not have the Excel spreadsheet open at the time? The button is on a Access form not on an Excel spreadsheet. Thanks, Noble

I got some help here earlier and it seemed, at the time, to work but... What I want to do is this: I have an Excel spreadsheet that contains data in different columns. I want to be able to take data from an Access Database and add it to the Excel spreadsheet without distrubing the data in the...

Hello all, I am trying to send data that has been entered from a form in Access to an Excel spreadsheet but I do not know how to achieve this. Any help would be appreciated. Thanks in advance, Noble

Hello, I know there is an easy way to do this but I am not sure how to go about doing it. I have a main form and one of the fields is a combo box that pulls data from another table. The table the data is pulled from has an ID field and a NAME field and a PHONE field. I want to be able to...