Search results

Figure this one out yet? I'm not able to download your sample, so I'm not sure how your report is set up, but if you have a group header, go to its properties. Under the format tab, in Force New Page, choose before Section. This should put each group on a separate page. Does that work...

Seriously, if I hear the word "drought" just one time this summer, I'll petition or something... :rolleyes:

Thanks, Col. That's what I figured I'd have to do, but I wasn't sure if it was do-able with a message box. Hope everything's well with you :) --Sara

Hi, everyone! I want to make a message box that has these customized buttons: Print Preview Print Summary Cancel I've got a message box set up with the message I want, but it has vbYesNo as its button type. I don't know much about this, and the programming portion of Help is not installed...

Found solution Hi, all. I found a solution. Whether it's the best solution or not, I'm not sure, but it works well so I'm going to stick with it. What I did was average a re-calculation of the DateDiff: =Avg(DateDiff("d",[DateFiled],[DateMailed])) And that does it for me. I also have...

Hi, Tim Thanks for the response. I just tried DAvg: =DAvg("[FileToMail]","qryDeputy") ...and I get an #Error. (Have also tried without brackets) Question to you: If I get this right, will it still do what i need and just average the stuff in the previous group? The purpose of the...

Hi, All! I'm trying to calculate an average in a group footer in a report. In my underlying query I have calculated a DateDiff, and this is what I want to average. I've tried using an unbound text box and using =Avg([FileToMail]), but it tells me my sql includes an invalid data type. So...

Tom, How many choices are there for types of service? I've come across a similar situation and have used option buttons with a select case in the event sub which renders fields (and subforms) visible, invisible, abled, disabled, and all that. So if you only have a few choices, that may...

Thanks, Pat! You're beautiful! :) It worked!! --Sara

Hi, all! I need to import a large text file into a table. I was showed how to do this on a colleague's computer, where I set up all the specs and all that for the text strings to go into the correct fields and all that. Trouble is, on my PC for some reason, it does not allow me to import a...

Solution or Cheap Work-Around? After doing a lot of toying with the thing, I finally tried this: 1) I added ReportMonth and ReportYear fields to my form where the report was run. 2) I changed the criteria in the query to [forms]![frmChairmen]![ReportMonth] and ...[ReportYear] 3) I changed...

Thanks, both of you, for your replies! Pat, I'm working on your suggestion of creating subforms, but I think I'm getting problems because of parameters I've set up in the query the main form is based on. Let me try to better explain: There are a number of Appeals Chairmen (and Chairwomen)...

Hi, everyone. I'm working on creating a report that has a pretty detailed summary at the report footer. In the detail section, all the appellate cases for a certain month (inputted by user) are displayed, including the type/level of case, the issue of the case, the decision (outcome), how...

Thanks, Mile-O-Phile. That's brilliant! :) Works great. --Sara

Okay, Mile-O-Phile, I tried out your code and it worked beautifully! Is there a way to do it for five different fields all at once? If not, then perhaps DJN's method is the way to go? DJN - haven't tried your method yet, but I'm just about to. Thanks for the response! :) --Sara

Mile-O-Phile, Thanks for the reply! That was quick! Do you think you could tell me more about how that works? I'm still learning so I don't understnad where your numbers are coming from - where do I put the empty date/time fields? If I put them at the end of the table, would it not effect...

Hi everyone. I'm working on a new project where I get all my data from an outside source imported as a .txt file. The Main table has already been created, my job is just basically to manipulate data, calculate some stuff, and basically just make it easy to understand. The calculations I...

No, it's not - I'm in this job through April. (Feels like I'm never going away, doesn't it?) I've got 2 more projects lined up, plus I have to train the users on the database I just finished.

I just wanted to say thanks to everyone who helped me with my last Database. I finally can say (with 95% certainty) that it is FINISHED! Anyway, I definitely could not have done it without help from this forum, so THANK YOU! Especially thanks to ColinEssex, Ally, HayleyBaxter, The_Doc_Man...

Not a PHB, Thanks for the reply! I've actually sort of discovered what was causing the query to have duplicate results (I think). It had to do with other things I was doing to manipulate data. I don't really have any idea what was really going on, but I had changed how I went about some of...