Create Queries

bfsog

Well-known member
Joined
Apr 21, 2005
Messages
50
Location
UK
Programming Experience
5-10
A little vague, but I guess you mean how to string together a query while a progrm is running?

One way, would be to have some textboxes, such as one for table name, one for which rows to select, and maybe an optional where clause? For select at least.

Then you would have a click event on a control such as a button, when that is pressed, you add the values of the textboxes into a variable.

At the end you could write the result to a textbox or MessageBox.Show("") it.

Any questions, reply

Hope This Helps
 

Doron Barnea

Member
Joined
May 31, 2005
Messages
9
Programming Experience
10+
Sorry , I should be more clear ...

what I meant was how do I create Ms Access Queries through Code ...

You can create queries inside Ms-Access in Design time. Actually it's just an SQL statement that is defined in Ms-Access so you won't have to create it again and again ( kind of view ) .

How do I create one in VB.NET ?

I want to create on and save it in Ms_Access so I won't have to re-create it again and again . I couldn't see a CREATE VIEW or CREATE QUERY option for doing that ...
 

Bigbeanpole

Member
Joined
Jul 7, 2005
Messages
15
Programming Experience
1-3
Solved

I'm looking at this now as well...did anybody have a solution? I had an example of it a month ago, but my colleague went and erased that project. :|
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,570
Location
Sydney, Australia
Programming Experience
10+
I would think that you would have to use Automation, just like you would if you wanted to do something in Word or Excel. I guess ADOX might do it, but I've never used it so I can't say.
 
Top Bottom