Search results for query: *

Access 2003 has a recovery feature to restore to a previous version of your database. Just right click the icon for your database and click properties. Then click previous versions and you will have a list of all the previous versions of your database based on time and date. You can go back as...

Thanks mgolla. I found out from using your code that it was actually a line feed that was in excel and not a carriage return like I thought. So with a bit of tweeking, I was able to easily get rid of the unwanted character. It sure beats manually removing them.

Lately I have been receiving excel files with the address cell containing one address, a carriage return and another address. I need to export these excel files into access. Is there some way to remove this carriage return from excel before exporting or to remove them from access after...

How about trying to export straight from Access to Excel. Go to File export as and then select file type as excel.

Try going into Tools - Mail Merge and following the steps that come up in the wizards. I had no trouble adding fields from the database to a word document. You'll want to create form letters and then get data will be your table in Access. You'll also need to add merge fields to your document...

Here is a query that we use all the time for randomizing. The (cat_ups_mailing_1) is the table you are selecting from and the (tmp_mail_4) is the table you make to put your random selection into. The fields selected in the where and order by are the criteria for your random selection. SELECT...

I create databases in 2000 and convert them to 97 all the time as different users need different versions of the databases. Just go to your tools and click on convert database to a previous version. Just remember to add 97 or 2000 or something to your database name when converting so you open...

My computer has recently been upgraded to Access 2000. I work with numerous Access databases. Many of these databases are made by importing data from Excel. Reps and dealers email these Excel files. They are in various versions of Excel and have unknown formats. I am finding that with...