Search results

Hi Recyan That code is cute. A great idea to use the count. I wish I had thought of that!:D

: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...

Thanks, I was thinking the same thing. I did notice however that if I open an open form it will come to the top without an error message. That's another way around it if the user wants to see part of the form as well as the switchboard.;)

The form is not deliberately hidden for any reason than there is not enough room on the screen for both forms. The first form 'Switchboard' holds the options that open other forms. However, when a user is in a form and wants to return to the switchboard (which is still open) the user either has...

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...

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...

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...

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...