Search results

  1. P

    Report Output - Prompt for a Folder Location

    The File Dialog along with the existing code did the trick and I learned something new. I also figured out how to include the file name in the File Dialog window. Thanks so much. Dim strReport As String Dim strWhere As String Dim strFileName As String Dim strFolder As String...
  2. P

    Report Output - Prompt for a Folder Location

    The below code is on a command button and it works fine saving the report to my Documents folder. Can this be tweaked to open the File Save As window and prompt the user for a folder location? Dim strReport As String Dim strWhere As String Dim strFileName As String Dim strFolder...
  3. P

    Set-up Junction Table with Additional Fields

    Thank you all for your comments and guidance. I've currently set it up with the comments and responses going in the junction table adding a Primary Key (see image attached) and allow duplicate Contact IDs and Communication IDs should someone comment more than once. All comments will be...
  4. P

    Set-up Junction Table with Additional Fields

    Requesting advice on setting up a table/relationship. The database contains Contacts and Communications that are sent out to contacts. I believe it’s a many-to-many relationship (a communication can go out to many contacts and a contact can have many communications). So I’ve set up...
  5. P

    Max Subquery with Alias

    theDBGuy, Thank you. With a clear head this morning I read your post above. Your suggestion to utilize data in the table helped with two of my issues (one Max and one Min). I changed the below formula MaxVCRatio: IIf([VCRatio]>0,(SELECT Max([VCRatio]) FROM qryRank1),0) to the formula...
  6. P

    Max Subquery with Alias

    Thank you very much for your assistance. I truly appreciate it and have been struggling with this issue all day. Unfortunately when I use your suggestion, I still get the Circular Reference error. In case it makes a difference, VCRatio is a calculation of two raw data fields.
  7. P

    Max Subquery with Alias

    You're obnoxious and I just reported you. If you're not going to help me stop posting. I came to this forum as a last result and need help, not to be ridiculed. It's completely obvious what I need with one table. I need to get MacVCRatio in my query results. How do I alias? MaxVCRatio...
  8. P

    Max Subquery with Alias

    What's D+?
  9. P

    Max Subquery with Alias

    Because not every project will have a VCRatio which is why my formula states if VCRatio is greater than 0, populate the MaxVCRatio, otherwise enter 0. MaxVCRatio: IIf([VCRatio]>0,(SELECT Max([VCRatio]) FROM qryRank1),0)
  10. P

    Max Subquery with Alias

    I receive a "Circular reference caused by qryRank1" error message. I believe it's because the subquery is based on the query that it reside in, yes? The goal is to have the MaxVCRatio in qryRank1 so I can perform a calculation using both VCRatio and MaxVCRatio. ProjectID VCRatio...
  11. P

    Max Subquery with Alias

    I need the Maximum value of the VCRatio column to appear in a column in the same query. I have tried DMAX, but as you know it definitely drains performance so I'd like to try using Max in a subquery and I'm reading that I need to alias the subquery since both values will be in the same query...
  12. P

    Create Table Code Doesn't Insert Data with Decimals

    I sure will and thanks again.
  13. P

    Create Table Code Doesn't Insert Data with Decimals

    They are points so Currency doesn't apply. Decimal did not work and I also found this website that states to avoid using the Decimal field size. https://www.fmsinc.com/MicrosoftAccess/database-design/decimal_data_type/index.htm
  14. P

    Create Table Code Doesn't Insert Data with Decimals

    Yes, you are correct, Double work as well. These number won't be large so I am going to stick with Single. Thanks again.
  15. P

    Create Table Code Doesn't Insert Data with Decimals

    Thanks for you help.
  16. P

    Create Table Code Doesn't Insert Data with Decimals

    Ok, the only thing that work was setting field size to Single. All good now.
  17. P

    Create Table Code Doesn't Insert Data with Decimals

    I also tried the Decimal setting.
  18. P

    Create Table Code Doesn't Insert Data with Decimals

    I did try that prior to posting which I should have mentioned but it didn't change the results.
  19. P

    Create Table Code Doesn't Insert Data with Decimals

    I did not create the code below and need to make a change to it so that the TotalPoints value (including two decimals) is inserted into the TmpUnfundedTable. Currently, it is only insert the values to the left of the decimal. Any help would be appreciated. Public Sub...
  20. P

    Delete record? Yes or No Message box

    boblarson, This is just want I needed. Thanks so much.
Back
Top Bottom