Search results

jzwp22, Thanks for the reply. I actually got if figured out. I was trying to make it much harder than I needed to by putting where[bmtbl].[locationnumber]=[directory].[locationnumber] into the criteria field. Once I took that out, it worked fine as can be. I've got it grouping and sorting...

Happy Friday all. I have two tables. One is a Managers Table. It contains the manager's first name, last name, and location number, with the location number being the primary key. The other is a locations table, which has a location number (again the primary key), the location name and...

Thanks everyone for your help on this. Sorry I am just now getting back to it, but a emergency has had me away from the project for a few days. I did find a work around. In the query that shows the transactions by hour, I went ahead and set the formatting (through sql) to round the number...

Dave, Thanks for the reply. I hope I don't sound to ignorant by asking, but what is a visual query? Thanks,

jzwp2, I'm sorry about the delay in responding. I am changing the value for Productivity from 6 to 12 in the table itself. It is formatted as field size Single to allow for decimal places and it is named CSRProd. I haven't set any formats in the sql as of now. I'm still not familiar enough...

I have 1 table and 2 queries. The first table is Productivity. It contains a number for Friday's productivity for one of our deparments. We'll say the number is 6. The first query shows how many transactions, by hour, we can expect on an average Friday. At Midnight, the number is 0.924...

Ray, The articles fixed it. There was a missing reference to a .dll file. I disconnected that link, and sure enough, everything is showing up fine again. Thanks guys for all your help. I'm off to figure out how to set up the logs to see who is doing what. This has been enough of a head...

Ray and Trevor, Thanks for the suggestion. I tried putting in the new text box with the =date() in it, and I'm meeting with the same result. I'm wondering if someone installed an activeX control that's messing with it at this point. Do you all know of any that might have that effect...

Trevor G, Thanks for the reply. After the initial post, I noticed that this is messed up on all of my reports, as well as the few forms where I've got it displaying in the footer. Unless someone really went to town, I'm not sure what they could have done.

Hello, I'm sure it' a simple problem, but I can't seem to get it fixed. I have a database with multiple reports. On each of these reports I have a text box with "=date()" in the field. This is in a short date format. Up until today, the date was showing up fine. Now, for some reason...

Thanks guys. That worked exactly how I needed it to. Have a great evening.

I have a form with several items used at our location. Each item has a button attached to it that, when clicked, will send out an e-mail requesting the item be ordered. Each item also has a yes/no field associated with it. When the "Order" button is pushed, I need that button to change to...

Just wanted to post a quick update with one of the things I am trying. In the new query, I have all of the fields for AbsenceInteractionTable1 pulled down, with AbsenceInteractionTable2 and LateInteractionTable1 linked to AbsenceInteractionTable1. All 3 tables have the exact same fields, and...

Happy Monday morning all, I have three tables. The first one is a listing of all first time employee interactions managers have with employees. The second, is a listing of all second time interactions. By interaction, I mean the date that they have been written up for a violation. The 3rd...

vbaInet, Thanks so much for that! That works perfectly, using the DLookup, and I honestly never would have figured out how to do that. Now I know for future problems. Thanks again for all your help. It's a small thing, this whole conditional formatting issue, but it will make my bosses...

vbaInet, were you able to get this to work on the stripped down version I sent over? I've tried both codes. When I try the "expression is" code, it is not saving it. I click "Ok" on the conditional formatting box, I click save, go back to the report view and see that nothing has changed...

Here is the stripped down version. Everything seem functional except for that one bit. Thanks, and if I'm not able to get back to you, have a great weekend.

vbaInet, here is my current code, still with no luck. [Reports]![npshuddlerpt]![npsscore]<[Reports]![npshuddlerpt]![npshuddle2rpt]![Goal] There are 5 fields in the subreport, 1 record for each field. Thanks for all your help and patience! *edit* It is now coming up asking for...

The subreport only returns one record. The main report returns 30 or 31, depending. I'm really sorry, but I'm very much an access novice, so your comment about only having 4 levels is one that I don't understand. Would you mind elaborating? Lastly, how would I use dlookup in conditional...

vbaInet, my reference now says expression is [queries]![nps huddle qry]![nps score]<[queries]![nps huddle qry 2]![Goal] When I click "OK" on the conditional format window, I get the error message "You can use the IS operator only in an expression with Null or Not Null." If I take...