Search results

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

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

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

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...

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)

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...

That worked! Thanks so much!

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...

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!

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

This worked!! Thanks so much!

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...

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

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...

That worked! Thanks so much!

Hmmm. I tried that and it's still not cancelling the change made to the combo

After the "else"?

Okay thanks. So I tried the below code in the BeforeUpdate. It's still changing it to 'In progress' even if I select 'no' from the msgbox. It seems like it's not voiding the user's change to the combobox. Do I need to code it to do that? Dim strResponse As String DoCmd.SetWarnings...

Of course. See attached. So when you open it up, hit the green change log. And then hit one of the entries on the list box. It opens up to the right entry, but also includes complaint number 6's entries. I only want complaint number 5 entries to show because that is what record the user is...

I found some VBA code online to add page numbers from Access to a PDF. It works but the formatting of the numbers is not ideal, and I'm admittedly unsure exactly what needs to be changed to achieve what I'm looking for. Here's the code: Sub addPageNumbers() Dim acroApp As Acrobat.acroApp...