Search results

Hello, I've previously posted this question here: http://www.access-programmers.co.uk/forums/showthread.php?t=168702 but thought I would open it up to the rest of the forum for assistance. I have a query that identifies categories of things that don't have any additional data entered about...

***BUMP*** So far I have the two queries working great, but I need a way to control for which quarters are selected from a multi-listbox. It's easy enough to set a reference to the form that contains the listbox, but that only works if one choice is selected. If two are selected, how can...

You, Sir, are a genius! Now a follow-up, if I may: The form that I have for people to build their reports uses a multi-select list box for the quarters. How can I get multiple values from that into the query? Thanks.

Hello, I have a database where project managers enter information about the status of their projects quarterly. This is something they will need to do each and every quarter. I am trying to create a query to determine who has not entered anything for their product in a given quarter so that...

Paul, Thanks again for your help. As usual, I often get hung up trying to figure out how to make Access do something, when the easiest answer is just to make Access do nothing. I also like your check box idea, but I think that I'll get push-back from users (you know how people get) that...

If I may indulge myself, perhaps you can help me with another related problem. So instead of having the user select every option in the listbox or having the listbox default to highlighting everything, I used some code from this site to add a dummy (All) choice at the top of my lists...

Brilliant! Thanks, Paul.

Ok, that is helpful for the first part, thanks. I don't fully understand how Access thinks about filtering reports, so I'm also not sure how to write the filter for the open event. Perhaps I should back up: I have a form that allows users to customize a report. It contains many multiselect...

If I may hijack this thread... pbaldy, how might I extend your logic to filter by multiple catergories? So if I have two mulitselect listboxes on my form, how can I get the code to loop through and filter by both? Thanks, CF

Nevermind, I solved this right after I posted. Please delete, mod. Thanks, CF

Thanks, Harley. Unfortunately, I'm still working with 2002.

Hi Ted, If you don't mind, I'd like to add one last question to your long list here. I've downloaded your demonstrations and built them into my system, but I am stuck on the automatic attachment of the newly created PDF file. I've stepped through the code about 20 times already thinking I...

Ahh, I see. Yes, that must have been the problem. Ghudson's version was written in A97, and while I converted it up to A2002 (my version), I forgot about those little changes in the coding. Thank you again for all your help, Bob and Gemma. It is sincerely appreciated.

Yep, making that little change seems to have solved the problem. Weird. Would you mind explaining to me exactly what the issue could have been? Obviously I wasn't being specific enough for Access, but what was Access likely assuming I meant by simply "recordset"? Thank you so much for your help.

Hello, I downloaded Ghudson's file here in order to allow my users to view documents relevant to the record they are viewing in the database. I've made some slight modifications so that the code pulls all the file links from the directory into a table. The code then scans the entire title to...

Ok, that makes a lot of sense. I'll see what I can come up with, and check back in if I need some clarification. Thank you very much for your help.

Yeah, I have a couple duplicates that pop up now, but I'd rather have too many than not enough. :) Although I suppose having an invasion of them on the screen is no good either.

The_Doc_Man, Thanks for your help. I hadn't considered tracking the work action in a different table. I think that makes a lot of sense, and I'm going to see if I can build that setup. I have a question about Access performing the calculations. There will not be an entry for each day a...

WOW!! Neat feature! :) And who knew there were so many command bars?

I'm not familiar with that debug code. Would I put it at the end of the loop before Next?