2 Replies - 2092 Views - Last Post: 07 July 2012 - 09:48 AM

#1 roguex20  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 35
  • Joined: 11-August 11

Validate before inserting data from another table - query or vba code?

Posted 07 July 2012 - 07:17 AM

Need to know which route I should be researching to make the following happen.

Looking to insert data into specific columns in a table from specific columns in another table. The data has to be validated before inserted.
Is This A Good Question/Topic? 0
  • +

Replies To: Validate before inserting data from another table - query or vba code?

#2 roguex20  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 35
  • Joined: 11-August 11

Re: Validate before inserting data from another table - query or vba code?

Posted 07 July 2012 - 07:53 AM

Validating for example a field called TYPE where it's either NEW, MINT, GREAT CONDITION, USED and OLD. If there is a typo it cannot go into the table

I tried doing an append query but get an error when I run. The Insert Into statement contains an unknown field...
but when I view I see the data and no errors.
Was This Post Helpful? 0
  • +
  • -

#3 roguex20  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 35
  • Joined: 11-August 11

Re: Validate before inserting data from another table - query or vba code?

Posted 07 July 2012 - 09:48 AM

I figured out the error on the append query.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1