Search results for query: *

Thanks for the reply. Creating new tables wont really do the trick. This is to be used as an archiving tool. Moving the records to another db will allow the user to reduce the size of the db and provide an easy way to store the data in another location.

First, let me start by saying any replies are greatly appreciated. Okay...Here's the situation. I have two .mdb files that are identical in structure and i'm looking for the best way to programmatically copy, or move, some, or all, of the data from one .mdb to the other. What I mean by "some"...

You could add date field that's default value is getdate() then I think something like this will work... select top 30 * from your_table order by DateCreated desc, UserId, Date Josh

Check out link below. These BT tutorials can be very helpful. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bts_2002/htm/bts_sdk_samp_edi_introduction_ojwh.asp?frame=true HTH Josh

I love Google... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbup1048.asp HTH, Josh

If I understand you correctly you have, for example, 5 records and when you delete records 2,3, & 4 you want record with an ID of 5 to become 2. If this isn't the case please clarify An ID is not intended to represent the numerical position of a record. It is used to uniquely identify the...

I think that you're not going to accomplish what you're attempting with this code. It is fundamentally unsound. You're trying to compare Nums, which, based on your For Each, must be a collection of Foos, to a Foo. You're trying to compare a whole collection of objects to a single object...