Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. carlosguill

    Moving between forms

    I set the break points, the code is not executed and I got the same message, but this time the message appeared when I hit the enter key. key Preview is set to yes in the main form.
  2. carlosguill

    Moving between forms

    no, it doesn't stop, it goes right through.
  3. carlosguill

    Moving between forms

    I did removed the KeyDown code, and I have not been able to find anything about the ActiveX control.
  4. carlosguill

    Moving between forms

    FOLLOW UP is the mainform, and I have a tab control with FUpIssues subform in the first page and SWHealthEducation in the second page. Another important thing that I forgot to mention before is that the data entry rutine would be as follows. From Mainform (FOLLOW UP) moves to Subform1...
  5. carlosguill

    Moving between forms

    This is the code in subform2, after I set up the KeyPreview to yes. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Call SubFocus(Shift, "FUpIssues") End Sub This is the code in the module Public Sub SubFocus(Shift As Integer, curForm As String) Dim frm As Form, sfrm1...
  6. carlosguill

    Moving between forms

    Hi AceMan1, I tried your suggestion, but as soon as I hit the Ctrl key I get the same message I mentioned above. Any ideas what can be causing that?
  7. carlosguill

    Moving between forms

    Sorry to come back here for more help, but I am stuck now in another step of building these forms. What I am trying to do now is to move from the first subform in the Tab Control to the second subform also in the tab control. I set up the code based on suggestions given here for my previous...
  8. carlosguill

    Moving between forms

    Thank you very much AceMan1, that worked perfectly.
  9. carlosguill

    Moving between forms

    Hi AceMan1, thank you for your idea, I tried it but it is not working, here is what I put in the code, may you can help me figure out what I am doing wrong. Thank you Private Sub DateofTransfer_AfterUpdate() Forms![FOLLOW UP].SetFocus DoCmd.RunCommand acCmdRecordsGoToNew...
  10. carlosguill

    Moving between forms

    Hello, I have a problem about returning to related froms. I have a form that opens another form with a command button, what I need to do after entering data in the second form is to return to the first form with either the return key or tab key to start a new record in form 1 and repeat the...
  11. carlosguill

    how to fill in a field in multiple tables?

    I am very new to Access, could you be a little more specific about the Master/Child links properties? Thanks
  12. carlosguill

    how to fill in a field in multiple tables?

    I have four related tables and all have a field "PATIENTID, how can I update this information in all the tables using a form and sub-forms without having to type the info in each table? the patient ID is a text field with alphanumeric characters.
  13. carlosguill

    fields with multiple answers

    Thank you Richard for your ideas and recomendations, your help was very valuable. Thanks to every body else too for all the suggestions.
  14. carlosguill

    fields with multiple answers

    Thank you Richard, I think this captures exactly what I need, although I still have a question about the QuestionID in the tblPossibleAnswers, I have a total of 55 questions, but the set of answers is always the same for all the questions, so in this case would I need to type all the 55...
  15. carlosguill

    fields with multiple answers

    There are about 50 questions and 5 possible answers, all the 50 questions are answered during the same interview, but each question gets only one answer, although the same question will be asked again at a later time.
  16. carlosguill

    fields with multiple answers

    Sorry, if I am a little confused, but Wouldn't table three store the question ID and the answer to that specific question?
  17. carlosguill

    fields with multiple answers

    To make sure I am in the right path, is this what I would end up with? Question Table Question QuestionID 'Depressed', '1' Answer Table - List of Answers to the Question AnswerID Answer '1', 'Acute' '2', 'Mild' '3', 'None' *Third table*? Data Table - Holds the answers given by the surveyed...
  18. carlosguill

    fields with multiple answers

    Refering to the second table "Answer table" wouldn't I Need a field AnswerID and not Question ID?
  19. carlosguill

    fields with multiple answers

    One more question, do I need to keep the field QuestionID in the Answer Table?
  20. carlosguill

    fields with multiple answers

    Thank you, I think this is what I needed.

Part and Inventory Search

Back
Top