Results 1 to 3 of 3

Thread: Access: Query question??

  1. Nov 13th, 2006, 10:27 AM #1
    noycwild
    noycwild is offline

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    53

    Resolved Access: Query question??

    Hi all,

    Kinda strange thing happening here. Ok i got two tables, with the same specs.
    One table has records, the other is used for appending to. I create a query within code to append records to the other on the fly, and get a data type conversion error. I have no idea why this is happening. The tables are the same. But if I was to open the query in design then save it, there is no problem. Any ideas what the problem could be?
    Last edited by noycwild; Nov 13th, 2006 at 01:57 PM.
    Reply With Quote Reply With Quote
  2. Nov 13th, 2006, 10:35 AM #2
    danasegarane
    danasegarane is offline
    Learning .Net danasegarane's Avatar
    Join Date
    Aug 2004
    Location
    VBForums
    Posts
    5,853

    Re: Access: Query question??

    Post the code you are using
    Please mark you thread resolved using the Thread Tools as shown
    Reply With Quote Reply With Quote
  3. Nov 13th, 2006, 11:34 AM #3
    noycwild
    noycwild is offline

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    53

    Re: Access: Query question??

    I went through the table and noticed some of the fields had bad data and it would crash when it started to convert. Thanks for the reply. I could of sworn I double checked the data before lol.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width