I need to create some linked tables in Microsoft Access to tables in SQL Server. I created a File DSN ODBC connection to my SQL Server, then in Access, chose New Data Source > From Other Sources > ODBC Database, selected “Link to the data source by creating a linked table”, navigated to my file DSN, selected my tables, and everything is working great, I’ve got data in my linked tables.

How Do I put a search text box in a form in Microsoft Access? Please include demonstration pictures.

I have a list box (List68) that on change I want to use the bound id column of the list to query a multivalue field based on the id of that column. I want the values (for viewing only) to be added and displayed in another list box (List71). There is a one to many relationship between L3Process.ID and L3Process.DataObjects.

I have a table called CPW Detections and it looks something like this in the columns

My DataObjects field is a combo box display field. I want to take all of the checked values from the combo box and show them in a list box. In my table “L3Process”, the “DataObjects” field takes values in a comma separated list (i.e. 1,2,3,4,5). In design view, the “DataObjects” field is classified as a “number”.

I have used this command on cable table for two fields EndString, GeneralFormat

I want to write submacros that open reports from forms.
My forms would have buttons that say things like “Print Report”, “Show Print View”, etc.
I want to call the same submacros from different forms, since the only difference is the name of the report.
The buttons would call the macro with the name of the report.
Is there a way to pass the name of the report from the button to the macro?
I’m pretty sure it is possible in VBA, but I want to know if it will work as a macro
TIA

I have the following line of code that will attach an ‘attachment’ to an e-mail that is being automatically created:

I have various routines within an Access database system that open Excel, open a workbook, make changes before saving it, closing it and quitting. Basically, I use this code:

I am familiar but rusty with vba for excel but trying to apply what I know in an MS Access database with no luck.