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

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

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

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

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

Can some tell me how I would go about putting a password on a form when someone tries to open it The form name is "Employee Details" and also where would I set/change the password Many Thanks Ben

Hi, How to I go about creating a Male/Female radial button so it can only select one or the other and not both Cheers Ben

Hi, Basically I need to design a form based on another table/form all I need to do is take 3 fields from a table/form called "Employee Details" the 3 fields I need are: "ID", "First Name" and "Last Name". When the first and last name are typed in I need the ID field to auto populate with...

Hi Guys, I know I'm being an idiot here but my brain has gone dead on me. I got job numbers that I need to auto populated with the format for the first number being "NRN12001" and the next one following "NRN12002" so really need to know what I need to change in the design view of the table...

Hi guys, Basically what the issue is I have a form called Header Managment that has the fields: address, phone and web . What I need to do is display each of those fields on a different completely unrelated form. So the generally idea, if the address, website or phone number change I only...