Search results

Bit of a shot in the dark here, but I have a listbox in a form that I use to store attachment hyperlinks. I have commands to add an attachment to the listbox, open attachment, delete, etc. Users have been asking though whether it's possible to add attachments to the list box by dragging them...

Ahhh gotcha. That makes much more sense. I'll work on that. Thank you!

Gotcha. How would you suggest restructuring it? I just posted an example DB if that's helpful

Sorry...so there's 8 fields (columns) titled Question1, Question2, and so on. In each of the 8 fields, the data follows the likert scale. I've attached an example DB to better explain

I know, but I'm struggling to design it. I'm sorry, I should have said that. I've only ever used an update query to update one column with one term change (i.e. update any instance of 'smith' to 'johnson' in the 'name' field) There's eight columns with differing terms that need to be updated so...

I have a table where there's several columns using the likert scale (Strongly agree, agree, neutral, disagree, strongly disagree). I want to quickly update all the columns so that any instance of 'strongly agree' or 'agree' is changed to 'agreement'. And 'strongly disagree' or 'disagree' is...

So I've implemented everything and it works well. The only issue is, my attachments are showing up for every record in the main form despite each attachment having an ID equal to only one record (i.e. propertyID in your example). I made the tblAttachments table have a many to one relationship...

I've got a chart for a field where the values follow the Likert scale (Strongly agree, agree, etc.) I'd like for the legend of the graph to follow that ordering (ie. Strongly agree, agree, undecided, disagree, strongly disagree). This is easier for the user to view. Both obv access sorts the...

Thank you so much for the help. Would you ever be able to attach the DB itself? Specifically the one that uses links?

This worked. Thanks so much!

So this produced yesterday's date (11/9/2022). I'd be looking for it to produce 11/11/2021

Perfect. Thank you!!

I was hoping to use a dateserial function to produce a date that is 12 months prior to today's date. So if today is 11/10/2022, then the date serial function would show 11/11/2021. Basically exactly 365 days prior. Any suggestions?

Thank you! This is all working flawlessly. I really appreciate the help

@Isaac This is what I would prefer to do. Any good guides that walk through how to construct that?

Thank you. The attachments I'm looking to store are emails, PDFs, Word documents. This solution works for that? Storing thousands of attachments locally won't lead to any bloating?

That worked!! Quick question though...let's say I wanted to have another filter in the form as well. Like a 'last name' field? Would that change anything?

Sounds good. Any suggestions on any good guides/walkthroughs on how to achieve?

I have a DB full of customer complaints. It is a SQL backend with Access as a front end. I'd like to have an attachment field for each record. If a complaint stems from a customer letter, we could add it to the record for easy access, etc. I have learned that the specific attachment 'field...

Sorry for the delay!! Could you demonstrate your solution in the attached example DB? I'm not sure how to implement what you are recommending. I only want to have one sort. Ascending or descending by time (with the default being descending).