Search results

"docmd.setwarnings" worked perfectly. Thanks for the help.

I'm running an append query in VBA, but would like to disable the prompt after it begins running. Right now, when the query runs, it asks the user to select yes if it's really what they want to do. I want to have it automatically select Yes and move on. Any suggestions? Billy

Yeah, I do know that (now). This was one of the first databases that I'd built and I didn't follow very good conventions then. It originally only consisted of the tblAssignments, a supervisor table, and a tech table. That worked ok for a while, but then the rest of the database was built...

Thanks for the time, but I think this will work: On click event of first form: DoCmd.OpenForm "Assignment Details", acNormal, , , acFormAdd On open event of second form: Dim strTech As String Dim strDpt As String strTech = Forms!frmSB3Details!Technician_Name strDpt =...

I'm currently using the code you listed earlier in the thread: Code: DoCmd.OpenForm "YourSecondFormNameHere", DataMode:= acAdd, OpenArgs:= Me!EmployeeID Code: If Me.OpenArgs <> vbNullString Then Me!EmployeeID = CLng(Me.OpenArgs)End If I've modified it as such: First form: Dim strTech As...

Can this be modified to fill multiple fields? Basically, I'm wanting to auto populate a technician's name and the department he's in when the form opens. Right now I can do one or the other, but I'm not sure of the coding necessary to do both. Any help is appreciated. Thanks!

I'm creating a DB to track training for the technicians at my plant. One particular requirement has the technicians giving oral presentations to a panel of graders. The graders have an assessment sheet where they track how well the technician described the associated task. I would like to be...