If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MSysObjects & add-in
i created a form that lists objects in the MSysObjects table. i then created
an add-in w/ this form. the problem is when i 'run' the add-in, the list of objects is from the ..mda/add-in file and NOT from the .mdb file i am accessing the add-in from. how do reference the .mdb file's MSysObjects table and NOT the .mda's table? thanks, aaron |
#2
|
|||
|
|||
MSysObjects & add-in
Hi, Aaron.
the problem is when i 'run' the add-in, the list of objects is from the .mda/add-in file and NOT from the .mdb file i am accessing the add-in from. Create a recordset from the MSysObjects table in the CurrentDb(), not the CodeDb(). Use this recordset to list the objects. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "Aaron Kogan" wrote in message ... i created a form that lists objects in the MSysObjects table. i then created an add-in w/ this form. the problem is when i 'run' the add-in, the list of objects is from the .mda/add-in file and NOT from the .mdb file i am accessing the add-in from. how do reference the .mdb file's MSysObjects table and NOT the .mda's table? thanks, aaron |
Thread Tools | |
Display Modes | |
|
|