StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1631219
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2009-10-27T14:32:42.040
FavoriteCount
0
LastActivityDate
2009-10-27T14:32:42.040
LastEditDate
2017-05-23T12:06:59.150
LastEditorUserId
-1
OwnerUserId
16076
ParentId
1631187
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Create the VBA code in a separate COM dll, and then you can use COM interop to call from C# For instance, see SO question: <a href="https://stackoverflow.com/questions/1037786/using-a-com-dll-from-c-without-a-type-library">Using a COM dll from C# without a type library</a>. <blockquote> <a href="http://msdn.microsoft.com/en-us/library/ms173185.aspx" rel="nofollow noreferrer">Exposing COM Components to C#</a> You can consume a COM component from a C# project. The general steps are as follows: <ol> <li>Locate a COM component to use and register it. Use regsvr32.exe to register or un–register a COM DLL.</li> <li>Add to the project a reference to the COM component or type library.</li> </ol> When you add the reference, Visual Studio uses the Type Library Importer (Tlbimp.exe), which takes a type library as input, to output a .NET Framework interop assembly. The assembly, also named a runtime callable wrapper (RCW), contains managed classes and interfaces that wrap the COM classes and interfaces that are in the type library. Visual Studio adds to the project a reference to the generated assembly. <ol start="3"> <li>Create an instance of a class that is defined in the RCW. This, in turn, creates an instance of the COM object.</li> <li>Use the object just as you use other managed objects. When the object is reclaimed by garbage collection, the instance of the COM object is also released from memory.</li> </ol> </blockquote>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PORunning forms and VBA code from C# on an Access 2003 database
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USMitch Wheat
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COThis doesn't help me with calling VBA code that's heavily entangled with the database, putting code that calls specific queries in a dll wouldn't work. My main need is more the automation, opening a "connection" to the database and telling it to run a certain piece of vba code
 singulars
 PostPostId
 PO
 UserUserId
 USTarks

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.