Recent content by MrKABC

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

Hi Duane: Just now getting back to the database. I tried creating a base query/totals query but I keep getting missing field errors. Wow, this sure is frustrating. The From/To date and Employee Name filters are located on a form. The user enters the dates, then optionally selects an employee...

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

Thank you Duane, for your response! I tried the Union query, I think I definitely did something wrong. Or rather, it did what I told it to do, but not what I want! :) I think it's my fault for trying to make the problem TOO clear... I distorted what I was asking. Let me try again: MY CODE...

Hi all! I am trying to generate a report that counts the number of questions answered by applicants. I am using two tables (more, but they aren't relevant to this question): Table A: (main table) review number (primary key) Date of review applicant info etc, etc Table B: (questions table)...

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]

Hello all: I'm trying to include a variable (form value integer) in my SQL statement and I'm having difficulty with the syntax. I tried using VALUES without success. My code (removed extraneous VBA stuff): I am trying to insert "strInteger" into TableB in the "IntegerID" slot. dim strInteger...

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