I need to "grab" a table from an SQL server programaticly. (No wizards)
Also, I can't use a DSN file. The front-end I am making (for an SQL back-end) will be distributed and needs to be "self-contained".
So: How can I connect to a table on an SQL server and have it show up on my list of linked tables in my .accdb file?
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…