Newcomer question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Kirkland - 30 Mar 2005 00:12 GMT

I am trying to build a form with either a grid or listbox control which will
be populated with the items from field a, but only those records for whom
field b matches the item selected in a combo box or data combo from another
table. The DB is Jet, and although this is no problem when working with
Excel, I can't find a reference for doing this with Access. If I use Excel
worksheets instead of Jet tables, will I use the same syntax to access data
in the DB? I would prefer to use access tables for the project, since I am
prototypong a more complex version for the future.

Roy

Reply to this Message

Ashok Gupta 'shokie' - 30 Mar 2005 06:41 GMT

Hello Roy !

You can esily connect to Access DB, all you need to do is, change your
connection string and you can find you connection string for access here:
http://www.connectionstrings.com

Hope this helps.

Ashok Gupta

> I am trying to build a form with either a grid or listbox control which will
> be populated with the items from field a, but only those records for whom
[quoted text clipped - 6 lines]
>
> Roy

Reply to this Message

VB Forum / Database Access / March 2005

Newcomer question