[2005] Limiting Search Based On User Access -
Hello,
Firstly, my Database is setup with several teams, each team having several employees.
Secondly, when users log into my app, they only have access to certain teams.
So I may have access to A, B and C whereas my colleague will only have access to A and B.
Thirdly, based on the above I have a form which finds employees based on the text I type in a find box.
This all works fine, as if I type 'jon' into the textbox, it brings all records from tbl_PersonalDetails table into a dataset, searches it, and finds anyone with the name jon, jonny, jonathan etc.
However if my colleague does this search, he will get the same results as me, even though he doesn't have access to the same teams as me.
What I ideally want is for his search to show everyone (as mine does), but have those in a team which he doesn't have access to, greyed out.
How would I go about doing this please ?
Thanks,
[2005] Limiting Search Based On User Access -
Hello,
Firstly, my Database is setup with several teams, each team having several employees.
Secondly, when users log into my app, they only have access to certain teams.
So I may have access to A, B and C whereas my colleague will only have access to A and B.
Thirdly, based
convert pc based app to web based app -
Hi all -
I have written a very small app in VB.net ( visual studio 2005 ) that will open and read an excel spreadsheet, grab each value in a column of cells, and one-by-one, use those values to populate the 'search' box of a web page. Press the submit button, do a search. Press the
Access limiting rows viewed from SQL Server -
This might be simple, but I've searched for a solution and haven't found a reason why access is limiting the rows viewed from SQL Server to 10,000.
Scenario:
I've set up an .adp in Access linked to SQL Server 2000 Dev. Edition on my computer.
I've been importing rather large CS
rippled query -
i don't know what to do - and this time i'm stumped!
i have a search form which i coded in access that alters 2 queries (ChildQuery and ParentQuery, which are responsible for a MainReport and a SubReport, respectively)
I have a “item” table and a “Quotes” table, and there
[Access] Search with multiple parameters -
I'm building a contacts database, and I want users to be able to search for contacts based on the contacts' last name, first name, company, and company type, so that if a user only knows one of these parameters, the search still yields results. I want the search to display all records
Search Engines and Databases... -
Well... first, I want to create a form which will submit data to a database. I was going to email me the people who register to use my software, but that could get annoying.
I don't have access to CGI... but I do have ASP. I'm hosted at Brinkster... maybe they do allow for CGI...
[2005] new form instance -
Is there somewhere to generate a new "instance" of a form? For example:
-I have a database search program.
-The user clicks on the search button in the main form, a new form pops up with search controls/datagrid/other search refining buttons.
-The user can then choose to m
[2005] Controlling Access to files -
I am migrating a WinForms program I have to a WebForms platform. The essence of the functionality is that I have a search form and a search results (in a GridView). When a user selects a row in the GridView, an associated PDF file will load in their browser. How do I prevent an unautho
What event is equivalen to the "After Update" even in Access -
Hi, I have a user log on screen on my appl. Now, I ask the user to click the "Log on" button or "Search" button to allow me to proceed to log on the user or perform the search.
I'd like to save user a click. As soon as the user presses the <Enter> key on
---Solved---How to keep data on textbox search after call same page -
I have a form that display all records at beginning from SQL databse and textbox search. When user enters search item, it should return records based on search criteria only. I used ASP (request.form) to get search data and call back the same page but my question is the data in textbox
Limiting forms -
Hey guys,
I am having trouble with limiting the number of times a form can be opened... I have two forms in my project and to open the second one, the user clicks on the file menu and hits Buy Units. After that a form with all the units they can buy opens. I want only one instance
[2005] timing out -
ok i have a search form that looks and works exactly like that of it's windows based search form. runs the same sql code. however if i search for something that might return 10's of thousands or more records in the window style form takes a little but it works... now if i do it in th
ASP.Net/VB.Net - ASP .Net Search Engine using Access Database -
First, I hope this is ok since I didn't see anything on posting code on planetsourcecode... if not let me know what I should do, as the code is too large to be placed in here...
This is code/sample application I created and placed on planetsourcecode. It's completely free, but I wo
Quickie: Can I access MS SQL server through DAO -
Hi!
I just wanted to ask is it possible to access MS SQL server through DAO (ie VB5). I know it can access ODBC but they never talk about how to access MS SQL. Also, can it be done through a data control? I know it's kind of limiting, but it's part of my program's architecture already
Searching through access database.. -
I am trying to create a search button to search through an access 2000 database using Visual basic 6.0. i dont know how to code the search button so that it can go through a database and search all the text fields and everything to look for matches of the search word entered. the user
Search Functionality -
Hi all,
I have a query relating to search on a website.
I have a site for which I want to add a search box; whereby which users can search for people based on the following criteria: Name/Pin/Keyword
I'm wondering where to start with this and by that I mean do I need to create
Advanced Search - I have a problem with the "Some of the words are too common..." [R] -
I have a problem with it in the sense that I dont like it.
A word that is critical for my search is getting excluded because it is too common (what decides that a certain word is common or not anyway?). The word is 'outside'. Is there a way to override this search characteristic?
If
Security on the Web Service -
Hi to all,
I would like to ask if there is a best documentation about security on web service.
Like for example about Recognizing the user of the No-touch-deployment client and
Limiting to access the methods of Web-Service base on the user.
Any help from you would be grea
[2008] Access Database Help -
Hello,
I am learning VB and have been watching training videos and going through exercises and I am now trying to make a simple application.
The application will search an access database for an ID number from a text box and if it finds a matching record it will display that reco
Searching for files based on multiple criteria [ALMOST RESOLVED] -
Is there a way to search for files based on modified/accessed date, etc? It would be nice to imitate what Windows search can do (i.e. search for "a*c.*cs*")
How to search for records in VB 2005 express(Noob) -
I have a local access database that I'm connecting to with vb 2005 (using the data source wizards)
I want to be able to search the records
Can anyone show me how to do this?
Engine Limiting... -
Hi All, im hoping someone can help me with a really silly question.
My Partner wants a car, only a 1.4 focus, but diesel. I know that the diesels start at 1.6, can you actually reallistically restrict a 1.6 engine to the output of a 1.4 or is it just a case of limiting the power?
Page Security -
I have an issue with our company website. In order to get into the site, the user has to login. When the user logs in successfully, they are able to access certain web pages based on their access.
On a specific page the user is allowed to view a report based on the criteria they ent
No ASP.NET user -
I have a very serious problem and not even my instructor can solve it.
In SQL Server Management Studio Express, when we go to the SECURITY folder to create a new loggin, we then have a search button. I click it and then hit the advanced button and then hit the FIND NOW button. When
Emergency Help, Please ! -
Hi, everyone,
I got some problems when I was packing my app. by using' Package and Deployment Tool', I made my app. by using
Access 2K and Ref. Ms Activex Data Object 2.5 Lib at window2k.
1). I installed and run my app. at windows2K, everything was fine, but whe I do it at wi
Emergency Help Needed ! -
Hi, everyone,
I got some problems when I was packing my app. by using' Package and Deployment Tool', I made my app. by using
Access 2K and Ref. Ms Activex Data Object 2.5 Lib at window2k.
1). I installed and run my app. at windows2K, everything was fine, but whe I do it at win9
Access Report Question [ RESOLVED ] -
Hey all, iv created an invoice system for my employer and it works perfectly. There is one thing I need to know though, I want 3 textbox's to be based on a completely different query then what the reports record source is. Is there a way to to do? I'v tried integrating the values for t
multi search screen... -
i am designing a database at the moment, and one of the things which would be excellent is a screen that shows all the fields of a certain table and the user types the criteria they want to search for in each field, if they don't have search criteria for a certain field they just leave
Limiting Certain Characters. *resolved* -
How would one go about limiting certain characters into a text field?
I.E. My save files names need to NOT have these:
\ / | : ? < > " *
I need to EXCLUDE these characters from being sent into the text box.
Any help is appreciated, thank you!
multiuser internet -
Hi
My previous ISP had a custom dial-up app which I zipped with a pwd to control internet access. My new ISP uses Win2k's standard DUN app. How do I go about limiting access to users with username& pwd supplied by me? I work in a high security environment so internet access is li
WEB-BASED MP3 search... -
Anybody know of a WEB-BASED (i.e., NOT Napster, Gnutella, etc.) MP3 search engine?
Will these forms transfer data to main form -
Im creating a db application...frmMain contains all the records.
But I have also created about 5 different forms to search for records:
frmSearchByTrackingID 'searches record based on the records ID.
frmSearchByName 'text search on a field
frmSearchByShortDescription
[2005] Windows or forms authentication -
I want to develop an application for intranet. I have set my authentication to windows. And i want to create roles (like admin/normal user) and assign them to certain persons/domain groups. Can i do this in win authetication or i have to use forms authentication.
All these things t
MS Access 97 & user access -
Hi. i have 2 ms access files. 1 contains the data tables and the other one contains tables links, forms, macros, queries and the code. How could i implement a user access so that is a user or group of users have full access and the other user or group of users can only search and view.
Limiting User Input for InputBoxes -
Does anyone know of any code that limits the amount of characters that can be entered by the user into an inputbox?
Easiest way to search access database -
Hey, I need some help with this. Here's what I'm trying to do. I have a table in an access database called "Poolpass". This table has the following columns: "Lastname", "FirstName", etc.
This what I want to do:
User selects what they want to sea
how to access controls from another thread -
How to access controls from another thread?
I have a listview in main form which has the data. I'm using another thread to compute based on these data. Based on computation result, I need update the listview, such as backcolor, checked, ...
I'm using VS 2005 Express. It pops exce
Year and Month and data search -
Hello Everyone! Im new in VB-Access development and I have a project in school about database programming. The program should compute and display the total number of years and month based on the system date, it should be displayed in a textbox. Here's an example:
Let say the system
My VB Project -
Okay here is what I'm trying to do:
I have set up a VB form that should allow the user to open up an Excel document they choose from the form. Then in the VB form the user will specify a column of the Excel sheet they want to search, the row they want to start the search at, and th
[2005] Date Range Search -
I've written a program that uses a search form to create a dynamic SQL statement that is then run against a SQL database, generating search results. Sometimes, our clients want to put dates into the index fields, and would also like to be able to search for records based upon said date