Recent content by renigar

My blindness finally cleared. My mistake was trying to get the max day date by looking at the monthly data columns instead of the from the daily grand total column. Stuff like that makes you feel kind of stupid. Oh well. renigar

I appreciate the comments. I'm stuck here or maybe slightly blind. I figured xlookup was the way to go but, I'm getting the #VALUE! error and can't see what's messing me up. You don't need to solve it but, I could use a helpful suggestion. Thanks

Combo, In my mind, which is often times foggy, the formula has to check through 11 columns and 5000+ rows that will grow every month. It seemed like an array to me. I also thought that since I already got the Max Day value in Column R and the date I need is on the same row as that value, there...

Hello Everyone, The attached Workbook has 15 years of freshwater flow data. There are three sheets. The two main sheets are SupplySummary and FlowData. On SupplySummary, column R is Max Day (MGD) for the year and column S is Max Day (Date). The day in that particular year that had the highest...

Thanks jedraw, That did the trick. I don't think I would have got that on my own.

I'm sure this is easy but I've been staring at it for to long. I get the following error message in this line of code. DoCmd.OpenReport "Evaluation Due Dates R", acViewNormal, , "Division = " & rs.Fields("Division"), acHidden Can somebody open my eyes. Thanks

Thanks again dhookom, I rearranged things a bit an ended up making the box for the EmployeeID use the =[cboEmpID].Column(x) tip you showed me. This works fine for a visual reference to the number.

Thank you. I overlooked setting the ID column to 0. So the search now works but I would still like the ID to appear in the box once the selection is made. Is that possible?

dhookom, Thanks for your help. I had the combo box row source almost like you suggested. I added the Division column. I didn't have the brackets around the field names, and it worked as far as showing the information. When I put the brackets on the field names it didn't work at all. I used your...

This is my first stab at a relational database and it works (I don't know the most efficient way to do things and wouldn't have gotten this far without google) but the user has asked for some tweaks. I created an Employee database that is used for general employee information, keeping track of...

Thanks SoftwareRT, this info helped but hasn't solved my problem yet. I I got into the Power Pivot connection properties for Excel Group Billing Raw and found on the Used in tab (includes Billing Days) has the message "Some properties cannot be changed because this connection was modified using...

I am trying to fix an Excel file that uses Power Query to import data from another Excel file into Power Pivot. This file was created by a former employee and I am not up on these features of Excel. This file was working fine until this week when it started generating a refresh error. The...

dhookom, your suggestion works great. Thank you very much. Andrzejek, your suggestion sort of works. When I execute it I get a dialog box that says, Error: Invalid Operation. Before I can click the OK button it drops the data in the field. Thank you for your suggestion.

Thanks for the reply dhookom, The primary key is the ID, set to autonumber. I'm not back to work until Tuesday. I'll look into your tips then and let you know. Thanks again, renigar

I have a database that keeps track of water utility repair digs. When the repair dig is complete the crew lead fills out a dig card. I'm scanning the cards (because the cards have hand drawn details of the repair) to pdf. The pdf will be kept in a separate directory and opened into the default...