Create Form from Query

[adam]

I’m trying to create a form by creating a query from two tables when the form would have all the fields except the field "lngEmpID"

But I’m unable to create either a query or a relationship from both of the tables to create the specified form.

What is that I'm doing wrong in here?

[HansV]

There is no reason to use two tables here. Place all fields that you need in one table.

[adam]

Thanks for the reply Hans.

Based upon your suggestion I’ve created a form to add and created logins for employees.

I have two text boxes for a user to add password where one is to create and the other is to confirm.

How could I create a message box which would say “The passwords do not match please type again” when a user mistakenly retypes a password that does not match the initial ?

Note: when the database is open it first shows a splash screen and then the login dialog. Pass for any name is 12345.

[HansV]

Your form frmLogon contains only a single text box...

[HansV]

Sorry, you mean the form to add a new employee. Create a Before Update event procedure for the form:

Code: Select all

Private Sub Form_BeforeUpdate(Cancel As Integer)
  If Me.strEmpPassword <> Me.Confirm_PassWord Then
    Me.Confirm_PassWord.SetFocus
    MsgBox "Passwords do not match!", vbExclamation
    Cancel = True
  End If
End Sub

[adam]

Thanks for the code. This version does not open up the splash screen automatically. I've exported the tables and forms to the database "DateQuery". Is this because of that?

[HansV]

No, it's because no startup form has been set.

[adam]

How could it be done? According to me no code had been changed.

[HansV]

There's no code involved.

Click the Office button in the upper left corner of the Access window.
Click "Access Options".
Select "Current Database" in the navigation pane on the left hand side.
In the "Application Options" section, "Display Form" is currently set to (none).
Select the frmStartup from the dropdown list.
Click OK.
Next time you open the database, frmStartup will automatically be displayed.

[adam]

Thanks for the help Hans. It does open now.

[HansV]

It does open now.

Of course!