Search results for query: *

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...

Regarding thread 702-1753559 hyperlink/browse for file, Link The link above is exactly what I am trying to do. I know a bit about Excel VBA but very little about Access (365) VBA. I'm a little confused on how to link the code to the text box where the hyperlink would be entered. I assumed that...

After a little more research and some YouTube videos I have figured it out. Thanks for the initial push. renigar

Thanks dhookom, I've been googling the function and the pages tell you the syntax but don't tell you where you use it. In a query, in the report? Could you please provide a little detail or direction.

We have a simple employee database, 1 table, names, addresses. work cell phone number, etc. A new cell phone list is distributed whenever there is a change. Some employees are widely known by a nickname which we have a field for. When printing the report I would like to replace the first name...

Thanks Skip, My data layout was great for what it was being used for until I wanted to make it more flexible. Thanks for the tip. Renigar