Search results

  1. F

    adding an attachment and view a file in a form

    This is what i have done. i created a text box rite beside my AddaFile Button I went In the Text box properties and where it says control Source i typed AddaFile so that the control property is bound to that Button so then whenever i click on the button it should attach a file in that textbox...
  2. F

    adding an attachment and view a file in a form

    This is what i have done. i created a text box rite beside my AddaFile Button I went In the Text box properties and where it says control Source i typed AddaFile so that the control property is bound to that Button so then whenever i click on the button it should attach a file in that textbox...
  3. F

    adding an attachment and view a file in a form

    one more question RG. when i click the button AddaFile it opens the folder and give me an option which file to choose and when i click final.doc it gives me a msg with the path of the file but dont give me an option to view that file or have the file name over there in the form. do i need to...
  4. F

    adding an attachment and view a file in a form

    OMG you are the mad RG. Wow........ Thanks for your great help. i assume that you are a database administrator. you helped me before and one more time. Thanks alot RG. Wow i wish i can give you something :).
  5. F

    adding an attachment and view a file in a form

    Dim OFN As tagOPENFILENAME ( Internal error) This is what i get when i complie it.
  6. F

    adding an attachment and view a file in a form

    Wow. never knew had to copy the whole code starting to end sorry for the misconfusion and thanks for all your help. if it works omg i will be your student forever. Option Compare Database Option Explicit Type tagOPENFILENAME lStructSize As Long hwndOwner As Long hInstance As Long...
  7. F

    adding an attachment and view a file in a form

    This is what i have so far for module1. i copied the code from the above url APi
  8. F

    adding an attachment and view a file in a form

    Option Compare Database Option Explicit Dim strFilter As String Dim strInputFileName As String strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS") strInputFileName = ahtCommonFileOpenSave( _ Filter:=strFilter, OpenFile:=True, _ DialogTitle:="Please select an input...
  9. F

    adding an attachment and view a file in a form

    yes i typed it wrong. This is what i have till now Module1 ******************************** Option Compare Database Option Explicit Dim strFilter As String Dim strInputFileName As String strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS") strInputFileName =...
  10. F

    adding an attachment and view a file in a form

    Module1 ******************************** Option Compare Database Option Explicit Dim strFilter As String Dim strInputFileName As String strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS") strInputFileName = ahtCommonFileOpenSave( _ Filter:=strFilter, OpenFile:=True, _...
  11. F

    adding an attachment and view a file in a form

    Error "GetOpenFile" "Sub or function is not defined"
  12. F

    adding an attachment and view a file in a form

    yes RG i did. let me see if this code works.
  13. F

    adding an attachment and view a file in a form

    RG i tried your code in ONclick it gives me an error on this word "GetOpenFile" and the msg is "Outside procedure".
  14. F

    adding an attachment and view a file in a form

    hey RG thanks for helping me out. i am at my home now but before that i was also thinking the same thing that to put that code in ONclick event. MsgBox "You have selected [" & GetOpenFile(CurrentProject.Path, "Select Source File") & "]" when i try to Compile it it gives me an error msg again...
  15. F

    adding an attachment and view a file in a form

    Option Compare Database MsgBox "You have selected [" & GetOpenFile(CurrentProject.Path, "Select Source File") & "]" Invalid outside procedure error.
  16. F

    adding an attachment and view a file in a form

    Module1 is the name for my standard module
  17. F

    adding an attachment and view a file in a form

    thanks for replying RG. i have a button by the name of AddaFile. here is what i have typed in my module Me.AddaFile = GetOpenFile(db2.Path, "Select Source File") Dim strFilter As String Dim strInputFileName As String strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS")...
  18. F

    adding an attachment and view a file in a form

    I have a button by the name of (Add a file) in the form. i copied this code in a standard module: Dim strFilter As String Dim strInputFileName as string strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS") strInputFileName = ahtCommonFileOpenSave( _...
  19. F

    adding an attachment and view a file in a form

    thanks for the reply rural guy. i guess i wil change my field name to ISSUE rather than issue# i know access have issues about that characters. The link you posted (Call the standard Windows File Open/Save dialog box) have a VB procedure so what i need to do is create an event procedure and...
  20. F

    adding an attachment and view a file in a form

    hi all. i am creating a form by the name of ISSUES. i will have a field by the name of ISSUE# where user will be able to type the issue#. i was wondering if it is possible for the user to add an attachment of the issue file. in other ways to make it easier i am asking if it is possible to...
Back
Top Bottom