Search results

  1. T

    Criteria across records

    :banghead:Hi, I have a 2010 DB with a table holding student details and another table holding the subjects in which they are enrolled. How can I select those students who are enrolled in a group of courses. So students in all (subject A, subject B, Subject C). Not students who are enrolled...
  2. T

    Show Form in Front

    I have a screen with two forms (one behind the other). To view the hidden form I have passed the focus to one of its textboxes. However, this does not bring it forward (in front of the other form). How do I force the form (using code) to come to the front. I could do a menu item but not too sure...
  3. T

    Warning Errors

    I am using 2010 Access. Usually I use the code: DoCmd.SetWarnings False to turn off the error messages. Now it seems to have stopped working. When I finish typing the word SetWarning I get the auto-option (WarningOn) and when I run the code there is an error. Has the setWarning property been...
  4. T

    Append without duplicates

    Hi, I am very frustrated. I have two queries: SelectAdditional SelectBasic I want to append the data in SelectAdditional without appending any records that already exist. First I am trying to select only the non-duplicate records. I have a query that reads as follows: Field...
  5. T

    Hi Forum Entities

    Just thought I would do the polite thing and introduce myself. I have some programming experience (in very old languages) and some Access experience. Its the subtleties that I get frustrated with when programming. They are not always intuitive. I'm using Access 2010. I prefer numbers which is...
Back
Top Bottom