Search results

I have built a Form that was originally a Split Form and added a combo filter that uses a Filter button to activate the Filter. I could not get it to filter the Datasheet part of the split form, so I changed to a single and added a subfrorm. The Subform will filter as desired. Now, I need the...

Everything is good now, I just needed a lunch break and a fresh brain to figure it out, Oh Yeah, and several smart individuals on this Forum!:D

Yep, it worked, but when I filter I get 0 records regardless of the criteria I enter in the combo box.

Wow! I thought I was going crazy!!!!!! Thanks a million!;)

I am using 2007 and I can't get any of the code to work to filter the Form. I have tried several examples in the Forum and nothing happens. Even if I have the Combo as Visible = False it is still there. Anyone have an idea why?

I am using 2007 and I can't get any of the code to work to filter the Form. I have tried several examples in the Forum and nothing happens. Even if I have the Combo as Visible = False it is still there. Anyone have an idea why?

It works great. Thanks. Now I am off to find a way to make my unboud combo filter the form.:D

I have three tables as of now and am creating a Junction table. Categories & Themes which are going to be a part of the Media Table. I have created a 4th which has the fields ThemeID, CatID and the MediaID. My question is how exactly is the subform going to work? I take it that I am going to...

I have a database that is set up to categorize media (ex music and movies) by theme. I have a field Theme which is a drop down. Because each song or movie can have more than one theme, I have 6 separate fields with Theme 1, Theme 2 etc... I have created a Form to filter the Query using an...

Worked Great!!!!!!;)

That is it exactly!!!! :D I'll let you know if I get it work. Thanks

I am creating a database to track variances. Field 1 - Events and Field 2 -Event Tpyes. I want to be able to choose an Event in Field 1, then based on that choice, I want to have a list of options for Event Type. The list of Event Types will change depending on the Event choosen. Can someone...

I thought the same thing, but can't find anything to be different than the months before. I am going to check again. thanks Chris

I have a Form that is set to filter a query by dates. The code in the query linking the two is as follows - Between [forms]![frmConfirmation]![txtbd] And [forms]![frmConfirmation]![txted] - bd = before date & ad = after date ex. bd (4/1/2006) - ad (4/30/2006). It has been working great, until...

I really don't know where to start. I will look into the exchange server. I have access to my calendar and a couple of others that I have created. I was planning on creating a calendar just for this database. I am also looking at connecting my contacts database to my outlook contacts.

You are doing what I want to do [I am trying to get my Database to do what yours is doing in Outlook. How did you do it? here is the url to my post - http://www.access-programmers.co.uk/forums/showthread.php?t=99750 or just look up my posts and the one called Outlook. I want to have the...

I have a database that keeps track of client information and future apointments. I would love to hav this data merge with outlook to go directly into my calendar. Is this possible and how do I do it? :cool:

Yeah I used the code and it worked great. The problem I am having is when I change to the next record the check boxes stay the same. e.g. Chris -1 -1 -1 -1 -1 All -1 (Checkboxes) I click next record and it should read Judy -1 -1 0 0 0 All 0 instead it reads judy -1 -1 -1 -1 -1 All...

I have done this, but it stays the same even after I change the record. I was wanting it to match up with each record. Is that possible?

Thanks guys These worked great. I ended up using jrjr's temp and it worked great. Thanks to both of you. :D This is going to be a great program!