Search results

This works great. One thing, and I'm sure it's simple, but it's giving my a window to put in my criteria, but I'd like to change what displays as '[Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null' and instead have it actually ask 'Manager'...I bascially just want to change...

Good Morning, If I am understanding what IIF does, then I'd like to know how I can use it. I'd like to have a criteria in my query that says, If the input you typed in is the matches the name of a manager, then return the list of dates with JUST that manager. If you don't type in the name of...

Good Afternoon, I attempted to search for a thread on idle shutdown for microsoft access, and I can't seem to find one that works. I've found a few codes, but they either error out and don't work, or not what what I am looking for. I have a form created that I'd like to pop up when the time...

While I didn't know what an aggregate function was (I googled it...) I was able to figure out how to create one thanks to your response. My query came out exactly how I wanted. Thank you.

Good Morning, I have a list of Supervisors that score 5 random calls for each Telephone Operator. I have set up a query to figure out which Telephone Operators have had a 5 Message review completed and by who. Basically, I want to be able to run the query and see which Operators have had a...

This was too easy. Not sure where my head is at these days. Thanks very much, this is exactly what I was looking for.

Gina, I figured out what you meant, and was able to get my report to behave the way I want. The only thing I noticed now, is that the report header prints on the first page only. Is there a way to get my report header to print on all subsequent pages?

Good Morning, I have a report that I run based off of a query that I want to have sorted by each employee. Supervisors go into my database, and fill in a form for each employee which relates to how they do on their calls in the call center. Each employee gets reviewed on 5 random calls. The...

With your direction, I figured it out. Thank you AGAIN!

I have a report which is based off of a query that returns 5 small forms (phone call review forms) per Employee per pay period. So when I run the report, I'm prompted to enter a pay period, which then returns all phone call reviews by operator for that particular pay period. Usually there are 5...

I finally had a chance to place the code before going to the new record and it worked great. Sometimes you stare at this stuff long enough and it throws you for a loop. I thank both of you for your help and am very much appreciative.

Okay, so I was able to get the button to go to a new record, and count to 5. But the form is not hanging onto the operators name in the drop down combo box. It's a new record all together. Any ideas? Code below: Private Sub Command32_Click() DoCmd.GoToRecord , , acNewRec Const cQuote = """"...

I've played with codes and buttons etc, but seem to come up empty. I get errors when I attempt to change the code and add what you suggest. Below is the code for the form: Any help on creating the code to achieve the counter and cmdsaveandnext button? Option Compare Database Option Explicit...

Got it, I changed the code to reflect my control as 'combo21' which is the name of that combo box, but when I attempt to fill out the form and click on the button I created with the code below, nothing happens? Private Sub Command30_Click() Const cQuote = """" 'Thats two quotes...

Great, thank you. I'll try that now. Would this also give me some type of counter? Also, when you say text box, do you mean form?

Thanks for the replies. What part of my code to I change with regards to the following: const cQuote="""" 'Thats two quotes me!Control.DefaultValue = cQuote & me!Control.Value & cQuote ^^ I grabbed from your link... but what piece do I change to relate to me form? Also, I liked the...

I have a simple form that I have supervisors fill out as they listen to recorded phone calls for telephone operators. They open the form, select their name from a drop down list, fill in the form, and then press a button that saves and closes the form (pic attached). Once they close the form...

Yes, it has. Thank you.

Would it? YES! I swear I did that, and it didn't work. Thanks again!

Good Morning, As I go back and try to refine my database, I am trying to tweak the code that will place a new space between comments in my comment box. It'd be easier on the eyes to see a space in between comments from other users. Right now, when someone updates the comment box, there are not...