Results 1 to 2 of 2

Thread: Need a control

  1. #1
    Join Date
    Jun 2003
    Provided Answers: 1

    Unanswered: Need a control

    I have a database of SQL Server metadata (objects, columns, etc) stored in a SQL Server 2008 database with an MS Access data project front end.

    I need to be able to map columns in one database to columns in another database. So, I have a list of the columns for a table, and I want to be able to show the columns from another table and "link" them, recording the information in one of the metadata tables.

    None of the standard MS Access controls seem to be doing the trick for me. Can anyone suggest a few of the non-standard controls that might be appropriate? Or a good online resource that lists them and describes what they do?

    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Generally speaking, not having a standard control does not mean that you cannot create one from what's available in Access. It's rather easy (provided you are skilled in VBA) to create a Class Module (or several) with specific properties and methods and bind an instance of such a class to a form or to a control.

    I'm not sure to understand what precisely you're trying to achieve (the "link" part is obscure to me), can you provide a short example?
    Have a nice day!

Posting Permissions

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