|
by: Betrock |
last post by:
This is probably very simple, but I just can't see my way thru it.....
Short version: keyed values(numeric)in a lookup table are stored in a
main table. They are displayed as text values - the keyed values
description. I need a parameter query to return a range of these
values. The parameter input won't accept the 'text' version. You...
|
by: Tero Partanen |
last post by:
Hi,
I have a small problem with MS ACCESS query.
I want to be able to have a field, where I can input the search
parameter, and then it will show me all the entires that match the
parameter. I have done this already (almost) using "Select Query",
where in the design view I enter the parameter in the "Criteria" field
of the query (under...
|
by: Billie Boy |
last post by:
Hi to all.
I’m new here and am coming to you from Melbourne Australia.
So a big
HELLO 2 ALL.
Thanx for having me here. TOP forum you guy's have here!
Can anyone answer my problem? Please.
I am trying to create a parameter query in the SQL designer of my VB.6
|
by: billmiami2 |
last post by:
I'm experiencing a strange problem that I believe is related to ADO.NET
but I can't say for sure.
I have a simple ASP.NET reporting interface to a SQL Server 2000
database. One report that we run returns a listing of community
members and their contact information using a stored procedure.
Depending on the selected community, this can...
|
by: rosie2006 |
last post by:
Environment: .net2.0 over oracle
Problem? a simple select statement within a DetailsView that gets two parameter values from a GridView SelectedValue.
It might be valuable to understand that to pull a single record from this particular table requires two parameters.
What follows defies understanding.
The desired query:...
|
|
by: wizofaus |
last post by:
I previously posted about a problem where it seemed that changing the
case of the word "BY" in a SELECT query was causing it to run much much
faster.
Now I've hit the same thing again, where basically almost any change I
make to how the query is executed (so that it still performs the same
function) causes the performance to jump from a...
|
by: fhtino |
last post by:
Hello,
I try to explain my problem with a simple example. I have a simple
dataset with only one datatable.
The table is also very simple: ID (pk), Name and Age.
The first query select all the records:
SELECT ID, Name, Age FROM People
The tableadapter has also another query:
|
by: QCLee |
last post by:
Sir can you help me to transfer my Access Query to MS excel? i have a
command button on the form to export the parameter query named
"HVACWindwardQuery" to excel spreadsheet and i got the codes from
searching on the internet and books but the problem is when i run the
command button "Export" it just only open the Blank Spreadsheet, no ...
|
by: nsymiakakis |
last post by:
Hi All, I am have some trouble with a parameter query that I am hoping someone can guide me.
I have a Parameter query with a few fields that people can filter with, Such as "Department", Date Range, Shift... This query is meant to sum the number of "Yes" answers as a percentage from a Y/N field. The query works fine and gives me all the filtered...
|
by: DanicaDear |
last post by:
I have something interesting...looking to see if anyone else has came across this.
I have a query with parameter and and the query works beautifully every time. However, when I use the wizard to build a report, at the end of the wizard the report opens beautifully, asks for the 2 parameters, and displays results. Beautiful. Then, after...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|