o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

sql query vb.net -

Hello!
I need to write an sql query in ms access so that it seaches the datebase by a field that has been entered in my VB form and i have no idea how to do it!
my query looks like this.....
SELECT [Band].[Band], Schedule.Time, Schedule.Date
FROM [Band] INNER JOIN Schedule ON [Band].EventNo = Schedule.EventNo
Where Schedule.Date = what is entered in the textbox on the vb form ;
Any help would be much appreciated!
thankyou,
Iain

 

Transform Query with sub query -
Is there any way in acccess to perform a Tranform query , and include in the where clause a Sub query? I always get a error the the filed from the main query is not a valid field in the sub query.

Programming Microsoft Query -
Hi, Does anyone know if it's possible to program MS Query, and if so, how do one go ahead? I would like to call up the query wizard from within my application, and then create a report in excel based on the query the user created with ms query. Of course, I can write my own q

Query a Query -
In the query builder in visual studio 2008 (visual basic) can you use an already created query in a new query,i.e. in a new query called query2, use table1 and query1. If not in the query builder, which would be very helpful, is there another way in StoredProcedures or code? T

Optimize query -
HI friends I have a long query that query contains 5 tables and joins are done very correct but that query s taking lot of time where as data in tables are not large.Now I wat to optmize that query how should I do that Is there any tool available for optimizing the query. I am w

Query Problem -
Hi Sir this time iam having problem with Query first when i run the query its ok but secound time when i run query it gives error that the query is already open. so some knowes how come over this peoblem please let me know thanks the Query for reporting and i give paramete

Access query and VB .NET problem -
Hi! I have trouble accessing data from a query. I am using VS.NET 2003 against ACcess 2000. The acces query returns two fields and many rows. The query works fine in access. How should i set it up in vb .net to retrieve all the data from the query ? I tried using a datareader but

Query on the fly -
Hi i want to create a query on the fly. Meaning i have a query that contains, name,class,group,attend,date.... What i want to do is select a certain date from this query and put them into another query(temperary if possible). can this be done. I'm using MS Access,VB6... Thanking yo

Running a Query -
I'm using VB6 and Access 97. I want to run an Append query using VB. I've got a Query called Transfer which has a parameter called Refno. I want to be able to send the reference from VB into this query. Which will hopefully run this query and update another table. Could anyone pleas

Referencing an Access query in VBA -
I'm trying to update a regular "Select" query using code in VBA, but I'm not too sure how to do this. I want to run the query in VBA using the docmd.runsql statement, and then I want to reference the results of that query using another query(UPDATE query) to update values in

Handling Query Results with Common Function -
I have a several query routines. These query routines narrow the resulting recordset to just one record. I also have a Public structure that is contained in a Sub/Function. I would like to assign the final query result (the one record) to the structure without having to replic

Mailing the Query -
hi i m trying to do .. like if some one writes a query.. then after submiting the query the query will be mailed to my gmail account.. thnks in advance

Query question------Solved -
I have created a query, which holds a lot of data, from different people. Meaning i have a time and attendance program with VB6 and access database. In the query i have all the different student names, I want to be able to just select a specific name from the query and show all realate

Program hangs while executing query -
I have a program that runs reports based on a rather lengthy query. While the query is running the program hangs and if minimized will not allow the user to restore the window until the query is finished. Is there anyway around this? I have used the DoEvents while manipulating the data

Executing MS Access query from VB.NET. -
I have created a query to retrieve certain results and a report that is connected to this query. This query asks for date parameter to retrieve results. It looks somewhat like this: Select TicketNo, Name, TotalFee from [MainEntry] Where DateIssue=?; I created this query in MS Acc

[2005] Creating DGV Headers via SQL Query -
I have a DataGridView in which I need to create the HeaderCells via a SQL Query. Essentially what the query does is get a predetermined number of columns based on a userID. Each column returned in the query needs to become a Header on my DGV. This query is run as a Stored Procedure. Do

Access Help fast!! -
How do you insert the result of a query into a table SELECT [Query Form].[emp #], [Query Form].observer, [Name Entry].[Obsr Emp #], [Query Form].Observee FROM [Query Form] LEFT JOIN [Name Entry] ON [Query Form].[emp #] = [Name Entry].[Emp #];

execute a .sql query from within VB.Net easily -
Hi all, Is it possible to run a .sql query (from Query Analyzer for example) in VB.Net without too much hassle?? I know people will say, make it a Stored Procedure...but I'm wanting to see about using the .sql query, which is a basic text file I assume? Any suggestions, tips

Display a query result in a textbox -
I know in a combo box you can use the record source to call a table/query and have data displayed in the combo box. What about in a textbox? I have a form which is already referencing a query. Now, I created a query which gets certain equipment records from an account and sums t

Record Count of Query Results - Access98 -
I am running a quick little VB code which simply sends a query out as an Excel document to a list of contacts. However, if the query results contain no records, the attachment is still sent. How can I check the number of records in query to determine whether or not the e-mail shoul

create a prompt in Excel and run a sql server query -
hi, I usually run a query against sql server by going to Get external Data --> run database query. can someone instruct me to how I can embbed a prompt in excel so when someone opens the excel spreadsheet they would get the prompts with paramters that they want to pass to the qu

Interrupt SQL query programatically -
Is it possible to interrupt a query that's taking too long, other than using the CommandTimeOut. I want to user to be able to stop a query that's taking too long, like Query Analyzer, the thing is VB gets stuck until the query returns a result or times out. So does this mean you ne

Building a QUERY in Code -
I'll apologize ahead of time because I know I won't get the terminology correct in this question... This is using Access 2000 I have a query that I need to build in an already existing database, the SQL for this query has 2 seperate JOINS. When I import this query from one datab

QUERY TIMING HELP -
I have a query that takes a bit to process. I want to have a message box pop up if the query has been running for more than 20 seconds that asks if they still want to continue processing. When the message box pops up, if they click yes, the query continues to process. If they cl

Huge IN query -
i've got query that using dynamic query and involved using very huge IN clause (it's for account code) it receive an error that said something like "the queries involved large complex query" any other approach? this query is for Financial Reports that used more than 5

Result of One Query as a Condition to another -
I want to Use the result of a query as the Criteria of Another Query How to do that? Resul of First qry may be like Regno ==== 2 3 4 I want to filter out the Records thrugh Second Query, having the Regno resulted in the first query. I want to implement this using ADO Con

the best way of a connection query -
hi, i working with a sql server 2000 and vb6 and i need a connection/string query to connect from some pc´s in network i have a query but i think that is not the best query because the app freeze for 2segunds when i save/load some data thanks for your help

Urgent Database query prob. !!! -
I am using 4 tables in a query. the result of that query is correct when I checked it directly in Access, but in VB using DAO it is showing only first 2 records instead of all records. e.g. A,B,C,D are the tables and having fields ano, anme, bno, bname, etc. now the query is like this

Can Query be set to run at 6 am everyday -
Hi all, I want to run a query everymorning at 6 AM. Is there any way I can schedule this job or can I use a timer to run the program at a certain time. This query runs for half an hour, so I want to run this before anybody in my department get to work. What all methods can I

Need some help with SQL query -
Hi all, I need some help with SQL query. I want to find a filed whit the Select query by specified word. The column that the filed is in is not a primary key. I have the connection right but I need the right SQL query for it. Thanks in advance.

Read SQL from Access.Query object -
Hello, Is there a way for my to get the SQL code from a Query object inside MS Access? I have created a Query in Access, and now I want to get the SQL code from that Query and perfom some changes etc. How can I get the SQL code from that query via a VBA function? Note: I do not j

Query Results Count in Access98 -
-- Message originally posted in Database Development-- I am running a quick little VB code which simply sends a query out as an Excel document to a list of contacts. However, if the query results contain no records, the attachment is still sent. How can I check the number of record

Can you research a query If so how -
I want to do a search of a ADO query so I guess a query of a query... Can you do this? if so how?

Query performance Best speed -
I want to run a Insert Into query against a access database. Now, I wonder if creating the query in access and the run it from vb with ado and just send parameters to will be faster than using the execute method of an connection object, and just run a sql string with all values in

query problems -
Hi, I am currently working with SQL Server and VB.NET and am in a situation where i need to query another query like you can in access. After a search I discovered that you can not query a dataset. So i was wondering, is there any way that I will be able to do this? Thanks for

Use Access query who use parameters -
I've a urgent problem: In my access app I use VBA. In a module I access a query ("A"). This query is also used in a form and hase a parameter which the user must fill before excecuting the query. Now I have to use that query in VBA, but how do I treat that parameter in

Passing variables to query -
I am trying to create a report that grabs the top 20 records from a table. The table contains data on 6 different machines, so I am assuming that I need to loop six times and pass a variable to the query which indicates the machine id. I have tried creating an integer array that contai

Fully Qualified Query - Resolved -
Guys, I am having a problem with a query. I am trying to select a single field from a table using three tables for the criteria. Here is the query: SELECT w.warehouse from warehouse as w, employee as e, department as d where e.department = 1 and d.warehouse = w.whID I am

Executing Query Analyzer Query File -
Is it possible to execute a Query Analyzer Query File from within VB6? If so, can you show me how? Can the Query Analyzer Query File be converted into a SP? Thanks in advance!!

Long Query -
Hai all, I am trying to use a select statement with ADO recordset. This query has 248 some fields in it. In this way the query length is getting too large, I have tried to use it in query string in the vb code it self, but this was of no use, I also tried with an external file but o

Create an ADO Recordset from Result of more than One Query -
Im using 3 queries (created in Access 97 query builder) to produce the Data I want and need to now populate it to an ADO Recordset in VB . Im thinking: 1) Can I call the Stored Query in the Access 97 Dbase to be my RecordSet? 2) Can I Query a RecordSet against an Access 97 Table