Hi, I’ve lurked for a bit and certainly hope you folks can be as much
help to me as you have been to others.
My problem is basically trying to query several results in a single
field (“or” type) but I would like to do so as a parameter so it prompts
me when I open the report.
I am working with MS Access 2000.
Here is my situation.
I am dealing with a database that has 400+ records. It is of accounts
that I have to visit (testing of fire systems) at various times of the year.
Some accounts I test once a year and some monthly with several
variations in between. In addition to keeping the information on each
account up to date and easily sending reports up the chain showing the
progress for the year I also use it to give me a list of accounts coming
up for test the next month.
I have a field called test interval (not visible in any reports) and use
codes such as A03 (annual test in march), S03 (semi-annual starting in
march and again six months later in Sep.) Q03 (quarterly in march, june,
sep and dec)…. You get the idea I also use T## for three times a year,
B(1 or 2) for bi-monthly(every other month) and M for monthly
This way I have been using a basic query and calling up my report each
month. For example, to see the tests I have to do in October I have to
modify my existing query with “test interval” to equal M, A10, S04, Q01,
T02 and B2. Not a huge pain in the butt but it is cumbersome and I have
to go in every month and modify it.
I have recently started using parameters and think it would be
marginally easier to fill out prompts upon opening the report. I tried
a “=[x]” on several lines but it still only prompted me once. I tried
using a ‘getparameter’ statement which I heard of but that did not work
(no claim that I did it right).
Is there a way to get the multiple prompts?
OR
Can I make 12 queries and have the report prompt me for which query to
use when I open it?
OR
Am I going about this like a lunkhead and everyone reading this is
seeing a better way of doing this entire process? I have no problems
adding new fields to my table if it ends up being more efficient.
Thanks for your time.
Joe 6 1992
To figure out the best data structure involves handling all the weird stuff
that happens in the real world, so can I ask a sideways question? What do yo
want to do when an inspection is late? If it is supposed to be inspected
monthly, but no-one gets there for a week (e.g. because of a disaster
elsewhere), is it then due:
a) a month from the last inspection, or
b) in 3 weeks, becuase you need to stay on the original schedule.
If (a), I suggest you use 2 fields rather than your T99 Field:
Freq Number (Long)
PeriodType Text (4 characters)
The PeriodType will be a combo listing of the characters that work in
DateDiff():
"d";"m";"q";"yy yy"
You can therefore determine when the next inspection is due by looking up
the last inspection, and adding the period like this:
DateAdd([PeriodType], [Freq], [LastInspection])
If (b), things are a bit more involved. You need a table of numbers and a
cartesian product which gives you a list of all the dates when the
inspection is acually due, and a way to record which of those was actually
done in any particular inspection.
BTW, looking up the date of last inspection will probably involve a
subquery. If subqueries are new, see:
How to Create and Use Subqueries
at: http://support.microsoft.com/?id=209066
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Joe" <jo*******@char ter.netwrote in message
news:_g******** *****@newsfe02. lga...
Hi, I’ve lurked for a bit and certainly hope you folks can be as much help
to me as you have been to others.
My problem is basically trying to query several results in a single field
(“or” type) but I would like to do so as a parameter so it prompts me when
I open the report.
I am working with MS Access 2000.
Here is my situation.
I am dealing with a database that has 400+ records. It is of accounts
that I have to visit (testing of fire systems) at various times of the
year.
Some accounts I test once a year and some monthly with several variations
in between. In addition to keeping the information on each account up to
date and easily sending reports up the chain showing the progress for the
year I also use it to give me a list of accounts coming up for test the
next month.
I have a field called test interval (not visible in any reports) and use
codes such as A03 (annual test in march), S03 (semi-annual starting in
march and again six months later in Sep.) Q03 (quarterly in march, june,
sep and dec)…. You get the idea I also use T## for three times a year, B(1
or 2) for bi-monthly(every other month) and M for monthly
This way I have been using a basic query and calling up my report each
month. For example, to see the tests I have to do in October I have to
modify my existing query with “test interval” to equal M, A10, S04, Q01,
T02 and B2. Not a huge pain in the butt but it is cumbersome and I have
to go in every month and modify it.
I have recently started using parameters and think it would be marginally
easier to fill out prompts upon opening the report. I tried a “=[x]” on
several lines but it still only prompted me once. I tried using a
‘getparameter’ statement which I heard of but that did not work (no claim
that I did it right).
Is there a way to get the multiple prompts?
OR
Can I make 12 queries and have the report prompt me for which query to use
when I open it?
OR
Am I going about this like a lunkhead and everyone reading this is seeing
a better way of doing this entire process? I have no problems adding new
fields to my table if it ends up being more efficient.
Thanks for your time.
Joe
well, assuming that you are also tracking the date when each test is
completed (in addition to when each test is due), i would probably have a
table of intervals, as
tblIntervals
intID (primary key)
intCode (one record each for A03, S03, Q03, etc)
intMonths (number of months for each interval; for instance, for A03 the
value would be 12, for S03 the value would be 6, etc.)
add a field to the Accounts table, to store the interval for each account.
the field will be a foreign key from tblIntervals.
now, i'll assume that you have a separate table (linked to the Accounts
table) to record each test visit for each account, including the date the
test is completed for that visit. create a query based on the AccountTests
table, the Accounts table, and tblIntervals. pull into the query grid the
test date from the AccountTests table, the interval field from the Accounts
table, and the intMonths field from tblIntervals. create a calculated field
in the query to add the number of interval months to the test date, as
NextTestDate: Format(DateAdd( "m", tblIntervals.in tMonth,
AccountTests.Te stDate), "mmyy")
the above expression goes all on one line in the query, regardless of
line-wrap here. next, add criteria to the calculated query field to pull
only the records where the date is next month, as
Format(DateAdd( "m", 1, Date()), "mmyy")
actually, i would make the query more dynamic by using a reference to a
control on a form, as the criteria. that way you can choose what future
month of tests you want to see, without having to change the query at all.
one way to do that is to add two textbox controls to a form, i'll call them
txtMonths and txtMonthYear. make txtMonthYear invisible, and set its'
ControlSource to
=Format(DateAdd ("m",[txtMonths],Date()),"mmyy" )
txtMonths should be visible, that's where you'll type the number of months
you want add to the current month. this is February, so to see tests due in
March, type a 1; to see tests due in April, type a 2, etc.
in the query, change the criteria from what i posted above, to a simple
control reference, as
[Forms]![MyForm]![txtMonthYear]
note that the form will have to be open when you run the query (or the
report bound to the query).
hth
"Joe" <jo*******@char ter.netwrote in message
news:_g******** *****@newsfe02. lga...
Hi, I’ve lurked for a bit and certainly hope you folks can be as much
help to me as you have been to others.
My problem is basically trying to query several results in a single
field (“or” type) but I would like to do so as a parameter so it prompts
me when I open the report.
I am working with MS Access 2000.
Here is my situation.
I am dealing with a database that has 400+ records. It is of accounts
that I have to visit (testing of fire systems) at various times of the
year.
>
Some accounts I test once a year and some monthly with several
variations in between. In addition to keeping the information on each
account up to date and easily sending reports up the chain showing the
progress for the year I also use it to give me a list of accounts coming
up for test the next month.
I have a field called test interval (not visible in any reports) and use
codes such as A03 (annual test in march), S03 (semi-annual starting in
march and again six months later in Sep.) Q03 (quarterly in march, june,
sep and dec)…. You get the idea I also use T## for three times a year,
B(1 or 2) for bi-monthly(every other month) and M for monthly
This way I have been using a basic query and calling up my report each
month. For example, to see the tests I have to do in October I have to
modify my existing query with “test interval” to equal M, A10, S04, Q01,
T02 and B2. Not a huge pain in the butt but it is cumbersome and I have
to go in every month and modify it.
I have recently started using parameters and think it would be
marginally easier to fill out prompts upon opening the report. I tried
a “=[x]” on several lines but it still only prompted me once. I tried
using a ‘getparameter’ statement which I heard of but that did not work
(no claim that I did it right).
Is there a way to get the multiple prompts?
OR
Can I make 12 queries and have the report prompt me for which query to
use when I open it?
OR
Am I going about this like a lunkhead and everyone reading this is
seeing a better way of doing this entire process? I have no problems
adding new fields to my table if it ends up being more efficient.
Thanks for your time.
Joe
On Feb 25, 6:50 pm, Joe <joerai...@char ter.netwrote:
Hi, I've lurked for a bit and certainly hope you folks can be as much
help to me as you have been to others.
My problem is basically trying to query several results in a single
field ("or" type) but I would like to do so as a parameter so it prompts
me when I open the report.
I am working with MS Access 2000.
Here is my situation.
I am dealing with a database that has 400+ records. It is of accounts
that I have to visit (testing of fire systems) at various times of the year.
Some accounts I test once a year and some monthly with several
variations in between. In addition to keeping the information on each
account up to date and easily sending reports up the chain showing the
progress for the year I also use it to give me a list of accounts coming
up for test the next month.
I have a field called test interval (not visible in any reports) and use
codes such as A03 (annual test in march), S03 (semi-annual starting in
march and again six months later in Sep.) Q03 (quarterly in march, june,
sep and dec).... You get the idea I also use T## for three times a year,
B(1 or 2) for bi-monthly(every other month) and M for monthly
This way I have been using a basic query and calling up my report each
month. For example, to see the tests I have to do in October I have to
modify my existing query with "test interval" to equal M, A10, S04, Q01,
T02 and B2. Not a huge pain in the butt but it is cumbersome and I have
to go in every month and modify it.
I have recently started using parameters and think it would be
marginally easier to fill out prompts upon opening the report. I tried
a "=[x]" on several lines but it still only prompted me once. I tried
using a 'getparameter' statement which I heard of but that did not work
(no claim that I did it right).
Is there a way to get the multiple prompts?
OR
Can I make 12 queries and have the report prompt me for which query to
use when I open it?
OR
Am I going about this like a lunkhead and everyone reading this is
seeing a better way of doing this entire process? I have no problems
adding new fields to my table if it ends up being more efficient.
Thanks for your time.
Joe
OTTOMH (while DSAPWWMITMOTN) perhaps you could make a table of months
and a table that linked codes to the tables of months. M, A10, S04,
Q01,
T02 and B2 would all map to October. B2 would link to Feb, Apr etc. M
would link to all months. So a query using a join could take a single
parameter, October, and return all the accounts requiring an
inspection for that month.
Is doing a fire inspection challenging?
If not then, IMO, those up the chain are wasting a resource (you).
DSAPWWMITMOTN = dog sitting a pup who woke me in the middle of the
night
Lyle Fairfield wrote:
On Feb 25, 6:50 pm, Joe <joerai...@char ter.netwrote:
>Hi, I've lurked for a bit and certainly hope you folks can be as much help to me as you have been to others.
My problem is basically trying to query several results in a single field ("or" type) but I would like to do so as a parameter so it prompts me when I open the report.
I am working with MS Access 2000.
Here is my situation.
I am dealing with a database that has 400+ records. It is of accounts that I have to visit (testing of fire systems) at various times of the year.
Some accounts I test once a year and some monthly with several variations in between. In addition to keeping the information on each account up to date and easily sending reports up the chain showing the progress for the year I also use it to give me a list of accounts coming up for test the next month.
I have a field called test interval (not visible in any reports) and use codes such as A03 (annual test in march), S03 (semi-annual starting in march and again six months later in Sep.) Q03 (quarterly in march, june, sep and dec).... You get the idea I also use T## for three times a year, B(1 or 2) for bi-monthly(every other month) and M for monthly
This way I have been using a basic query and calling up my report each month. For example, to see the tests I have to do in October I have to modify my existing query with "test interval" to equal M, A10, S04, Q01, T02 and B2. Not a huge pain in the butt but it is cumbersome and I have to go in every month and modify it.
I have recently started using parameters and think it would be marginally easier to fill out prompts upon opening the report. I tried a "=[x]" on several lines but it still only prompted me once. I tried using a 'getparameter' statement which I heard of but that did not work (no claim that I did it right).
Is there a way to get the multiple prompts?
OR Can I make 12 queries and have the report prompt me for which query to use when I open it?
OR Am I going about this like a lunkhead and everyone reading this is seeing a better way of doing this entire process? I have no problems adding new fields to my table if it ends up being more efficient.
Thanks for your time.
Joe
OTTOMH (while DSAPWWMITMOTN) perhaps you could make a table of months
and a table that linked codes to the tables of months. M, A10, S04,
Q01,
T02 and B2 would all map to October. B2 would link to Feb, Apr etc. M
would link to all months. So a query using a join could take a single
parameter, October, and return all the accounts requiring an
inspection for that month.
Is doing a fire inspection challenging?
If not then, IMO, those up the chain are wasting a resource (you).
DSAPWWMITMOTN = dog sitting a pup who woke me in the middle of the
night
I work for an alarm company, and no, fire Inspections are not all that
challenging. I used to work in the installation department. Most fire
inspectors just test the systems. They are trying something different
with me - I test also, but if anything doesn't work I fix it on the spot
rather than report it for someone else to fix later. I have also
spotted quite a few problems with systems that the other testers never
noticed because they didn't have the depth of experience that a former
installer has. I also test/repair Burglar Alarms, card access systems
and Camera systems. The other testers work on one type of system.
The most challenging part is trying to convince the guy running the
department to use computers. He doesn't like them (and he's younger
than me - I'm 45). Maybe, If I can show this database saves time...
Thanks for your idea, that sounds like the simplest solution yet. Some
of the other ideas sound good, but are a bit more complicated than I
feel comfortable with. I am saving them for possible future use.
Thanks to everyone for your time and ideas.
Joe
On Feb 26, 7:33 pm, Joe <joerai...@char ter.netwrote:
Lyle Fairfield wrote:
On Feb 25, 6:50 pm, Joe <joerai...@char ter.netwrote:
Hi, I've lurked for a bit and certainly hope you folks can be as much
help to me as you have been to others.
My problem is basically trying to query several results in a single
field ("or" type) but I would like to do so as a parameter so it prompts
me when I open the report.
I am working with MS Access 2000.
Here is my situation.
I am dealing with a database that has 400+ records. It is of accounts
that I have to visit (testing of fire systems) at various times of the year.
Some accounts I test once a year and some monthly with several
variations in between. In addition to keeping the information on each
account up to date and easily sending reports up the chain showing the
progress for the year I also use it to give me a list of accounts coming
up for test the next month.
I have a field called test interval (not visible in any reports) and use
codes such as A03 (annual test in march), S03 (semi-annual starting in
march and again six months later in Sep.) Q03 (quarterly in march, june,
sep and dec).... You get the idea I also use T## for three times a year,
B(1 or 2) for bi-monthly(every other month) and M for monthly
This way I have been using a basic query and calling up my report each
month. For example, to see the tests I have to do in October I have to
modify my existing query with "test interval" to equal M, A10, S04, Q01,
T02 and B2. Not a huge pain in the butt but it is cumbersome and I have
to go in every month and modify it.
I have recently started using parameters and think it would be
marginally easier to fill out prompts upon opening the report. I tried
a "=[x]" on several lines but it still only prompted me once. I tried
using a 'getparameter' statement which I heard of but that did not work
(no claim that I did it right).
Is there a way to get the multiple prompts?
OR
Can I make 12 queries and have the report prompt me for which query to
use when I open it?
OR
Am I going about this like a lunkhead and everyone reading this is
seeing a better way of doing this entire process? I have no problems
adding new fields to my table if it ends up being more efficient.
Thanks for your time.
Joe
OTTOMH (while DSAPWWMITMOTN) perhaps you could make a table of months
and a table that linked codes to the tables of months. M, A10, S04,
Q01,
T02 and B2 would all map to October. B2 would link to Feb, Apr etc. M
would link to all months. So a query using a join could take a single
parameter, October, and return all the accounts requiring an
inspection for that month.
Is doing a fire inspection challenging?
If not then, IMO, those up the chain are wasting a resource (you).
DSAPWWMITMOTN = dog sitting a pup who woke me in the middle of the
night
I work for an alarm company, and no, fire Inspections are not all that
challenging. I used to work in the installation department. Most fire
inspectors just test the systems. They are trying something different
with me - I test also, but if anything doesn't work I fix it on the spot
rather than report it for someone else to fix later. I have also
spotted quite a few problems with systems that the other testers never
noticed because they didn't have the depth of experience that a former
installer has. I also test/repair Burglar Alarms, card access systems
and Camera systems. The other testers work on one type of system.
The most challenging part is trying to convince the guy running the
department to use computers. He doesn't like them (and he's younger
than me - I'm 45). Maybe, If I can show this database saves time...
Thanks for your idea, that sounds like the simplest solution yet. Some
of the other ideas sound good, but are a bit more complicated than I
feel comfortable with. I am saving them for possible future use.
Thanks to everyone for your time and ideas.
Joe- Hide quoted text -
- Show quoted text -
There are many developers, programmers, database administrators who
post here, who seem misplaced. They cannot express their ideas. Their
understanding of their subject is minimal. They're lazy. They have no
sense of logic. And not a few are just plain stupid. Sometimes they
mention their "clients" and I shudder.
I'm happy that someone who seems capable is testing fire alarms. I'm
sure it's a worthwhile occupation and it's a job that needs doing
well. Probably you're happy in your work. But you could venture into
this computer world. Many of us did so when we were your age. Mind
you, this happened just when personal computers became common, so you
it was a special opportunity for our generation.
Years ago I showed a secretary how to write a function in Excel. She
was hooked. She took some classes. She got a certificate. She worked
for People Soft. She left them and worked for an insurance company.
Her salary got to be double mine. Now she free lances. She's happy,
challenged, respected and well off. She was about forty when she
began.
Probably you're completely happy in what you're doing. But you could
think about what I said.
Lyle Fairfield wrote:
On Feb 26, 7:33 pm, Joe <joerai...@char ter.netwrote:
>Lyle Fairfield wrote:
>>On Feb 25, 6:50 pm, Joe <joerai...@char ter.netwrote: Hi, I've lurked for a bit and certainly hope you folks can be as much help to me as you have been to others. My problem is basically trying to query several results in a single field ("or" type) but I would like to do so as a parameter so it prompts me when I open the report. I am working with MS Access 2000. Here is my situation. I am dealing with a database that has 400+ records. It is of accounts that I have to visit (testing of fire systems) at various times of the year. Some accounts I test once a year and some monthly with several variations in between. In addition to keeping the information on each account up to date and easily sending reports up the chain showing the progress for the year I also use it to give me a list of accounts coming up for test the next month. I have a field called test interval (not visible in any reports) and use codes such as A03 (annual test in march), S03 (semi-annual starting in march and again six months later in Sep.) Q03 (quarterly in march, june, sep and dec).... You get the idea I also use T## for three times a year, B(1 or 2) for bi-monthly(every other month) and M for monthly This way I have been using a basic query and calling up my report each month. For example, to see the tests I have to do in October I have to modify my existing query with "test interval" to equal M, A10, S04, Q01, T02 and B2. Not a huge pain in the butt but it is cumbersome and I have to go in every month and modify it. I have recently started using parameters and think it would be marginally easier to fill out prompts upon opening the report. I tried a "=[x]" on several lines but it still only prompted me once. I tried using a 'getparameter' statement which I heard of but that did not work (no claim that I did it right). Is there a way to get the multiple prompts? OR Can I make 12 queries and have the report prompt me for which query to use when I open it? OR Am I going about this like a lunkhead and everyone reading this is seeing a better way of doing this entire process? I have no problems adding new fields to my table if it ends up being more efficient. Thanks for your time. Joe OTTOMH (while DSAPWWMITMOTN) perhaps you could make a table of months and a table that linked codes to the tables of months. M, A10, S04, Q01, T02 and B2 would all map to October. B2 would link to Feb, Apr etc. M would link to all months. So a query using a join could take a single parameter, October, and return all the accounts requiring an inspection for that month. Is doing a fire inspection challenging? If not then, IMO, those up the chain are wasting a resource (you). DSAPWWMITMO TN = dog sitting a pup who woke me in the middle of the night
I work for an alarm company, and no, fire Inspections are not all that challenging. I used to work in the installation department. Most fire inspectors just test the systems. They are trying something different with me - I test also, but if anything doesn't work I fix it on the spot rather than report it for someone else to fix later. I have also spotted quite a few problems with systems that the other testers never noticed because they didn't have the depth of experience that a former installer has. I also test/repair Burglar Alarms, card access systems and Camera systems. The other testers work on one type of system.
The most challenging part is trying to convince the guy running the department to use computers. He doesn't like them (and he's younger than me - I'm 45). Maybe, If I can show this database saves time...
Thanks for your idea, that sounds like the simplest solution yet. Some of the other ideas sound good, but are a bit more complicated than I feel comfortable with. I am saving them for possible future use.
Thanks to everyone for your time and ideas.
Joe- Hide quoted text -
- Show quoted text -
There are many developers, programmers, database administrators who
post here, who seem misplaced. They cannot express their ideas. Their
understanding of their subject is minimal. They're lazy. They have no
sense of logic. And not a few are just plain stupid. Sometimes they
mention their "clients" and I shudder.
I'm happy that someone who seems capable is testing fire alarms. I'm
sure it's a worthwhile occupation and it's a job that needs doing
well. Probably you're happy in your work. But you could venture into
this computer world. Many of us did so when we were your age. Mind
you, this happened just when personal computers became common, so you
it was a special opportunity for our generation.
Years ago I showed a secretary how to write a function in Excel. She
was hooked. She took some classes. She got a certificate. She worked
for People Soft. She left them and worked for an insurance company.
Her salary got to be double mine. Now she free lances. She's happy,
challenged, respected and well off. She was about forty when she
began.
Probably you're completely happy in what you're doing. But you could
think about what I said.
Thanks for the encouragement but for now I think I'll stay put. I made
the move into inspecting fire alarms instead of installing them after my
oldest son (18) was killed in an early morning house fire. The house he
was in did not have working smoke detectors - so its a bit personal.
As far as computers go, I like to play around and use the different
programs in the manner the programmers intended by taking advantage of
all the bells and whistles.
I have had the opportunity a few times in the past to make this sort of
thing my primary job (in the military) but that has always taken the fun
out of it. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: ahokdac-sql |
last post by:
Hi,
I'm adapting access queries to sql server and I have difficulties with
the following pattern :
query1 : SELECT * FROM Query2 WHERE A=@param1
query 2: SELECT * FROM Table2 WHERE B=@param2
The queries are nested, and they both use parameters.
In MS Acccess the management of nested queries with parameters is so
easy (implicit declaration of parameters, transmission of parameters
from main query to nested query)
|
by: Roger Green |
last post by:
I have inherited a complex database that has many dozens of queries that derive data from a people
table.
I now need to be able to run these queries (from within a significant number of forms) not on the
full dataset, but on a subset of the data in the people table.
I want to avoid having to put criteria in all of the individual queries or forms, or having to
change the data source for all the queries.
Is there anyway I can restrict...
|
by: Dom Boyce |
last post by:
Hi
First up, I am using MS Access 2002.
I have a database which records analyst rating changes for a list of
companies on a daily basis. Unfortunately, the database has been set
up (by my predecessor, I hasten to add) so that each day it creates a
copy of the record for each company, changes the date to today's date,
and prompts the user for any changes of ratings on that day. The
resulting data table grows by approx 600 records per...
|
by: Zlatko Matić |
last post by:
Let's assume that we have a database on some SQL server (let it be MS SQL
Server) and that we want to execute some parameterized query as a
pass.through query. How can we pass parameters to the server ?
Is it possible to use parameters in pass-through queries ?
An additional question: Is it possible to connect to a database on MySQL or
PostgreSQL using ADO ?
Is it possible to execute pass-through queries with parameters, using ADO...
|
by: Zlatko Matić |
last post by:
Hi everybody!
Recently I was struggling with client/server issues in MS Access/PostgreSQL
combination.
Although Access is intuitive and easy to use desktop database solution, many
problems appear when someone is trying to use it as front-end for real
server database systems such as PostgreSQL or MySQL.
One of these problems is regarding pass-through queries and parameters.
I wanted to have all the code on client, while executing it on...
| |
by: deko |
last post by:
Is it possible to build a parameterized query from another parameterized
query?
I've tried two variations of this and can't seem to get it to work (using
DAO). Any suggestions welcome!
I want to delete linked documents - but only if they are not
linked to other entities outside of the category being deleted
|
by: Dirk Vervecken |
last post by:
Hi i've got an application in dotnet that uses
queries from an Access database.
Now most of the common select statements return the desired data,
however, one the queries requires a parameter.
This particular queries does not return the correct data.
I've tested the query in access and it works.
Somehow the parameter that I pass from asp.net does not seem
to be arriving.
This is a sample query of how it looks:
|
by: Roy |
last post by:
Hey all,
Here's a small VB codeblock that connects to a database and uses 2 SQL
queries then forms a relation for a master/detail view on the aspx side:
Private Sub Binddata(ByVal name As String)
Dim myconn As New
SqlConnection("server=localhost;uid=ser;pwd=none;database=et")
Dim mycom As New SqlCommand("select * from tbl1;select * from tbl2",
|
by: =?Utf-8?B?Sm9uIEphY29icw==?= |
last post by:
For MS SQL Server...
I am used to declaring local variables in my SQL queries...
Declare @MyInt int, @MyChar varchar(33)
Parameters were idenfitied with a colon...
Where ModDate :MyDate
But, now that I am stwitching to .NET, the parameters are identified with @
in SqlCommand, so how do I declare local variables in my queries (like in
Query Analyzer)?
|
by: MMcCarthy |
last post by:
Rather than using the Access design view change the view to SQL. I am going to attempt to outline the general syntax used for SQL queries in Access.
Angle brackets <> are used in place of some syntax elements you must supply. The description of these elements will be in the contained in the angle brackets.
Square brackets are used to show which parts are optional.
Basic SELECT query
SELECT <field list>
FROM <table/query name(s)>
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |