User Profile

Collapse

Profile Sidebar

Collapse
aditijangir
aditijangir
Last Activity: May 15 '15, 04:03 PM
Joined: May 12 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • aditijangir
    replied to How to get rid off the ("Edit List Items")icon displaying under combobox
    in Access
    Oh great!

    I found that List Items Edit Form was not null due to which the form was accessible. Else everything was same.

    Thanks a lot :D
    See more | Go to post

      Leave a comment:

    • aditijangir
      started a topic How to get rid off the ("Edit List Items")icon displaying under combobox
      in Access

      How to get rid off the ("Edit List Items")icon displaying under combobox

      Hi friends,

      The problem which I want to rectify is really small but it seems like I am not able to find the solution for it.

      The scenario is like:

      I have a form with a bound combobox. Now that combobox displays EmployeeId based on the query fired. But the problem is that user should not be able to edit the combobox details.

      What is happening:
      When the user clicks on the combobox...
      See more | Go to post
      • aditijangir
        replied to Check for existing EmployeeId in the table and then update password in same table
        in Access
        Ohk.

        I thought that splitting the data and encrypting the Password will help me out. But the thing is the users who are going to use this application will have minimal knowledge . so, this should not be the point of concern.

        Also, I in a big doubt about the admin login. I have created the user login(multi level user login) successfully. But the trouble how to give rights to admin so that , the table ,reports, ribbon will...
        See more | Go to post

          Leave a comment:

        • aditijangir
          replied to Filter the report based on the current user.
          in Access
          Also, one more confusion I am having is; Now when m opening the report the instead of employee id , "ID" is displayed! say if Employeeid is 111111 then it is fetching ID(ex: 34) of that row

          When earlier I was using the query in (Row Source) , report was atleast displaying EmployeeId. what could be the reason for it?
          See more | Go to post

            Leave a comment:

          • aditijangir
            replied to Filter the report based on the current user.
            in Access
            Hi Seth,

            Let me tell you one thing. I am using label to store current user. when I debug the line below, I get correct user Id in Immediate window. Also, report was not showing any data.
            Code:
            strCriteria = "EmployeeId = " & txtUserID   ' where as txtUserID is storing the current user id.

            But when I used TempVar error was coming as in "Syntax error 3075"

            Also the...
            See more | Go to post

              Leave a comment:

            • aditijangir
              replied to Filter the report based on the current user.
              in Access
              Hi Seth,

              Thank you for your reply.


              I have tried implementing your method. But the problem persists.

              It can be because the way I fetch the data from the table.

              What I am doing is:
              I am using Combobox to fetch EmployeeId and EmployeeName in my report.
              It works fine for displaying all users data. But not for current user.

              I tried your way, but blank report is coming....
              See more | Go to post

                Leave a comment:

              • aditijangir
                replied to Filter the report based on the current user.
                in Access
                Hi Seth,

                Thanks for your reply.

                I have tried it. But the report is not displaying any records in it.
                See more | Go to post

                  Leave a comment:

                • aditijangir
                  started a topic Filter the report based on the current user.
                  in Access

                  Filter the report based on the current user.

                  Dear Friends,

                  I am using A2010 Version.I have a report which is displaying the data of all the users, which I want to rectify and display only the data of the current user.

                  Now to give you basic info:
                  I have 2 tables:
                  1)AddUser(Emplo yeeId{Numeric}, Job Title,SecurityI d....)
                  2)Tasks(ID,Empl oyeeId,Title,De scription,Start Date, Due Date,..)

                  Now when the current user click on the command...
                  See more | Go to post
                  • aditijangir
                    replied to Check for existing EmployeeId in the table and then update password in same table
                    in Access
                    Thank you zmdb. :)

                    @Rabbit: I am implementing MD5 for securing the password in my application :D

                    But 1 question ( just out of excitement ) : If I am splitting the DB and securing it with Password. Is it still possible that my users can see the table ?
                    See more | Go to post

                      Leave a comment:

                    • aditijangir
                      replied to Runtime error "invalid Operation" 3219
                      in Access
                      Thank you zmdb for your wonderful help . :)
                      See more | Go to post

                        Leave a comment:

                      • aditijangir
                        replied to Runtime error "invalid Operation" 3219
                        in Access
                        Oh. Small mistake lead me in trouble :P

                        Thank you so much seth. I am really thankful for solving my problem. :D
                        See more | Go to post

                          Leave a comment:

                        • aditijangir
                          replied to Runtime error "invalid Operation" 3219
                          in Access
                          Thank you so much for your reply.

                          System is still throwing an error after I made the provided changes.

                          ERROR: 128
                          Datatype mismatch

                          Note: EmployeeId is an Primary Key with Numeric datatype

                          Have a look to the code:

                          Code:
                          Dim zDB As DAO.Database
  '  Dim zRS As DAO.Recordset
     Dim zSQL As String

Set zDB = CurrentDb
zSQL = "UPDATE
                          ...
                          See more | Go to post
                          Last edited by Rabbit; May 13 '15, 05:31 PM. Reason: Fixed code tags

                            Leave a comment:

                          • aditijangir
                            started a topic Runtime error "invalid Operation" 3219
                            in Access

                            Runtime error "invalid Operation" 3219

                            Hi Friends,

                            I am a newbie in MS ACCESS. I am using A2010 Version. What I am expecting my code to do is: Compare the field of the table and update other field in the same row.

                            My code will make sense better htan words :)

                            Code:
                            Dim zDB As DAO.Database
     Dim zRS As DAO.Recordset
     Dim zSQL As String
     '
     zSQL = "UPDATE AddUser SET [Password]='" & Pwd & "'
                            ...
                            See more | Go to post
                            • aditijangir
                              replied to Check for existing EmployeeId in the table and then update password in same table
                              in Access
                              @zmbd

                              I have used the recordset in my code but it throughing error "Invalid Operation" in Set zRS=zDB.OpenRec ordset(zSQL,... ) line.

                              My code looks like this:(Please provide feedback)

                              Code:
                              Dim zRS As DAO.Recordset
Dim zSQL As String
 '
 zSQL = "UPDATE AddUser SET [Password]='" & Pwd & "' WHERE AddUser.EmployeeId='" & User & "';"
                              ...
                              See more | Go to post
                              Last edited by zmbd; May 13 '15, 04:26 PM. Reason: [z{merged a few posts}{placed code formatting... please used the [CODE/] formatting for posted script/formatted text}{opps missed a code tag}]

                                Leave a comment:

                              • aditijangir
                                replied to Check for existing EmployeeId in the table and then update password in same table
                                in Access
                                Hi zmbd, thanks a lot for your reply.

                                Thanks for making me understand the outcome of CurrentDB , as was not knowing that before.

                                I have a query regarding the code you provided( a lame question I know) , what I need to input in Set zRS = zDB.OpenRecords et(zSQL,(option to how to open)).

                                Also, Why you have mentioned zSQL = "some sqlstring here" so many times in the code. Please guide. I want to learn....
                                See more | Go to post

                                  Leave a comment:

                                • aditijangir
                                  replied to Check for existing EmployeeId in the table and then update password in same table
                                  in Access
                                  First of all I would like to thank zmbd and rabbit for your valuable time. I am glad that somebody is there to guide me.

                                  Now I will look into what zmbd suggested me to.

                                  Also, I am aware about the MD5 Algo. But, If I am not allowing users to go beyond the form view, will they be able to view my control values (as they are invisible)?. Actually, I was not knowing the way to implement those algo's to secure my highly sensitive...
                                  See more | Go to post

                                    Leave a comment:

                                  • aditijangir
                                    started a topic Check for existing EmployeeId in the table and then update password in same table
                                    in Access

                                    Check for existing EmployeeId in the table and then update password in same table

                                    Dear Experts,

                                    I am stuck with pretty good error, which I understand but unable to cope up with.

                                    What I am expecting is : I have a form to provide OTP to 1st time users. The user have to select the Employee Name from the "Combo Box" which is fetched from the Table "AddUser". Now All the validation for checking is perfectly fine. But the twist is; I want that the value entered in the password textbox...
                                    See more | Go to post
                                    Last edited by zmbd; May 12 '15, 02:39 PM. Reason: [z{Please format script/code and tables using the [CODE/] format button}]
                                    No activity results to display
                                    Show More
                                    Working...