Recent content by alihussain

  1. A

    Loop through the folder with PDF`s

    walk through the code ?? well i done that multiple times but I figure it out by googling the problem and thx for ur help
  2. A

    Loop through the folder with PDF`s

    Still my path field empty, but when I run this the only thing happens is:- added 1 new field and the path empty in the Table1 Public Function files() Dim MyFolder As String 'Path collected from the folder picker dialog Dim MyFile As String 'Filename obtained by DIR function 'On Error...
  3. A

    Loop through the folder with PDF`s

    yeah i wrote it fast didnt take my time 😁
  4. A

    Loop through the folder with PDF`s

    I wrote this code and nothing happens 😁 again Sub loop() Dim MyFolder As String 'Path collected from the folder picker dialog Dim MyFile As String 'Filename obtained by DIR function On Error Resume Next With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Please select a...
  5. A

    Loop through the folder with PDF`s

    @Gasman thx for ur help but i have one question let say we want to open the target folder and get the path of 1 file in it without any loop?
  6. A

    Loop through the folder with PDF`s

    After i click the command button nothing happens, when I press run to test it, it prompts me for a macro name.
  7. A

    Loop through the folder with PDF`s

    Hi, I created a table which called Table1 to contain 2 fields ID= auto number & Path=long text, then i created a form on it ID, Path, and command button which will function returns the path of files Private Sub Command10_Click() On Error Resume Next Dim fso As New...
  8. A

    ADF Scanner in Access

    Thx guys for ur help i solve the report problem but one thing I hope u guys help me with which is the ADF scanner if I have ADF scanner, how to scan the papers from the feeder, not from flatbed or scan from both ???
  9. A

    ADF Scanner in Access

    for ur Q : Does report have Image control bound to Path field? yes its
  10. A

    ADF Scanner in Access

    well im still having this problem with reports, my code is: Dim reportName As String reportName = "name of the report" Dim fileName As String fileName = "PathOfFile which contain the path of the scanned image" DoCmd.OutputTo acOutputReport, reportName, acFormatPDF, fileName...
  11. A

    ADF Scanner in Access

    @shadow9449 how to update the report? when I scan for the first time its good but when I try scan the 2nd document the pdf file contains the first scanned document, not the 2nd.
  12. A

    ADF Scanner in Access

    @June7 thx for ur help, jpg file is saved yes and I made a default location in partition D and PathOfFile hold this location and about the topic of conversion i tried the code the problem is this"sheet1.Activate"i got this error after i run it " Run- time error '424' : object required" and i...
  13. A

    ADF Scanner in Access

    Hi All how to modify this code to scan from a feeder, scan multiple documents, and convert jpg to pdf? Any assistance you can give would be GREATLY appreciated. Option Compare Database Public PathOfFile As String Private Const WIA_Format_JPEG As String = "{B96B3CAE-0728-11D3-9D7B-0000F81EF32E}"...
  14. A

    Problems with displaying PDF on Web Browser Control in Access Form

    First thing thx you guys for your help !!! @pisorsisaac@gmail.co well i tried many things rly but I think I found the problem and its my adobe or my PC idk exactly but when tried on my laptop it works ...but it's open in adobe program not inside access form so I'm not getting save or open...
  15. A

    Problems with displaying PDF on Web Browser Control in Access Form

    So we can say this is a dead-end we can't display a pdf and documents inside access form???
Top Bottom