Search results

THANKS! It worked perfectly, despite sfrmPlan being based on qryVersion with child link = version and master link = cboVersionSelect

code currently looks like: 'add new task record Dim strCrit As String ' hold criteria for the lookup Dim intPerfNo As Integer 'holds PerfNo returned Dim intVersion As Integer ' holds current version Dim strNameFull As String ' holds name for new task intVersion = 1...

The problem I'm trying to solve is that after I add a new person on frmPerson, and go to frmPlan and click on Add Task for this new person, I get "Runtime Error 94 Invalid Use of Null". There is a workaround, putting data into the "*" record will add a new record almost correctly: Active is...

Thanks. That DoCmd instruction change worked. btnAddTask now creates a new Task record just below itself, in 1st position. Question: when do I use this form of DoCmd, and when the other? Last (I hope) Technical problem: Create a Task record for a new person. There are 3 possibilities, all...

One problem left: I implemented your code for Add Task, and made some changes. It comes up with "Runtime error 2493, "this action requires an Object Name Argument" for DoCmd.GoToRecord acDataForm, , acNewRec This is most frustrating, as I know I have used this instruction before without...

Thanks. 1, I like your elegant solution of the combo box for the job series title. Given the strange custom we have here of using the job series NUMBER almost exclusively, and that I'm adding the title as a courtesy, it's not in the requirements, I need to leave that as is for the moment. 2...

Thanks! Suggestion implemented. Worked. Lol, I need to regain my balance and sense of humor. Glad you have one. If Access reverted to an old version, it did so without my knowledge or consent. Amazing, except for the following minor problems, the database actually works! 1) I solved the Job...

Thanks. I like your delete routine. The excess clutter in mine was to be sure the message box got the right name for the "you just deleted ....." message. frmPlan is working. I went back to an older version and updated it, eliminating some problems. I still don't know what causes the fix to...

The name change has generated some fallout. the following line in frmPerson works, but rs.FindFirst "[ID] = " & Str(Me![cboNameSelect]) this is the version that was in frmPlan rs.FindFirst "[ID] = ' " & Me![cboNameSelect] & " ' " I'm enclosing a copy as I need to know what followthrough I...

Thanks! Worked like a charm. Access did give me the name of the table yesterday, as you thought it might. Do I need these lines? I'm trying to make sure the sub gets the right record. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ID] = " & Str(Me![cboNameSelect])...

add/delete problem Thanks. I like your changes to frmPerson, and have implemented them. Add Person works well. Delete Person works, but I don't know how to get the deleted person's name into the message box. Here's the code. On Error GoTo ErrorHandler 'not an error if user cancels delete...

add and delete Thanks. I appreciate your prompt reply, and have implemented your suggestions. I think that one problem was that I didn't close Access and re-open after making changes. frmPlan worked for me after doing that, and without changing anything. You are correct that the version is...

debugging database Thanks, Dave. Your assistance is greatly appreciated. Sorry about the long delay. It's been a difficult time for me. I've implemented the changes you suggested. The search now works on frmPerson. The delete button works correctly. Problems to go: 1. The person search does...

add/delete I have to leave the office now, will be gone for a week. I'll pick up this thread when I return on Nov 16. Thanks.

need add/delete record A picture is worth a thousand words, so I have enclosed a stripped version of the database with the tables/forms that are giving me fits. This gives you the combo box queries, and anything you forgot to ask and need to. Problem0: Name select combo now gives runtime...

Thanks for your prompt reply. The buttons are in the subform (I did think of that yesterday). I copied them from the old location to the new one. Was that a mistake? The database has been completely closed since then, would that remove a lingering link to the wrong table? on the delete...

I am an Access beginner trying to get up to speed. I have a form (Person data) with subform (task data) I need to be able to (1) create and (2) delete task records on the subform. I used DoCmd.RunCommand acCmdDeleteRecord successfully on the Person form. This doesn't work on the subform. I...