Search results

  1. A

    Multi Approvals Task Management (Dashboard Control Form)

    Thanks for your response. Actually I was waiting for your response, but I missed the notification. Yes, the documents are categorized and the path is consistent for each document too. Still I am confused to structure the transactions table [Cases] that it has a columns for each department...
  2. A

    Return Seven working days excluding Fridays and Saturdays

    Sorry dear it's entirely another post nothing to do with working days. I am struggling with it I do not know how structure the control form. Sent from my HUAWEI NXT-L29 using Tapatalk
  3. A

    Return Seven working days excluding Fridays and Saturdays

    Any suggestions regarding the below post: https://r.tapatalk.com/shareLink/topic?url=https%3A%2F%2Faccess-programmers%2Eco%2Euk%2Fforums%2Fshowthread%2Ephp%3Ft%3D307296&share_tid=307296&share_fid=51301&share_type=t&link_source=app Sent from my HUAWEI NXT-L29 using Tapatalk
  4. A

    Return Seven working days excluding Fridays and Saturdays

    Thank you very much for the links you provided, sorry your tired with me.[emoji4] Sent from my HUAWEI NXT-L29 using Tapatalk
  5. A

    Return Seven working days excluding Fridays and Saturdays

    Thanks theDBguy for response. I will try it once I reach home and will let you know the result. Sent from my HUAWEI NXT-L29 using Tapatalk
  6. A

    Return Seven working days excluding Fridays and Saturdays

    Thanks for your prompt response. Unfortunately, it was for another database, plus when scroll down I did not see any link. Is there a simple way to achieve it? Sorry for my limited knowledge in Access. Thanks in advance! Sent from my HUAWEI NXT-L29 using Tapatalk
  7. A

    Multi Approvals Task Management (Dashboard Control Form)

    I am so sorry for the delay, I am still struggling to overcome this issue, actually to clarify my need is that I want to create a control form that contains the FormName (pdf fillable forms will be uploaded to the database as text path) and it's flow through the departments it can be vary from...
  8. A

    Return Seven working days excluding Fridays and Saturdays

    Hi everyone, I have got two fields [Opened Date] and [Due Date], I would like to return the due date of 7 working days excluding Fridays and Saturdays from current date. How can achieve this by macro and the same by VBA too afterupdate event? Thanks in advance! Sent from my HUAWEI NXT-L29...
  9. A

    Connect back-end to front-end other than shared folders

    Thanks theDBguy for you clarifications. I heard about moving the back-end from MS Access to SQL Server is that much faster than UNC? I think it will not need a shared folder if it's connects to SQL Server right? By the way I have got one text field stores file path, how can I help it if will...
  10. A

    Connect back-end to front-end other than shared folders

    Thanks a lot for your prompt response. I have just heard about the UNC path. Is it easy to implement this path as the normal connection? Because I am experiencing delay in request and response. Sent from my HUAWEI NXT-L29 using Tapatalk
  11. A

    Connect back-end to front-end other than shared folders

    Hi, I have got a Microsoft Access split database in a local network through shared folder. I am wondering if there's a way whereby I can connect the front-end to back-end without the shared folder through localhost? Because I am getting deficulty to normalize all the users in a one partition...
  12. A

    Filter Datasheet Split Form

    Sorry for the delay, it does not filter anything! May I missed something in the form?
  13. A

    Filter Datasheet Split Form

    Thank you for your reply, unfortunately, given my little knowledge of code, please help me to define my code as select case. I am not insisting, if you have enough time to do so. Thanks in advance!
  14. A

    Filter Datasheet Split Form

    Thanks for your prompt response, I will try it once I reach the office.
  15. A

    Filter Datasheet Split Form

    Hi, How can I filter a split form with datasheet type depends on the department login to the application? The department login ID is returned correctly but the filter is not working at all. I think I missed something in my code. Your kind assistance would be highly appreciated. Private Sub...
  16. A

    Move Typed value from field to another field

    I got the solution. Thanks for your response.
  17. A

    Move Typed value from field to another field

    It's working perfectly getting the same result as theDBguy provided. Thank you so much both of you!
  18. A

    Move Typed value from field to another field

    It's working perfectly. Thank you so much!
  19. A

    Move Typed value from field to another field

    Hi All, I have got two fields in a form one called [AccountNo](ComboBox) and the other one called [ActualAC](Text) I want to move the typed data from AccountNo to AcrualAC field if the value typed not in the list of the Combobox. How can I achieve this? Please find my code below: Private Sub...
  20. A

    Multi Approvals Task Management (Dashboard Control Form)

    Hi All, I am working on a Multi Approvals Task Management database and trying to set up a Dashboard Control Form which will allow me to predefined each task (Combobox) and it's concerned department. How can I achieve this form of control? As an example: 1. Task 1 should be assigned to four...
Back
Top Bottom