Hello all.. I'm working on an application that has a worklist of items for
users to work on. I'd like to, based on user security, to filter a worklist
based on between 1 and 8 items (i.e., location, category, alpha split).
That first part is no problem.. the problem is.. how to then allow that user
that is (for example) restricted to work 3 locations, to then further filter
that worklist to just one location?
Yes.. I can use the ADO filter.. but.. that won't work if you extend the
filter beyond one element (i.e., location and category).
Suggestions?
TIA
3  4739 
You have two ways to filter: Server and Client.
In the Server methodology, you would firther filter by taking another trip
to the server and issuing the proper SQL command. You can also use tricks,
like ADO filters, et al. (NOTE: .NET allows for multiple filters on a single
DataView, or the creation of different views for different purposes).
In the Client, you have to loop through data to reduce it. JavaScript arrays
created by your recordset are the most common. Realize, this is heavy
programming, can tax the browser and leads to rather weighty pages.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** ***
Think Outside the Box!
*************** *************** *************** ***
"Bryan Harrington" <ne**@psacake.c om> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Hello all.. I'm working on an application that has a worklist of items for
users to work on. I'd like to, based on user security, to filter a
worklist based on between 1 and 8 items (i.e., location, category, alpha split).
That first part is no problem.. the problem is.. how to then allow that
user that is (for example) restricted to work 3 locations, to then further
filter that worklist to just one location?
Yes.. I can use the ADO filter.. but.. that won't work if you extend the
filter beyond one element (i.e., location and category).
Suggestions?
TIA
Bryan Harrington wrote: Hello all.. I'm working on an application that has a worklist of
items for users to work on. I'd like to, based on user security, to
filter a worklist based on between 1 and 8 items (i.e., location,
category, alpha split).
That first part is no problem.. the problem is.. how to then allow
that user that is (for example) restricted to work 3 locations, to
then further filter that worklist to just one location?
Yes.. I can use the ADO filter.. but.. that won't work if you extend
the filter beyond one element (i.e., location and category).
Yes it will. It's only Find that's restricted to a single Field.
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: shank |
last post by:
I have a recordset that contains multiple records of product a user is
purchasing. For clarity, I converted the recordset fields to variables. I
need to take that entire recordset and insert it into another table on a
remote server. The below code only inserts 1 record. How do I change the
code to get all records inserted?
thanks!
<%
Dim DataConn2
Set DataConn2 = Server.CreateObject("ADODB.Connection")
|
by: tremor |
last post by:
I'd like to print a form based on the filters currently applied to it
(these are again based on selections in combo-boxes). The form has
multiple subforms, and as I try to print it, it prints all records in
each of these, not just the ones i have showing based on the filters
set. These filters are set in the VB code, as child/master
dependencies wouldn't cut it in this case.
I'm sort of pressed on time here, so I really don't want to...
|
by: Katrina |
last post by:
I am trying to write a piece of code that will search through a number
of different tables (current one being tableNm) to look for a specific
street name that has been entered by the user and saved as
Enteredstreet. If the street is found I then want to display a message
box saying what table the street name is in. The code I am currently
trying to use is this:
Sub dbOpentableX()
Dim dbsAddSampling As Database
|
by: MP |
last post by:
Hi
trying to begin to learn database using vb6, ado/adox, mdb format, sql
(not using access...just mdb format via ado)
i need to group the values of multiple fields
- get their possible variations(combination of fields),
- then act on each group in some way ...eg ProcessRs (oRs as RecordSet)...
the following query will get me the distinct groups
|
by: Thall |
last post by:
Hey Gurus - I've seen a few solutions to this problem, but none of which I can do without a little help. Here's the situation
The following code loops thru a sales report, using the sales rep ID as a filter so that multiple reports are created. This is now generating a PDF report, but I need to change it to RTF documents.
My question is, since I can't create an RTF using open report, is there a way to use the strFilter with the OutputTo...
| | |
by: brino |
last post by:
hi all !
my client wants to bring out data into a report with a number of
filters that are chosen by the user .
eg. -Section
-Days to search
-Type of care
ive never tried this before so im not sure how to go about it.
the tricky part is that there are a number of options to choose in each
|
by: Memphis Steve |
last post by:
Is it possible to combine multiple javascipts into one file and then call that file from a linked URL in the head section of an XHTML file?
Here are the two scripts I want to use with the instructions on where to normally place them in an XHTML document:
SCRIPT #1:
Step 1: Insert the below anywhere into the <body> section of your page where you wish the clock to be displayed:<script>
/*
Live Date Script-
|
by: Dooza |
last post by:
Hi there,
I have a Stored Procedure in SQL 2000 that takes 10 input paremeters,
and outputs 11 recordsets, not rows, but 11 different SELECT statements.
The purpose of this is to for a menu system in a store. If all the
inputs are NULL, then just the top level categories are output in the
first recordset. The ID of each category will then be passed back into
the stored procedure where it then filters the second recordset to
create the...
|
by: mayurshah28 |
last post by:
Hi everyone,
im developing one application for banking. there i have stucked wit one prob.
now prob is tat im not able to access multiple tables at a time through vb.
my coding is as below
Dim rs_cust As Recordset
Dim cn_cust As Connection
Dim rs_acco As Recordset
Dim cn_acco As Connection
Dim rs_tran As Recordset
|
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: 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: 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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: 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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
