Go Back   Access World Forums > arnelgp

 
Conversation Between arnelgp and farhanleos
Showing Visitor Messages 1 to 5 of 5
  1. farhanleos
    02-22-2018 03:13 AM
    farhanleos
    Sir ,
    How are you its long I did not post , I faced an issue with my database I need your help.
    i am working on a database with multi user access with different security level
    i created a search form "000-SEARCH PROJECT QUERY" based on query.
    1- Combobox "combo41" (show proponent values from the qry
    2- Listbox "List50" (Populate the filtered data based on combobox
    3- Textbox "text22" (auto populate the login user security level i.e "1",2
    Aim
    when a user with login by his security level i.e "1"
    when he execute the search form the combox will show him just those proponents he is responsible which comes under his security lvl
    so he can select the correct proponent and i will show the list of filtered data in the listbox under that proponent
    combobox showed all proponents without filter
    and on selecting any proponent list box filtered the data
    i add a text box which shows the security level of login user on executing this form i.e one user login and his security level is "1"
  2. arnelgp
    11-01-2017 05:14 AM
    arnelgp
    your code is fine except that you are
    not comparing Progress field to String,
    just enclosed it in Double Quote.

    this, and with the rest of the code
    that test Progress:

    If Me.Progress = Completed Then
    ...
    ...

    should be:

    If Me.Progress = "Completed" Then
    ...
    ...


    also, on the last part of the code:

    Me.dataTickedOff.Enabled = False

    should be:

    Me.dataTickedOff = False
  3. farhanleos
    11-01-2017 12:25 AM
    farhanleos
    Sir Arnel,

    I need your professionalism on below threads , Kindly see
    Appreciate your teaching and quideline
    https://www.access-programmers.co.uk...d.php?t=296701

    https://www.access-programmers.co.uk...d.php?t=296710
    https://www.access-programmers.co.uk...d.php?t=296545
  4. arnelgp
    10-27-2017 10:48 PM
    arnelgp
    Do you know which thread or forum is it, i already fix the db
  5. farhanleos
    10-27-2017 07:07 AM
    farhanleos
    Sir,
    I need your help with one database Its about adding check list inmy own database
    but first before implement I need to understand and implement it on raw data
    I found this on you tube but its not explained well,i mixed up with module and scipt duplication .
    I want your help if you say I will send you thedatabase
    and if you can check it ?



All times are GMT -8. The time now is 07:20 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World