Recent content by gojets1721

  1. G

    Filter out current quarter's records from query

    Didn't think of that! It worked! THanks @ebs17 and @theDBguy I appreciate the help
  2. G

    Filter out current quarter's records from query

    And this will continue to work even when it turns to Q4 (i.e. Q4 will then be removed and Q3 will be included?)
  3. G

    Filter out current quarter's records from query

    Calendar. So ideally, this query would filter out July 23, August 23, and Sept 23 records until it becomes Q4
  4. G

    Filter out current quarter's records from query

    I have a query that looks at the last 2 years of records based on the 'SubmissionDate' field. Below is the SQL: SELECT * FROM qryAllComplaints WHERE (((Year([SubmissionDate]))>=(Year(Date())-1))) ORDER BY SubmissionDate; I want to use this query as the source for a second one, but one where...
  5. G

    Help with combo box and years

    Where I put that code? The On Click event? (sorry I'm not on my main device so I can't test it at the moment)
  6. G

    Help with combo box and years

    I have a combo box which lists out all years going back to 2014. It's a value list with the row source of: "2023";"2022";"2021";"2020";"2019";"2018";"2017";"2016";"2015";"2014" So when it turns 1/1/2024, I need to manually add "2024" as a value. Is there an automated way to do this instead? So...
  7. G

    Add prefix to top 10 query

    That worked! Thanks so much!
  8. G

    Add prefix to top 10 query

    I have a query which groups and counts values, and only shows the ten highest (SELECT TOP 10). It basically looks like this: SubCategory CountofSubCategory Henry 67 John 53 ....and so on I want to add a prefix number to the subcategory field so that it basically shows up as...
  9. G

    Help with AfterUpdate event to add Outlook Attachment to Hyperlink field

    I was able to figure it out. The code is written as if it were a command, rather than a drag and drop situation, which honestly works better. Thanks so much. This has been eye opening to me in terms of how useful ChatGPT can be! Thanks again!
  10. G

    Help with AfterUpdate event to add Outlook Attachment to Hyperlink field

    THank you! So I tried this combined suggestion. The 'drag and drop' from file explorer still works but nothing happens when dragging over from Outlook. I can connect with ChatGPT to dive more into it unless you have any suggestions
  11. G

    Solved Help with on click event of field to bring user to website

    This worked!! Thanks so much!
  12. G

    Help with AfterUpdate event to add Outlook Attachment to Hyperlink field

    Hello. Bit of a unique/challenging question. I have looked for some answers online but can't find anything. This might be a bit too specific of an issue. I have a Hyperlink control in my form to allow users to drag a file from a File Explorer onto the control and it saves that file in a...
  13. G

    Solved Help with on click event of field to bring user to website

    Yes I'm sorry. It's just a textbox
  14. G

    Solved Help with on click event of field to bring user to website

    I have a single view form of customer complaints. One of the fields in the form is a customer ID field. I'm hoping to allow the user to be able to click that ID field and it automatically open up the customer profile on our website. The url is pretty simple. Something like...
  15. G

    Help with AfterUpdate combobox

    That worked! Thanks so much!
See more
Top Bottom