Search results

lol touché. I'm not sure there is a specific term that we use for it. My guess is if they're adequately being provided services they'd fall into one of the categories like domestic violence. I've only been here less than 2 months, so that's a question I'm going to have to ask now lol

It's underserved, as in provided with inadequate services. Though undeserved does take on a whole different meaning lol

I'm not seeing the typo. Were you reading it as "undeserved" instead of "underserved"?

That's a good option as well. I added it. Thanks for the suggestion.

I'd have to agree with that. I'm never using them again. I'm almost thinking it would've been better to start the whole thing from scratch rather than to continue what someone else started. It's working exactly how the office wants it to so far (thanks in part to all of you.) I'm still doing...

I think I got it. I was using strFilter as the WHERE instead of strSQL. It's pulling more accurate results now. Let me do some testing to make sure it's truly pulling all of the data. But thank you so much to all of you for your valuable input. You are all amazing!

I understand. But my office would like to keep the MVFs.

Are you saying my code should look like this? Cause I commented out the where line it's still pulling all records. Again I'm really sorry for my lack of knowledge and truly appreciate all of the assistance I've been given. strSQL = "SELECT * from tblmain " strFilter = filterContract &...

The FY1516 field would keep track of the contract value for that particular fiscal year. I would only need to keep track of the running total for each contract payee across all fiscal years. There does not appear to be (at least until they tell me otherwise) a need to track the total contract...

This is amazing. I really appreciate it. It pulls all of the information, but when I pass it to the report, it gives me all of the records instead of the queried information. I must have the syntax wrong. My report name is "rptqueryresults" I used the line of DoCmd.OpenReport...

Contracts run from October of one year to September of the next. The FY number represents the starting and ending years of the contract. The field will be keeping track of the value of the contract for that particular fiscal year and will keep a running total in the Total field.

I'm inheriting this database from someone else. As I indicated earlier, I'm not very strong in Access. I taught myself what little I do know by looking stuff up in Access books and on the internet. Most of what I've learned is trial and error, so I may know how to do what you're referring to...

Here is a copy. It's in the very beginning stages, so please excuse how ugly/messy it is. Again, I really apologize for my lack of knowledge and truly appreciate any assistance possible. Module1 contains the module. You can ignore Module2. The qryrptby... queries are my manual attempts...

What you're saying makes sense, but I'm just not able to replicate it in the code. I even tried creating a brand new button on frmReports2 and have the code below, but despite making a selection in lstCounties, the selection is not being recognized: Dim db As DAO.Database Dim qdf As...

How would I do that?

When I add ".value" to the Call MultipleContractsCriteria line, I get an error message about object required. I used Call MultipleContractsCriteria(Me, Me!lstcontracttype, "contracttype", me, me!lstcounties.value, "county", me, me!lstprioritycategory.value, "PriorityCategory")

That does work if I put the criteria under the "County.Value" and "PriorityCategory.Value" columns. I have tried calling those in the module, but I must be doing something wrong.

I tried using frmReports1, which has 5 dropdown menus that users can select the criteria from for each of the 3 fields. (5 for county, 5 for contract type and 5 for Priority Category. That works, but is limited to the 5 selections. I also had to manually code each possibility. (i.e. if...

I have a query form, frmReports2, that I'd like the users to select criteria from to run a report on. The form contains 3 multi-valued fields: ContractType, County, and PriorityCategory. County and PriorityCategory are stored as multi-valued fields in the table, tblMain. These fields...