Search results

I just want something to go in here where is says "need code for here"

Hi all, i have table with a renewal date such as 10/10/2009. I need a query which will return all the policys that are 10/09/2009.. so basically a month before they happen. I just need to know the code to go into the search Criteria. Thanks :)

lol whats the dlookup method then?

excellent thats amazing :) My degree is in international business management and when i saw a module called "database systems" i though hmm how hard can it be.. haha how wrong was I!! One problem. It returns the "correct" if its correct, but when its wrong is doesnt return the "wrong" it says...

thanks rabbie i really appreciate the help. It not longer gives me the error message, but it always gives me "wrong" even if the username and password is correct. If i tell you my table layout maybe you could see where i have gone wrong.. The table is called Agent. It has 2 fields one called...

ok so iv changed my text box names to: usertext and passtext and then i tried this: Dim sqlpassword As String sqlpassword = "SELECT Password FROM Agent WHERE Username=Me!usertext" If passtext.Text = sqlpassword Then MsgBox "correct" If passtext.Text <> sqlpassword Then MsgBox "wrong" But...

I have changed the text box names to: usertext and passtext And then iv tried this: Dim sqlpassword As String sqlpassword = "SELECT Password FROM Agent WHERE Username=Me!usertext" If passtext.Text = sqlpassword Then MsgBox "correct" If passtext.Text <> sqlpassword Then MsgBox "wrong" But i...

Ok iv had a look and i really dont understand it. Would you be able to run through the code with me? What each bit does and how? On Error GoTo Err_cmdLogin_Click 'Check username text box If IsNull(Me!txtUserName) Or IsNull(Me!txtPassword) Then MsgBox "Please enter a valid...

Hi. I have a database with a table called Agents. In this table are the agents Username, Password, Name, Address etc I want a form so they can login using this data. So for example in my table i would have: Adamsmith, Pass, Adam Smith, 22 Street. On my form i would have Username: (text box...

Hi all. i have been given this as homework, but the teacher is usless. She's teaching an access course, but went herself on an Access course 2 weeks ago in the middle of term lol shouldnt she already know this? Well anyways I went to see her 2 days ago and actually had to visit her office 7...

so it would look a little like this: Company table(Company id, Business type(forign field), Product type(forign field), Name, addres...) Business table(Business type,) Products table(Product type) ???

Sorry i should have said, yes this is homework. But the teacher isn't really the best.. i mean she went on an access course 2 weeks ago to learn access, keeping in mind that 2 weeks ago was the middle of the term lol I have Attached a photo of my relationship diagram so far.. but i think its...

Hi there, i have been given this description of a database that needs to be created, but am getting very confused as to what tables and Primary and forign keys i need to be using in the tables. "An insurace agent deals with a number of insurance companies. A policy-holder may have a number of...