I take it that the NTUser name is a table somewhere that you are comparing
against. Then yes... I can see it working.
Eric
--------------------
| Content-Class: urn:content-classes:message
| From: "Carlos" <
[email protected]>
| Sender: "Carlos" <
[email protected]>
| References: <
[email protected]>
<
[email protected]>
| Subject: RE: Filtering a View based on data from a form?
| Date: Tue, 3 Feb 2004 11:22:10 -0800
| Lines: 89
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcPqiwU65Q0SRx+BTryh7X2zl+Z1sA==
| Newsgroups: microsoft.public.access.adp.sqlserver
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.adp.sqlserver:16272
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.adp.sqlserver
|
| Hi prabha,
|
| Thank you very much, I am now going to attempt the
| outlined procedure. Can you indicate to me if it will
| work in the following scenario: I am retrieving the name
| of the NT user using api programming (courtesy Dev Ashish)
| and want to filter all account numbers (acct code) in a
| budget management program that the user has access to.
| Table structure is UserFile (userid, dept code)-->
| DeptFile (dept code, acct code) --> BudgetFile (acct code).
|
| Thanks in advance
| >-----Original Message-----
| >Hi Carlos,
| >
| >See: Implementing Query By Form in an Access Project
| >
http://support.microsoft.com/default.aspx?scid=kb;en-
| us;286828
| >
| >I hope this helps! If you have additional questions on
| this topic, please
| >respond back to this posting.
| >
| >
| >Regards,
| >
| >Eric Butts
| >Microsoft Access Support
| >
| >"Microsoft Security Announcement: Have you installed the
| patch for
| >Microsoft Security Bulletin MS03-026? If not Microsoft
| strongly advises
| >you to review the information at the following link
| regarding Microsoft
| >Security Bulletin MS03-026
| ><
http://www.microsoft.com/security/security_bulletins/ms03
| -026.asp> and/or
| >to visit Windows Update at
| <
http://windowsupdate.microsoft.com/> to install
| >the patch. Running the SCAN program from the Windows
| Update site will help
| >to insure you are current with all security patches, not
| just MS03-026."
| >
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Carlos" <
[email protected]>
| >| Sender: "Carlos" <
[email protected]>
| >| Subject: Filtering a View based on data from a form?
| >| Date: Tue, 3 Feb 2004 05:51:29 -0800
| >| Lines: 12
| >| Message-ID: <
[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| Thread-Index: AcPqXNMv/5DkYWnlQqqo9DyvYIUV4w==
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Newsgroups: microsoft.public.access.adp.sqlserver
| >| Path: cpmsftngxa07.phx.gbl
| >| Xref: cpmsftngxa07.phx.gbl
| microsoft.public.access.adp.sqlserver:16265
| >| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| >| X-Tomcat-NG: microsoft.public.access.adp.sqlserver
| >|
| >| Hi,
| >| In Access (.mdb) I filtered queries based on data
| within a
| >| form by simply using, = Forms![NameofForm]!
| [Nameoffield],
| >| as the criteria for the respective field. How do I do
| >| this within a view (.adp)? When I specify the above it
| is
| >| placed within quotes as a string.
| >|
| >| Note that the view will be used as the source for a
| combo
| >| box. If there is any better way of doing the above
| please
| >| suggest.
| >|
| >| HELP ME PLEASE...
| >|
| >
| >.
| >
|
