Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JoshuaL

    Copy data from one access mdb to another

    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.
  2. JoshuaL

    Copy data from one access mdb to another

    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"...
  3. JoshuaL

    Query Help Needed

    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
  4. JoshuaL

    Biztalk 2002 and EDI/cXML

    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
  5. JoshuaL

    I imported this project from VB(v.6

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

    updating and index or primary key

    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...
  7. JoshuaL

    What is wrong with this

    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...

Part and Inventory Search

Back
Top