Search results

Sara, I can think of a few options for "hiring" a non-employee: 1) Change tblEmployee so TDNo is not the primary key. If this table is used by other apps, that won't be a popular option. Or 2) Require the users to add an Applicant to tblEmployee before the Applicant can be hired. I don't...

Sara, The list of things you'd "like to see happen" makes sense. If I was doing this I would start by making a query or two for each update action in your list. Test each update action by running the queries. Get the first to work then do the second. Etc. Add conditions and parameters...

Just like you would do it on a form: =Forms![frmDates]![Start Date] & "-" & Forms![frmDates]![Stop Date] RichM

Sara, << what I meant was that I don't know where to start to do the procedure explained in my original post (moving new employees into the employees table, changing the information of current employees, etc.) >> Here's my "vision" of the hire process. 1) You select a Posting 2) You view all...

Sara, A good first step for you would be to do a search on "cascading combo" boxes. There are many threads on this topic. You are using cascading list boxes, not combo boxes, but the principle is the same. I think you have 3 or 4 tables involved here: tblPostings, tblPosition (maybe ?)...

Sara, OK, good luck. If you need help with event handling, post again. RichM

Sara, The form you open is named "FormView" right ? And the listbox control is named "lstPosting" ? Outside of that, I can't think of another explanation. Can you make, ZIP, and post an MDB with just FormView, the listbox queries, and the tables used by the queries ? I can look at it...

Sara, What is the exact message ? When do you get the message ? It does not matter whether the list boxes are bound or not. RichM

Sara, << I've taken your advice and put [Forms]![FormView]![lstPosting] in the criteria for AnnouncementID in my qryApplicationslstbox. >> That's the correct syntax. 1) FormView must be open when you run the query 2) Check and double check spelling The message "Enter Parameter Value" is...

Sara, << I have tried several different things, including in row source ...where ((([qryApplicantslstbox]. [AnnouncementID])=[Forms]![FormView]![lstPosting])); >> First ===== When you type in a string for a Where clause and you want to use the name of a control, you have to break the string...

Here's one from the peanut gallery. I think the command << copy "J:\Tax\Outsourcing\Payment Calculator\Calculator\PymtCalc.mdb" "C:\Documents and Settings\All Users\Documents\*.*" CR "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Documents and Settings\All...

I think this should work: << SELECT qryanlyst.[ECN_Analyst], Count(*) AS Expr1 FROM qryanlyst GROUP BY qryanlyst.[ECN_Analyst] WITH OWNERACCESS OPTION; >> That's just your first example with Expr1 removed from the Group By clause. RichM

Don't Group By Count(*) RichM

Make 2 queries. Query 1 selects Analyst and ECN. Query 2 uses Query 1 and Groups By Analyst. Make a field that is an Expression that is Count(*). Voila. RichM

When you shell to start another program, Windows creates a "handle" for the program. There is a technique to loop until the handle goes away. I can't find a code example anywhere, but it can be done. not much help, RichM

Sara, << The form I have is for tracking the application. On the top of the form there's the posting information and the basic applicant info, and on the bottom there's the stages the application goes through. >> As I see the "hire" form, it presents a list box of all applicants for a...

Sara, Let's start with step 5, select a "winner". Visualize a form with: 1) a list of open Postings. (we'll figure our the meaning of open later) 2) a list of Applicants From the open Posting lists, you click on one. The list of Applicants for the selected Position is refreshed. This is the...

I believe the "execute" method IS NOT supported in DAO. RichM

Sara, << What I wanted to accomplish when I posted this thread was to allow the user to go through the final stage of the application process (hiring) as easily and error-free as possible by adding or changing the appropriate data in tblEmployees. >> Before you start building forms, queries...

Sara, << Wouldn't it handle a many to many? One posting to many applications, one application to many postings... Is this what I had before I changed it all up? >> Yes, tblJunction would handle many to many also. If persons "A", "B", and "C" applied for posting 1 then A, 1 B, 1 C, 1 If person...