Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    3
    Views
    839

    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...
  2. Replies
    3
    Views
    839

    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...
  3. Replies
    7
    Views
    2,518

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

    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...
  5. Replies
    7
    Views
    2,518

    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...
  6. Replies
    7
    Views
    2,518

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

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

    by RNCIENG
    Replies
    0
    Views
    389

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

    by RNCIENG
    Replies
    2
    Views
    527

    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...
  10. Thanks RG, I will give this a try and update then.

    Thanks RG, I will give this a try and update then.
  11. 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...
  12. Thread: Report Header

    by RNCIENG
    Replies
    1
    Views
    409

    Report Header

    My brain is failing me miserably!

    I have a report that has a:

    Report Header
    report Footer

    Page Header
    Page Footer
  13. Replies
    9
    Views
    2,487

    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...
  14. Replies
    9
    Views
    2,487

    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...
  15. Replies
    9
    Views
    2,487

    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...
  16. Replies
    9
    Views
    2,487

    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.
  17. Replies
    9
    Views
    2,487

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

    ...
  18. Replies
    18
    Views
    2,234

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

    You guys are AWESOME!!!! Thanks for your time and effort. Have a great day.
  19. Replies
    18
    Views
    2,234

    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...
  20. Replies
    18
    Views
    2,234

    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.
  21. Replies
    18
    Views
    2,234

    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.
  22. Replies
    18
    Views
    2,234

    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...
  23. Replies
    18
    Views
    2,234

    Parse File Name

    Using Scripting.FileSystemObject. I would also like to automatically retrieve the FULL PATH and FILE NAME (as you can see from my code I have manually input the full path and file name). Once the...
  24. Replies
    7
    Views
    592

    What I need, is it acheivable if I change the...

    What I need, is it acheivable if I change the form to "Single" and apply a list box and apply code to the AfterUpdate Event of the list box? Along the lines of:

    if IsNull(lstOutcome.column(4))...
  25. Replies
    7
    Views
    592

    Thanks Wendell, much appreciated. Changing to...

    Thanks Wendell, much appreciated.

    Changing to single isn't an option. What if I removed the option group and put a field with in the dataset, say "int_OutcomeAssigned", make it a bound control on...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4