Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thank you sooooo much, it work beautifully!!!!

    Thank you sooooo much, it work beautifully!!!!
  2. 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.
  3. 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...
  4. Replies
    3
    Views
    1,626

    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...
  5. Replies
    3
    Views
    1,626

    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...
  6. Replies
    7
    Views
    4,074

    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...
  7. Replies
    7
    Views
    4,074

    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...
  8. Replies
    7
    Views
    4,074

    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...
  9. Replies
    7
    Views
    4,074

    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...
  10. Replies
    1
    Views
    565

    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
  11. Thread: Split DB

    by RNCIENG
    Replies
    0
    Views
    511

    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,...
  12. Thread: Split DB

    by RNCIENG
    Replies
    2
    Views
    660

    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...
  13. Replies
    2
    Views
    1,039

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

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

    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...
  15. Thread: Report Header

    by RNCIENG
    Replies
    1
    Views
    520

    Report Header

    My brain is failing me miserably!

    I have a report that has a:

    Report Header
    report Footer

    Page Header
    Page Footer
  16. Replies
    9
    Views
    3,248

    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...
  17. Replies
    9
    Views
    3,248

    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...
  18. Replies
    9
    Views
    3,248

    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...
  19. Replies
    9
    Views
    3,248

    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.
  20. Replies
    9
    Views
    3,248

    "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?

    ...
  21. Replies
    18
    Views
    3,259

    You guys are AWESOME!!!! Thanks for your time and...

    You guys are AWESOME!!!! Thanks for your time and effort. Have a great day.
  22. Replies
    18
    Views
    3,259

    WOW!!!! Now that's what I'm talking about....it...

    WOW!!!! Now that's what I'm talking about....it does exactly what I was looking for....RG, you rock.

    Sorry about not uploading the sample spreadsheet, however, with your solution, it turns out I...
  23. Replies
    18
    Views
    3,259

    RG I was wondering if we could take your code...

    RG

    I was wondering if we could take your code a step further and am attaching a sample spreadsheet for clarification purposes.

    Again, thanks in advance.
  24. Replies
    18
    Views
    3,259

    Thank all of you very much. Each suggestion...

    Thank all of you very much. Each suggestion works, however, the one that ultimately will provide what I want (since I eventually want to use it on any given cell) is RG's. You guys rock.
  25. Replies
    18
    Views
    3,259

    Paul, Yes, I want the name of the spreadsheet...

    Paul,

    Yes, I want the name of the spreadsheet that is currently open. I only want a portion of the name, the first left 4 characters. Since my post however, I put a function together to capture...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4