Search results

One issue I've noticed that's keeping me from an easy conversion here is that my "date" is not always an actual date, it is a target date or period, so some records may have "December 30, 2010" and others may have "Fall 2010". This column does not have a 'date picker' but, rather, it is an item...

Thanks, this method should work, too. I'll play around with it. My DB has both the date and the zip in the same table, rather than 2, but I think I should be able to figure it out. I'll let you know if I have any questions. Thanks, happy holidays!

I have 2 combo boxes on a form: [cboARRAdate] & [cboARRAzip] I want to base [cboARRAzip] off of [cboARRAdate] (user selects a date, and only records with that date's zip codes are available from the cbo) It seems to be working fine, I can select a date, and I can see that the zip codes change...

Hello, I'm trying to get a report to give me a total count of volunteers for the year. I have an overall count, because for each event I enter the total bodies that were there. My problem starts when I try to count individuals. My DB is designed so that I can look at a contact and see all...

Thanks, I think I've got it now. I didn't realize you'd added the line in the query for the report. Now, the trick is to see if I can duplicate this method for other reports. Wish me luck!

Hi, I've been trying to play around with the new feature you worked on for me, and I'm having some trouble. When I try to move (copied and pasted) the button to another form (like, the Report Generator form), I'm running into a few problems. First: when I click the button, I get an error...

Thank you so much for taking the time to put this together! I'll have to play around with it to see how everything is working, but it looks great so far. Thanks again!

Thank you so much! No rush!

Yes, I'd appreciate the help. This seems just a little over my head; I've done all the tweaking I am capable. I will keep playing with it, too, but even if you could get me most of the way, I could probably adjust it from there.

Here's the DB. Primary Table: Tree Work Queries: ContractorWorkReport & TreeSpeciesToPlant Report: CDBGforCITYContractorWorkRpt & TreeSpeciesToPlant subreport

So I put the new query (contents= Species, and CountofSpecies) into the report footer, and it only gives me the first species and total, not all of them. But, if I open up the subform independently, it shows me all trees in the DB and counts properly. I tried moving the 'Species' and...

So add the totals line in the query the report is based off of (the parameter query)? Or, create a 2nd query just with species and totals, and put that in the footer?

Hello, I have a report, run off of a wildcard parameter query for dates, which lists all upcoming work (trees to be planted) needed for a contractor; based off of the date scheduled (planting date/time of year). So, the user can type the date into the prompt and pull all trees for that planting...

I thought that was what I needed, but maybe I'm just using it wrong. It doesn't seem to work for me on a datasheet, only on a text box on a form. I need it to also give the tip when the user hovers over the column header in the datasheet. Any suggestions?

Hi, I would like to set up something so that the user can hover their mouse over a column heading in a datasheet and a little text box or bubble can appear to describe what the contents of that text/combo box should contain. I have many similar-sounding columns, such as "Owner Response" "Owner...

I used the Microsoft students template to create a contact-event tracking DB. I have 2 forms, Events Details and Contacts Details, which are pretty identical in function; open a contact record, and see all events to which they've attended in a subform in the 'events' tab, or open an Event...

Hi, So, I put the following into a query: AllCategories: ConcatRelated("CategoryID","CategoriesAndContacts","ContactID = " & [ContactID]) It returns the ID#s instead of the Category name... I tried to make "CategoryID" just category and got an error. What should it be instead?? I think I'm...

Could I put something into a query, say 'Contacts Extended', by adding CategoriesAndContacts table to it, and joining the ContactIDs (while still returning all Contacts in the DB through the join properties), to return the concatenated Category field? Then, it would be in the record source...

I'd like to use it on the Contact List form, and in reports. When I put it on the Contact List form, it returned #Name? in the field. I just added it to the Category Details form myself, and it appears to be working, however it's only displaying the ID# and not the category name. How should I...

Hi, Sorry, I'd deleted all the records to make the DB smaller, and then imported a handful back in for demonstration purposes, but I attached the wrong DB. Try this one... Thanks!