Search results

thanks for your help Thanks for your help with the report. I'll keep trying on the averages. I agree, nested iif statements give me a headache too... :D

hey, that works! That's freaky, it works fine if I run the actual report. I got the error message when I tried to run just the week 5 query, since I hadn't entered the dates it freaked out. Sorry, I should have tried to run the report. DUH! Thanks very much, report works great now. Any...

dlookup trouble Thanks for your idea. I tried your SQL and I'm having trouble with it. The underlying query (qselMeetingDates) has criteria on it to filter based on a user-entered date range. When I use your SQL in the week 5 query, I get an error message that those date range fields can't...

more information Yes, sorry, I realize that I didn't give enough details. Here is the scenario: I have a table called tblMeeting with two fields, MtgDate and Week (for the week # in the month). My report has a subreport which displays the meeting dates for each week above the columns of...

I am so frustrated right now that I could scream. I have a database which tracks attendance and referrals for a networking organization - it meets weekly on Thursdays. It has a report which displays totals of both attendance and referrals for each weekly meeting for an entire month. The...

I have a form with a datasheet style subform which has a combo box with over 100 values on it. It's too long to really be useful, and many of the values are old so they're not really needed for new records. I'd like to filter it using a y/n flag so that only the "active" values appear on the...

Could I get a copy of that sample database? I see that this posting is pretty old, but I'm hoping I can still get a copy of the sample database mentioned. Does anyone have a good sample database for putting photos into a report using links? Thanks!

searching Thanks for the suggestion. I looked at the sample databases and actually found one that was perfect for my users. Thanks! CRT

I already have my database working to open a new form where they can add a new sub and lot number. I just needed to know the logic in that last part of your response, (form.cboname = me.id) in order to have the original screen populate with the new value when they return. Thanks. CRT

I support a database for some users who don't find the built in search function (ctl+f) to be useful enough. The main data entry form of the database has fields for subdivision, lot number and address, any of which they may use to find the record they want. They're requesting that I add two...

Please show how to set combo box to new value Could you please post the code to do this? I'd like to do this, a user has requested it. Thanks!

Candace Tripp's code works on form but not its subform I've successfully inserted the code you linked to disable all fields (from Candace Tripp's forum). It works on my main form, but I can't seem to get it working on the subform. I'm having a problem with the name of the subform - access...

subforms can work You can have cascading combo boxes on a subform, you just can't use a datasheet or continuous forms kind of subform (must be a single form). My database has only two combos - one parent and one child. Are you trying to have one parent with multiple children? Seems like that...

Success! I found the correct name for the subform and it works now! Thanks so much for your guidance.

still have same problem Pat: I tried updating the criteria on my child combo box's query, as you suggested: SELECT [tblTaskSubType].[TaskSubTypeID], [tblTaskSubType].[TaskTypeID], [tblTaskSubType].[TaskSubType] FROM tblTaskSubType WHERE...

thanks for the help I did change the subform to a single form when I read one of your other posts. I'll try your code, I bet it will do the trick. Thanks a lot.

:) I just joined this forum about a week ago and I've had great luck finding examples of what I need in existing threads. This is my first post, and I'm pretty frustrated, so please be gentle... I have read several of the other threads on cascading combo boxes and they've been very helpful...