Search:

Type: Posts; User: RNCIENG; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Good Morning, I appreciate all your efforts...

    Good Morning,

    I appreciate all your efforts very much and wish I had your talent and knowledge.

    I've tried everything under the sun to get either of your options to process when the path has...
  2. I am speechless....I love this. Thank you so...

    I am speechless....I love this. Thank you so much.

    There are 2 minor problems--

    1. If the path I'm searching has a space in it I get "no files matching search pattern". If I put the...
  3. Retired, I am currently just running the batch...

    Retired,

    I am currently just running the batch file which creates a text file. I manually open the newly created text file then copy and paste into my table. Yes very clunky but it's the only...
  4. Retired Geek -- Yes I use the file names in...

    Retired Geek --

    Yes I use the file names in my db and your suggestion sounds great, however, there are a couple of hurdles to overcome, the path name will change each month, i.e....
  5. Microsoft Access 2010 -- vba Batch file/fso scripting

    I'm not sure if this is the correct forum for this post, if not, please let me know where it should go and I will close this post and open in the correct forum.

    I have a batch file that works...
  6. Thank you sooooo much, it work beautifully!!!!

    Thank you sooooo much, it work beautifully!!!!
  7. You are correct, the list of file names is in an...

    You are correct, the list of file names is in an Access table, tbl_FileNameList_v18 and field name is v18_FileName.
  8. Access 2010: Compare and copy files to new directory

    Good Morning,I have a list of file names and I would like assistance with VBA code to compare that list to a specific folder if there is a match, copy and paste to a destination folder, is this...
  9. Replies
    3
    Views
    1,846

    This report is required by the state and must...

    This report is required by the state and must include daily activities and must be in Excel or cvs format. For the most part, I would prefer a crosstab query w/in Access but over a 5 month period...
  10. Replies
    3
    Views
    1,846

    Export Data From Access To Excel

    I am working in Access 2010.

    I have a query that returns a date, a username and a count (activities for the day).

    The project I'm is a yearly project that begins in Jan and ends May.

    I want...
  11. Replies
    7
    Views
    4,430

    First, I apologize for the name error. ...

    First, I apologize for the name error.

    Secondly, I finally have the problem resolved. I accomplished this by the following:

    I created a Public Function
    Public strPVDID As String
    Public...
  12. Replies
    7
    Views
    4,430

    Thanks R4. I've made the change as he suggested....

    Thanks R4. I've made the change as he suggested. The str_ToFaxName is the only variable I need from the recordset. The path is where the report resides. The report is named using the...
  13. Replies
    7
    Views
    4,430

    Jeremy, Let me be more clarify. I have a...

    Jeremy,

    Let me be more clarify.
    I have a bound form, recordset is qy_MYQRYName (generic for posting purposes). I would rather not use a form at all only adopted the form usage based on Microsoft...
  14. Replies
    7
    Views
    4,430

    Loop through a recordset in Access 2010

    I am trying to loop through a recordset to send multiple emails. Most of my code is from Microsoft and I have adapted it to my needs as far as attachments.

    I need to send emails to multiple...
  15. Replies
    1
    Views
    600

    How to print a report using a hyperlink

    Good Afternoon

    Is there anyway I can print a report using a hyperlink using vba?

    Thanks in advance
  16. Thread: Split DB

    by RNCIENG
    Replies
    0
    Views
    522

    Split DB

    I have a front end and back end Access 2010 db.  Both sit on a network and 7 users can access it.  I put the following code in so the user can open a report convert it to pdf,...
  17. Thread: Split DB

    by RNCIENG
    Replies
    2
    Views
    673

    Split DB

    I have a front end and back end Access 2010 db. Both sit on a network and 7 users can access it. I put the following code in so the user can open a report convert it to pdf, save to a network drive...
  18. Replies
    2
    Views
    1,062

    Thanks RG, I will give this a try and update then.

    Thanks RG, I will give this a try and update then.
  19. Replies
    2
    Views
    1,062

    Capture the file names of a specified drive

    Good Morning everyone,

    I need code to capture the file name(s) from a specified drive and append the names to an existing table in Access 2010. Also, a nuance to this code, would determine if the...
  20. Thread: Report Header

    by RNCIENG
    Replies
    1
    Views
    530

    Report Header

    My brain is failing me miserably!

    I have a report that has a:

    Report Header
    report Footer

    Page Header
    Page Footer
  21. Replies
    9
    Views
    3,459

    I can't thank you enough for the help. Thanks to...

    I can't thank you enough for the help. Thanks to your advice, I modified the code as you outlined and the entire process works as it should now.


    On Error GoTo Err_cmdOpenQuery_Click
    Dim...
  22. Replies
    9
    Views
    3,459

    I really appreciate your help. I added the...

    I really appreciate your help. I added the debug.print and breakpoint. Below is the code from the immediate window.


    SELECT ApVenTest.VenNumID, ApVenTest.VenName, ApTest.GrossAmt
    FROM ApTest...
  23. Replies
    9
    Views
    3,459

    I'm going to post my entire code so someone can...

    I'm going to post my entire code so someone can perhaps show me the error of my ways.


    On Error GoTo Err_cmdOpenQuery_Click
    Dim MyDB As DAO.Database
    Dim qdef As DAO.QueryDef
    Dim i...
  24. Replies
    9
    Views
    3,459

    Thanks for the quick Response, however, I've...

    Thanks for the quick Response, however, I've removed the &; and still get the message. I'm open to any other ideas.
  25. Replies
    9
    Views
    3,459

    "Select statment includes a reserved word"

    I have looked over this code so long to find the error until my eyes are crossed. Could someone please review my code and see if you can determine why I'm getting the above error message?

    ...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4