Search results

Jack- I tried your suggestions. It's still not working.

Alright, I think I am getting closer. But, here's the dilemma: There's only one date involved (the date of the call, or the entry), so I can't use BETWEEN. I tried using Field value is greater than NOW()-5, but it colored all "Further actions", not just ones older than 5 days? Any thoughts?

I am using Access 2k. I know I can use conditional formatting, but my question is how do I build the condition based on the date of the entry? For example, how do I tell it to color all "further actioons" older than 5 days to be yellow? And ones older then 10 days become red? Does that make it...

Hi everyone- I am working with a sales db. In the db is a continuous subform that consists of a "date" field and a "notes" field. Because my boss has A.D.D., I added a "Further Action" field to the form. I want to build a query that extracts all of the outstanding "further actions" and puts...

It's Access 2K. Do you think I did something wrong that might mess up my data?

AHA! I tried Pat's suggestion and it seems to be working! Thanks so much for the help! You all are so great. Until next time.

I am not opposed to sending it to you at all, as long as you don't laugh. What's the best way to get it to you?

The record source is tblAgent. That's the same table I added the new fields to.

I am not even using any queries in this particular db. Any other thoughts? Am I too dumb?

Hi Everybody- I think I have an easy question this time: I have a form that records contact info for my sales leads. The form needs another field that I just didn't anticipate when I built the db a few months ago. I added the field to the table, but when I went to add it to the form, the field...

Thanks so much.! I will give it a try. mfaj5

Elana- That does help, thank you. Feel free to send along a link to the article if you still have it. I have time to give it a try, especially if you say it works so well. Thanks again, Mark

Hey everyone- I am fairly new to this whole game, so keep it simple if you can. I made a contacts database for our sales department. One thing I didn't include was a scheduling function. I just have a function that allows them to record a call date and what happened during the call. Because...

Thanks. I will give it a try and let you know if I need more help.

SubForm and Combo Box Hi There- I am new to the forum. I am hoping someone can help me. I built a contact database. The first field in the form is a combo box with only 5 possible values (5 different types of contacts my company does business with). Each of the five values has a completely...