Recent content by EdNerd

Ahhh .... I put the calculated field in the query, where it displayed the desired result. But I then removed the original field from the query. When I restored the original field to the query, the text control in the report showed the desired result. (y) Thank you!!

(Using Access 365/2013/2016) My table has two fields that are Yes/No, with a checkbox Display Control. I am creating queries that use these controls, and then basing Reports on these queries. When the report is displayed, I would rather have a text value of Yes or No displayed instead of a...

I am trying to get the first, second, third, and fourth values into text box controls. Here's the steps I have so far: -- I have a Top 4 query to return the top four records. -- I run a Min query against those results to return the fourth record. -- I use Dlookup in a text box control (Control...

Thank you, Rx! It worked!! I sorted my fields, and added Group By with Max on the date. You guys are making me look good! :8>) Ed

I have two queries that feed into a table; the first makes the table and the second appends to it. Then I query the table. My final query outputs names, actions, and dates. Just due to the nature of appending the records, I will have records such as: -- Name, Action, Date=Good -- Name...

Michael: the class is a bit above me. I'd love to learn that some day - but I'm not there yet. David: I agree with you. I went with a simple function to calculate the date and an If to get the string, and I'll push the string string into the form. Thanks for the help! Ed

Not quite sure how to go about this. In Access 2007, I need to pass a date into a function. The function will calculate and return the fraction of the year between that date and today. Then I need to use that fraction to determine a string value. The number and the string will be used in two...

Thank you, Isskint! I appreciate the boost. And thank you, DaveAtWork, for the info. Ed

Yes, I've done that lots of times. I'm not sure I understand everything you're trying to communicate to me, though. You seem very reluctant to use the Environ$ method to get the UserProfile or UserName. But I will only have permissions to the profile level, and nothing between C: and there is...

Yes - I've done that before in my Excel projects using XP. My biggest questions for this Access project were: -- getting the default location in a Windows 7 environment? -- does this work from a split db across the network? Those are new variables for me here. Ed

Understood. In this case, my users would save these files on their local machines, and most of them in the default location. If I can grab that default location, I can (1) create a Reports folder inside that directory to store any reports, at least initially, and (2) set an Excel object to the...

Yes, I saw that when I first used this method. But that's what prompted me to ask about this. And just so I'm sure I understand -- when the user opens this form from a networked server, the form is inside the user's operating system and will return the user's path? Not the server's path? Ed

It works on my XP Pro machine with AC2007. I'll have to wait to try it on a Win7 machine. Thank you!! I've used USERNAME before, but didn't know about USERPROFILE. Would've saved me some time! Ed

I'm fairly experienced with Excel VBA, but I'm just beginning the adventure with Access VBA. In Access 2007, I'm writing code for a form button to export SQL results into Excel 2007 using DoCmd.OutputTo. It all works as I test it on my machine. When the project is completed, I intend to split...

In my normal day job, I deal with lots of data. And I've gotten reasonably good with Excel, especially VBA. But Excel has its limits, plus I've inherited an Access database that is really a form and queries and reports built around a single monster table that - yep! - used to be a spreadsheet...