MAking a bound form from a query

reidarT

I have a dataset with 2 tables. I have madee a query of theese 2 tables.
When I look at the datasources the query is not shown.
How do I make a form with the query as source?
reidarT

Aug 28 '06 #1

Subscribe Post Reply

1185

Cor Ligthert [MVP]

Reidar,

The term "query" is not an unique term, can you explain it a little bit
more?

Cor

"reidarT" <re****@eivon.noschreef in bericht
news:ub**************@TK2MSFTNGP03.phx.gbl...

>I have a dataset with 2 tables. I have madee a query of theese 2 tables.
When I look at the datasources the query is not shown.
How do I make a form with the query as source?
reidarT

Aug 29 '06 #2

reidarT

When I am in the dataset designer, I can right click an get the options
DataTable, TableAdapter and Query when I click Add.
I have made a query and I want to use this query in fom.
reidarT

"Cor Ligthert [MVP]" <no************@planet.nlskrev i melding
news:e7**************@TK2MSFTNGP03.phx.gbl...

Reidar,

The term "query" is not an unique term, can you explain it a little bit
more?

Cor

"reidarT" <re****@eivon.noschreef in bericht
news:ub**************@TK2MSFTNGP03.phx.gbl...
>>I have a dataset with 2 tables. I have madee a query of theese 2 tables.
When I look at the datasources the query is not shown.
How do I make a form with the query as source?
reidarT

Aug 29 '06 #3

Dennis

You might want to look at the DataView Class to filter the DataTables then
bind the DataView to a DataGrid, etc. However, I'm not sure you can filter
two DataTables in a DataView but maybe you can investigate joining the tables
first.
--
Dennis in Houston
"reidarT" wrote:

When I am in the dataset designer, I can right click an get the options
DataTable, TableAdapter and Query when I click Add.
I have made a query and I want to use this query in fom.
reidarT

"Cor Ligthert [MVP]" <no************@planet.nlskrev i melding
news:e7**************@TK2MSFTNGP03.phx.gbl...
Reidar,

The term "query" is not an unique term, can you explain it a little bit
more?

Cor

"reidarT" <re****@eivon.noschreef in bericht
news:ub**************@TK2MSFTNGP03.phx.gbl...
>I have a dataset with 2 tables. I have madee a query of theese 2 tables.
When I look at the datasources the query is not shown.
How do I make a form with the query as source?
reidarT

Aug 30 '06 #4

Cor Ligthert [MVP]

Reidar,

In my idea is that Query as it is a Select returning a whole table with the
GetBy.

That table you can than bind to your datagridview in the same way as you did
it with a fill.

Just a guess,

Cor

"reidarT" <re****@eivon.noschreef in bericht
news:Ou**************@TK2MSFTNGP06.phx.gbl...

When I am in the dataset designer, I can right click an get the options
DataTable, TableAdapter and Query when I click Add.
I have made a query and I want to use this query in fom.
reidarT

"Cor Ligthert [MVP]" <no************@planet.nlskrev i melding
news:e7**************@TK2MSFTNGP03.phx.gbl...
>Reidar,

The term "query" is not an unique term, can you explain it a little bit
more?

Cor

"reidarT" <re****@eivon.noschreef in bericht
news:ub**************@TK2MSFTNGP03.phx.gbl...
>>>I have a dataset with 2 tables. I have madee a query of theese 2 tables.
When I look at the datasources the query is not shown.
How do I make a form with the query as source?
reidarT

Aug 31 '06 #5

by: Megan | last post by:

Hi everybody- I have 2 tables, Hearings and Rulings. Both have primary keys called, CaseID, that are autonumbers. I don't want both tables to have the same autonumber. For example, if Hearings...

Microsoft Access / VBA

How to handle Primary Key violations in a bound form without causing and ODBC error.

by: Abhi | last post by:

FYI: This message is for the benefit of MS Access Community. I found that this prblem has been encounterd by many but there is hardly any place where a complete solution is posted. So I thought...

Microsoft Access / VBA

making queries read only

by: Baldy | last post by:

Hi folks. I have a query opened from a menu bar. Is it possible to make the query read only? Thanks Al

Microsoft Access / VBA

A2K: unbound combo in bound form allows no selection

by: Wolfgang Kreuzer | last post by:

Hello all, I am converting an Axs 2.0 application to a2k (I know A2K is not the most current version but Axs 2.0 support ended and A2K is supported in our company amd on every PC). The form is...

Microsoft Access / VBA

updating bound & unbound controls on a form?

by: MLH | last post by:

I have a form, bound to a query. Its RecordSource property is a query named frmEnterLienAmounts. The form has a few bound controls and some unbound controls. The unbound controls are calculated...

Microsoft Access / VBA

select query changing bound controls data

by: phonl | last post by:

I am a vb6 ADO developer looking at vb.net 2005 and ADO2.net. I used the vb.net 2005 data wizard to bind some controls to a database. Now I want to run a select query and have the bound controls...

Visual Basic .NET

Problem with ComboBoxes data bound to lookup tables

by: mjsterz | last post by:

I've been working with VB .NET for less than a year and this is the first time I've posted on one of these groups, so let me apologize beforehand if I'm being unclear, not posting my issue...

Visual Basic .NET

Making a report with only records matching certain criteria

by: Doug | last post by:

What is the simplest way to make a report where only the records where a field matches a certain date are included, and the user first selects that date (from form or popup)? (I can write the SQL...

Microsoft Access / VBA

Access 07: My query is making the back end database lock up

by: Sam Lambson | last post by:

Hi, This is similar to another post, because I still haven't gotten to the bottom of it. I have a back end database on a shared drive. Each (of 4) user has a front end file on their own C:...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

MAking a bound form from a query

Similar topics