Search results

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

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

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

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