Search results for query: *

Duane, this is EXACTLY what the doctor ordered! You were right, the key to getting the summary information is the "query of a query". I didn't know how to do this before and I am still not sure I understand the theory behind it, but I will definitely take the win and move forward. A star for...

Hi Duane! Sorry for beating a dead horse. I am close, just having issues with two (what seem to be) mutually exclusive concepts. Here is the SQL statement that ALMOST works: SELECT AuditErrorList.ReviewDate, MainAuditList.BranchName, MainAuditList.EmployeeID, AuditErrorList.Item...

...a form. The user enters the dates, then optionally selects an employee name from a combo box (leaving it blank selects all). The code executed: '******This executes the report(s)! DoCmd.OpenReport stDocName, ReportDest, , strWhichList & ".[ReviewDate] BETWEEN" & "#" & ddFromDate &...

Gahhh... no edit feature... Oops... I should add that if I remove date/branch/employee I also will have no way of distinguishing when the employee/branch errors were made.

Thank you Skip for your input! Unfortunately, if I remove the date/branch/employee from the select the VBA form will fail... :(

...unique count for EACH "Item" on EACH "ReviewDate". That's the hangup; I would like EACH "Item" total count ONLY (within the date/branch/employee parameter). Too much to ask? I just *know* that the GROUP BY... is messing me up but I am not sure how to remedy this. Help would be appreciated! :) :)

...review number (this is the link to table A, and is the MANY part of the relationship) Question 1 Question 2, 3, etc (you get the idea) What I *want* to do is generate a report that says: BETWEEN (date of review X) and (date of review Y) Question 1 (x number of responses) Question 2 (x...

Randy, Andy, and Duane, thank you for your answers, it now works like a charm! Also, I didn't know about the debug.print/Immediate Window feature. I have learned something new! Thanks guys, you saved me! Cheers! [thumbsup]

...TableA.Description, TableA.ScoringAmount,('&strInteger&') " _ & "FROM TableA; " CurrentDb.Execute strSQL, dbFailOnError 'etc., etc. I *know* I am not getting the syntax right to insert the variable. (the error messages are a hint) However, I am stuck. Does anyone know how I might...

http://office.microsoft.com/en-us/access-help/customize-the-ribbon-HA010211415.aspx This page is a decent resource for working with the Ribbon in Access 2007. What sucks is that it is a lot more work than Access 2003 was. What exactly are you trying to do?

To remove the ribbon in Access 2007: Make a custom USYSRIBBONS table, as outlined in this web page here: http://office.microsoft.com/en-us/access-help/customize-the-ribbon-HA010211415.aspx In the USYSRIBBONS table, you will create a RibbonName text field, and a RibbonXML memo field. Name...

One slight change: The line of code <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> Was missing an end caret. FTFY. Your code worked beautifully!! A star for you! =) A.

I don't think you will be able to do this in Microsoft Excel. You really should consider Microsoft Access. A database application sounds like what you need. You know the saying, "Use the right tool for the right job"? Good luck!

I found a tip here on this site... I don't know which thread I got it from so I can't give credit where credit is due... :( The tip is: Save your .accdb file to your hard drive. Then RENAME the extension to .accdr , ignoring the warning from Windows that the file may not be readable after the...

For security reasons your router/cable modem won't respond to queries that are not on your (wired) local network. Cable modems are accessed by their provider via a proprietary sofware link - not by public internet. Imagine the mischief that could be caused if anyone could reach out over the...

Duane, your remedy worked like a charm. Thank you VERY much!!! :) A star for you - I really really appreciate it! A.

...number that wasn't anything close to reality. I also tried creating an expression in my report query that looks like this: Expr1: (SELECT Count(*) FROM (SELECT DISTINCT Date FROM ExpenseTbl) ) The subquery works great by itself, but when I try to use it in a report I get the following error...

Hello JonathanMortimer: I looked at the picture of your database, and I am seeing the text "Maltius: Database (Access 2000 file format)" on the top of the box of photo 1. Is that what you are referring to when you say it's an Access 2000 database? If so, this is NORMAL by default. Access 2003...

JonathanMortimer: The Access 2000 file format doesn't completely support ADO - usage of ADO was solidified in the Access 2003 rollout. At the time of 2003's release Access 97 was still the big hitter, but wasn't as stable as the 2000 version. There was Access 97, 2000, 2002 (XP), and the new...

Problem solved: There is nothing wrong with the code. What I did was take the original Access 2003 MDB file, moved it to the Access 2007 machine and first repair/compacted it, then made the MDE file under Access 2007. Presto, the list/text box code now works. Go figure. Thanks PHV for your...