Search results

  1. K

    Solved How can I restrict the front-end user from editing the queries?

    Hi, I have shared my Microsoft Access database by splitting BE and ACCDE files. The shared ACCDE file is working fine. But I don't want any user to make changes in any Query. Can anyone guide me on how I can restrict the users of ACCDE files to edit my queries? Thank you
  2. K

    Solved While splitting Microsoft Access BE file an error accrued "The search key was not found in any record."

    I've created a new blank DB and copied the tables only and then made be file and then copy all other objects and then made its ACCDE file. Now it's shared. Thank you
  3. K

    Solved While splitting Microsoft Access BE file an error accrued "The search key was not found in any record."

    Yes, some data was corrupted.
  4. K

    Solved While splitting Microsoft Access BE file an error accrued "The search key was not found in any record."

    No issues were found in the VBA codes.
  5. K

    Solved While splitting Microsoft Access BE file an error accrued "The search key was not found in any record."

    Hi, I am trying to share my database in my Local Area Network. When I am trying to split my database an error appears "The search key was not found in any record.". Please guide me on how to resolve this issue. And share my database so my colleagues also can use that. Thank you
  6. K

    Solved How to get groups of Autonumber depending on another field value

    Thank you a lot dear anrel 😍
  7. K

    Solved How to get groups of Autonumber depending on another field value

    Dear arnelgp, Please take some of your precious time to read the following before analysing my db: I created a GroupCodeQ query to generate sequential numbers by account group and named that field GroupCode0, and then concatenated the AccountID and GroupCode0 using the “&” sign, and named this...
  8. K

    Solved How to get groups of Autonumber depending on another field value

    Thank you for your response. I've attached my db.
  9. K

    Solved How to get groups of Autonumber depending on another field value

  10. K

    Solved How to get groups of Autonumber depending on another field value

    Dear, arnelgp I am waiting for your response.
  11. K

    Solved How to get groups of Autonumber depending on another field value

    Hi Arnelgp, I am sorry for bothering you again. Actually, I've tried this code for a query but It's not working. I am sharing screenshots please check. This is the Query in which I am trying the code (GroupCode2) : The Code I am trying is: GroupCode2: (SELECT Count("1") From ChartOfAccount...
  12. K

    Solved How to get groups of Autonumber depending on another field value

    Thank you So much arnelgp.
  13. K

    Introduction - Hi everyone

    Hi, Welcome to AWF Yuly17.
  14. K

    Solved How to get groups of Autonumber depending on another field value

    Hi, I need help with an access query in which I already have 3 columns GroupID: Auto Number GroupName: Text AccountType: Lookup I want to get different Autonumbers for each account type in a single column. For example in the table below I've added a column name GroupCode, having different...
  15. K

    Solved How to divide total wage amount into currency notes.

    Thank you so much arnel. You've solved my problem. As always. Thank you again.
  16. K

    Solved How to divide total wage amount into currency notes.

    Hi, I need guidance for the Microsoft Access query in which I calculate the employee's wage. I want to get the number of different currency notes making each wage value. So it will be easy for me to distribute them. Example: Name Total Wage 5000 Notes 1000 Notes 500 Notes 100 Notes 50 Notes 10...
  17. K

    Solved I need guidance to calculate Duty hours and Overtime hours

    Thank you so much, Mr. Arnel :giggle:
  18. K

    Solved I need guidance to calculate Duty hours and Overtime hours

    I commented If and End If and leave the content between them. And Deleted the last End If before over_time = Round(tm, 2) Its working now. Thank Yo So much to all specially Mr. Arnel (A greate Teacher).
  19. K

    Solved I need guidance to calculate Duty hours and Overtime hours

    Deleted
  20. K

    Solved I need guidance to calculate Duty hours and Overtime hours

    Commented Out An Error occurred when I am trying to use this function in query now: Error In VB when compiling: Please check the code: 'arnelgp Public Function fnComputeTime(ID As Variant, ByVal t_in As Variant, t_out As Variant, ReturnWhat As String) As Double ' parameters: ' ' id...
Back
Top Bottom