index > Visual Basic for Applications (VBA) > Loading Select data through the linked tables

Loading Select data through the linked tables

I have an access front end whose tables are linked to an sql server data base. when the database loads is there a way to select certain data to load through the linked tables. For instance Say I wanted the liked tables to load only the data for the customers in the state of Connecticut. I know I can do this with queries but I want to know is it possible to do with linked tables directly.

Follow and trust in Jesus Christ and recieve Eternal life

GetCode

In access you only have the capability to link to the entire table...however as you suggest you can create a view that will only show you the criteria that you set for the query

MSDN Technical Forums Moderator - Happy Coding :)

DMan1

reply 2

You can use google to search for other answers

More Articles

• Help with simple program

• Adding a worksheet to the workbook

• Help to do macro more dynamic

• Access/VBA add the value to ListBox every column

• copy chart from excel to word

• [ACCESS] How to create menu silimar the attached photo

• VBA in EXCEL - Connect to SQL Server

• VBA Module to DLL

• Defining a range according to the number of responses

• Excel 2003 - hiding a row question

Welcome to Bokebb New Update Joins the collection

New Articles

• run a macro in excel
• overflow error 6
• VBA w/ Word 2000 - keep form on top of a
• Unsuccessfully trying to open Power Poin
• How print picture
• Linking Infopath Toolbar Buttons to VBSc
• copy chart from excel to word
• Executing update field only on a selecte
• Question reg BeforeDoubleClick event in
• Call Windows API to store hyperlink path
• Controls in a Word Document
• Global Variable in Excel question
• code in visual basic to convert decimal
• Adding Appts to a Group Calendar
• Office XP VBA can't find reference after

Hot Articles

• VBA eBook
• vba error message
• Protecting the Source Code
• Detect Excel Version in VB6 Application
• is it possible to get windows Services w
• converting text to Hours Minutes and Sec
• Using VBA to send an MSN instant message
• Copy Outlook email into Excel
• Using of APC.IDE.PreventShow property
• How can I modify the "Available Ref
• Wanting generate a HTML output right to
• Problem sorting dates!
• Excel Server Using VBA
• ms access counting specific values on a
• fm20.dll

Recommend Articles

• I need help figuring out what is crashin
• usrfrm initialize
• Access 2003: Connect to Word Document.do
• Access VBA and detecting when the form c
• use vba to drive a quicktime movie?
• help on list box (Access)
• Changing chart series
• Application Error
• how to convert excel to tiff file using
• VBA Excel/Oracle query and run-time erro
• Hyper link Macro
• handling volume control in C#
• VB Control Air card sent file to GPRS
• what is wrong with this formula? *9 View
• [Access 2003] [ADO Excel Connection] Run