Search results for query: *

Sure - Don't imagine for a moment that I made this up on my own; it's copied from the FAQ that I mentioned in my original post. Private Sub cboSchoolName_NotInList(NewData As String, Response As Integer) If MsgBox("Add a school?", vbYesNo, "Warning") = vbYes Then DoCmd.OpenForm...

I'm closing the new form by clicking on the Close button at the top of the form - the main form is also open. The main form doesn't close, but goes to a blank record.

Hi - I'm very new to Access, and have gotten a lot of information from these forums. I have a small database that is used to record school attendance for children. The user enters names and other information on a form, and chooses one of the area schools from a combo box on the form. I want...

Rob - Works just fine - thanks for the help.

I'm using Crystal XI, and am fairly new to Crystal Reports. My report is grouped by case number. Some cases contain both adults and children, and some only adults. My data fields are: Case Number, person ID number, Date of Birth. I want to suppress any group (case number)that contains a...

jseltmann - I think I've come up with a solution, based on your code. What I want my query to return is the date that the review should start each year; in my 11/20/1994 example, I want the query to spit out 7/22/2005. If I run the query again next year, I want to see 7/22/2006. This is what...

Yep, you're right about the date - I counted wrong (which is why I need the code!). The above function works fine for new approvals - calculates the date one year ahead, less 120 days. I was hoping, though, to find something that would give me the 2005 renewal date for my 1994 licence...

I'm creating a database to track licenses given out by our agency. We will be entering the current license holders in the database, as well as new applicants. One of the reports that I've been asked to create as a part of this db is a listing of license holders due for an annual review. The...

PH - Thanks for the quick reply. I ran into a couple of problems with your answer, probably because of my inexperience. I adapted your SQL for the second query to fit my data: SELECT A.CASELOAD, A.CASE_NBR, A.Name, Count(*) AS Rank FROM Renewal AS A INNER JOIN Renewal AS B ON...

Hi - I'm fairly new to Access, and have been given a task to randomly select records for quality control. I work in a human services agency, and our supervisors want to pick a random selection of cases from each case manager for review. I've built a query with the following columns: Caseload...