Search results

  1. A

    Cut & Past .pdf file from a folder to one another in Microsoft Access

    Hi, How can I achive a Microsoft Access db that can cut a .pdf file from one folder to one another and rename it by selecting the file from a listbox to another listbox within a form called frmFileManager ? CUT From folder path B:\FOR REVIEW File name is variable as: 16JUN19-DDB-001.pdf...
  2. A

    Pass Data from MS Access to AS400

    Thanks everyone for your responses, I will point that to my boss that the best solution is to connect throw the ODBC connectivity. Now it's clear to me that the solution is to amend our organization's policy to accept connect the MS Access database with AS400 db through ODBC. Thanks again...
  3. A

    Textbox format Decimal Places depends on currency selection

    I got it work, thank you very much. Sent from my HUAWEI NXT-L29 using Tapatalk
  4. A

    Textbox format Decimal Places depends on currency selection

    It's fine now I got it. Thank you so much. Sent from my HUAWEI NXT-L29 using Tapatalk
  5. A

    Textbox format Decimal Places depends on currency selection

    Thanks a lot, it do the trick I moved my code with your suggestions in the after update event of the currency field, it works fine. If any body need my full code I will provide it. Thanks to all of you. Sent from my HUAWEI NXT-L29 using Tapatalk
  6. A

    Textbox format Decimal Places depends on currency selection

    OK, so how can I change my code to be as a function instead of in the current event? By the way I prefer to be as a standard format too that would facilitate the auto commas between millolions and thousands. Thanks a lot in advance! Sent from my HUAWEI NXT-L29 using Tapatalk
  7. A

    Textbox format Decimal Places depends on currency selection

    Thanks theDBguy as I said earler you are always so active. Do you mean it's not possible? Sent from my HUAWEI NXT-L29 using Tapatalk
  8. A

    Textbox format Decimal Places depends on currency selection

    Hi Guys, I have got a textbox representing the amount depends on currency selection, I would like the format of the decimal places to be changed when I select: 1. USD then the decimal places would be 1,223.66 2. KWD then the decimal places would be 1,223.660 here is my code but it's not working...
  9. A

    Add two values into Combobox items

    Thank you so much the DBguy you're always so active, I am waiting for your help in providing a demo on: I am not insisting if you could get time to do so.:) Thanks again!
  10. A

    Add two values into Combobox items

    Thank you so much, it's done as my desired :).
  11. A

    Add two values into Combobox items

    I have got a code to fire in (not in list) event of a combobox to add two values in a table called: tblCompanies but it's not working getting error: Run-time error '3134' Syntax error in INSERT INRO. Any help is highly appreciated? Private Sub cboComp_NotInList(NewData As String, Response As...
  12. A

    Pass Data from MS Access to AS400

    ,,[emoji4] Thank you so much, if you could get chance to do it fine and I will search through the sites but unfortunately for me it will be a bit difficult to get it, if I get it work I will let you know. Thanks again, I am waiting any other suggestions. Sent from my HUAWEI NXT-L29 using Tapatalk
  13. A

    Pass Data from MS Access to AS400

    Thanks for your prompt response. But I do not have any idea how to implement this approach !? Let's assume that if I have got four fields in Access like: 1. TransRef 2. TransDate 3. TransAmount 4. BenefitaryDetails How can insert them into my data entry form in AS400 with the same fields...
  14. A

    Pass Data from MS Access to AS400

    Thanks a lot for the all responses, Sorry guys I was busy with my family. Just I want to explain the situation, the AS400 can accept the copy - past to fill up the data entry form from any other active window like HTML if I am correct, that it's possible to get data from MS Access form fields...
  15. A

    Pass Data from MS Access to AS400

    Hi everyone, How can I pass data from Microsoft Access active form to another active program like AS400, by preesing a button in Access and it will pass the whole fields like Transaction reference, Transaction Amount, and Customer A/C. The connection in our environment cannot be through the...
  16. A

    Utlize Attachment field to save a files in a specific shared folder

    Thanks for the link you provided [emoji4] Unfrtuantly, I do not know how to call the function from my form data entry after the user got the sequential ID and rename the file selected as the sequential ID automatically, I prefer to to alter the file view like if it is .pdf (file as usual) with...
  17. A

    Utlize Attachment field to save a files in a specific shared folder

    Thanks for your earliest response [emoji106] I do not know how to use the fileDialog if you could give more explanation but is it can copy the file image or pdf from disktop and past it in a shared folder ( A:\ ) drive? Sent from my HUAWEI NXT-L29 using Tapatalk
  18. A

    Utlize Attachment field to save a files in a specific shared folder

    Hi All, How can I utlize the attachment field to store attachments to a shared drive instead of the access database back end? My table structure as the below: Table name: tblDeptReg. Primary key: PKDes Ref: short text. Attachments : attachment My aim is when a user click a button in data...
  19. A

    how to avoid generating sequential ID with before update event?

    I have tried this function it did not solve the issue. Sent from my HUAWEI NXT-L29 using Tapatalk
  20. A

    how to avoid generating sequential ID with before update event?

    Thanks for your response it's a bound form, how can U amend my code to achive generating the sequential ID? Thanks a lot in advance! Sent from my HUAWEI NXT-L29 using Tapatalk
View older results
Back
Top Bottom