Search results

Hi all, Is there a way that I can have a form where I type a car registration followed by pressing enter or clicking a search button that will open another form to display the details of the person who owns the car and also the form you enter the registration does not save the registration you...

Alright guys, Got a bit of an urgent one here!! Basically I've been reading through lots of stuff and still cant' make sense of it alll I've got a form called "Vehicle sub form" and in there is the fields "VRN", "make" and "model" basically make and model are drop downs menus which get there...

The form opens up in a list that shows all related postcodes

Basically there is a button that open a new form to show records where the postcode fields match

Hi everyone, Basically I'm creating a database and what I have is a field called " Postcode" in a form labelled "Address" When you type in the postcode and click the search button it opens a new form, "Postcode lookup", with all the address associated to that postcode Is there a code so i...

what would the change be to run a macro instead

so i can enter the code in one form to open another form

Where do i enter the code so it works from any part of the database

Thanks can you explain why F9 is key code 120

Can anyone tell me if there is a code i can enter than when i press F9 on the keyboard it opens a form

When i typed that in, it opened the form but showed no results

F1 didn't seem to help me much But I tried "[ID] =" & [Forms]![Employee Details]![ID] and that did not seem to work

On the Openform option on Macro's what do I need to type in to get my form to open where the "ID" field from "Employee Phone Search" form matche the "ID" field from "Employee Details" form Cheers

Ok would you be able to send me a copy of the code i need Thanks

I have this code on the form: Private Sub Command31_Click() Dim strPassword As String strPassword = "Test" If InputBox("Please enter the password") = strPassword Then DoCmd.OpenForm "frmClient" Else MsgBox "Incorrect Password used" End If End Sub Is there anything i can change/add to hide...

On this subject is there away to make the password come up as **** rather than a visible password

Sorry I just worked out why, thanks for all the help

Here is a copy of the code: *Note the top line is highlighted yellow Private Sub Form_Open(Cancel As Integer) Private Sub Command31_Click() Dim strPassword As String strPassword = "Test" If InputBox("Please enter the password") = strPassword Then DoCmd.OpenForm "frmClient" Else MsgBox...

I did the code, click the button it asked for the password and then when I typed it in i got the error message: Compile error: Expected End Sub Any suggestions? Thanks

Where do I type this code into