Advertisement

1 - 10 of 656 containing alltags:("Access Query") (0.004 seconds)
I have a work related Access 97 problem, which sounds classic but gets me everytime........ I have got two Access tables A & B: Table A:    table B: item1    item2        item1    item2 ------- ...
Zones: MS AccessDate Answered: 12/16/1997 Grade: B Views: 0
I want to open an access db using vb code, and change the dbgrid Recordset source depending on sql code.  Is this possible? Lets assume that I have an access query that has 20 names, I want to wri...
Zones: Visual BasicDate Answered: 08/09/1998 Grade: C Views: 0
I wanted to pass a parameter for a query from Word, prior to doing a mail merge.  Using either DDE or ODBC, what's the best way to pass the client ID to an address table query in Access (From Word)...
Zones: MS AccessDate Answered: 10/16/1998 Grade: A Views: 0
I want to take three tables,  tablea, tableb, and tablec.  Tablea will have 9 of ten fields i want to have on table c. Tableb has the tenth field.  I want to know what do i need to do in Access to...
Zones: MS AccessDate Answered: 03/19/2000 Grade: A Views: 0
I need a query that takes info in one column and according to the first letter of the info in that column update to a number in an adjacent column.
Zones: MS AccessDate Answered: 04/12/2000 Grade: A Views: 0
I have an access table containing a total of 12 fields, for this demo I will only list 2 of them. This database also containes approx 1300 records. EXAMPLE: Date          Description 4/1/00 ...
Zones: MS AccessDate Answered: 08/05/2000 Grade: A Views: 0
I am trying to link a large Oracle table through an ODBC driver.  I can create relationships with other tables and that all works okay.  When I try to do a 'make table query' that should pull apprx...
Zones: MS AccessDate Answered: 07/14/2000 Grade: A Views: 0
I need to import a Query as a table.  I know within my Function code I can link to a table using this  DoCmd.TransferDatabase acLink, "Microsoft Access", "\\Cinapp03\Vol1\In-House\Life-Systems\D...
Zones: MS AccessDate Answered: 06/28/2000 Grade: A Views: 0
I am trying to build a query interface where my users can pick any field (the field might be numeric, text or date) from a combo box, choose a criteria in another field and have the result of the q...
Zones: MS AccessDate Answered: 12/17/2000 Grade: A Views: 0
Ok everyone I need some really good advice here.  We are developing a Access 2000 front end system connecting to SQL Server 2000 for our backend.  We are using ADO Providers for connecting.  What i...
Zones: MS AccessDate Answered: 04/23/2001 Grade: A Views: 0