I notice that my form "jumps" when I use a tab. It's odd, as I have other
tab combinations on the same screen that don't. In this case each tab opens
a subform. The tab use that does not jump opens simply a series of text
boxes...

can anyone send me a sample of form about creating username and password for
forms?
or any instruction how to create it from MS Access?
thank you

In vbCode how do I set a listbox so that a particular
row is selected ,  eg the first row, whatever  the value
is.

This code does not seem to trigger. Any ideas why?
The fields are text feilds formatted dd/mm/yy
I assume this may be my problem.
Any recommendations on how I can get this to work?

I have a database with it's very own "system.mdw" file.
All security has been set, and without this file you can not open the
database.
This database has a front end that users install on their workstation, and a

i have a yes no msg box that displays the msg "did the quote print?" on
pressing yes it performs a number of actions. When i press no i want it to
loop back to the begining of the function.
Anyone have any ideas??

I have a subform (sfrmPKProfilesQualifications) that's used in multiple
subforms. The problem I have is that there are instances when
sfrmPKProfilesQualifications will have a record and it's parent subform will
not. Of course, this results in the error:

I have attached below some VB code i am using on the on click property of a
button on one of my database forms.
When i run the code and compare it against the log in and log out times it
gives me the wrong answers. For example if the log in time was before 11:00am

Does anyone know a workaround to prevent that annoying Microsoft security
message from coming up when clicking on a hyperlink in Access? We're using
hyperlinks to open a user help file in internet explorer. We want to still be
able to use this file but without the security ...

The following are  a couple of lines from a code in my form:
Dim TableTemp As Integer
Dim varX As Variant
TableTemp = Int((100 - 1 + 1) * Rnd + 1)

I have a button, that upon pushing is supposed to fill other fields in from
the subform....
1. It worked at one point- and now it won't!
2. is there a better way to do this?

I recently had a new server installed and now the event procedure doesn't
work like it did before.  What could have effected the procedure?
It actually performs a portion of the routine (creates 6 new numbers) and
then stops.

I have been pulling my hair out on a simple problem.  Hoping someone here
has the anwer.  I am trying to sort a field on a form by coding it's "on
open" property.  The field is a combo box.  Here is the code:
  Me.OrderBy = "Occurrence ASC"

I have succesfully used microsofts code to password protect a form, but when
applied to my own database I get a compile error for the type Database!!
Coding Line is:
Dim db As DataBase

Is there FAQ for access 2003 security, same as the one for 2000 - I wasn't
able to find it.
Also, does 2003 have some sort of password caching?  I logged in as admin,
and it doesn't ask me for my password anymore.  How can I logout and try to