Search results

  1. V

    Volunteer needs help with Select Statement

    I have tried both of your comments but i can not get them to run. I have put the code in red which I want to display in the reoprt. Option Explicit Function BuryPostCode() Dim dbs As Database, rst As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT [First Name], " _ & "[Last...
  2. V

    Volunteer needs help with Select Statement

    Sorry, I want to add all the above post code's into the statement. Can you show me how to do this Thank You
  3. V

    Volunteer needs help with Select Statement

    Hi All, Can you help with the following! I want to extract different post codes from a table. i.e BL9, BL7, M25, M26 etc I can get the following code to produce a report for BL7 but don't know how to add the other ones. Can anyone help please as I am doing this for a Charity and a bit...
  4. V

    Volunteer needs help with select statement

    Thank you all for your help and support. The following code now works Option Explicit Function BuryPostCode() Dim dbs As Database, rst As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT [First Name], " _ & "[Last Name] FROM [Members Contact Details];") dbs.Close End...
  5. V

    Volunteer needs help with select statement

    did not work Paul
  6. V

    Volunteer needs help with select statement

    Here is what i have up to know from the following posts Function BuryPostCode() Dim dbs As Database, rst As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT [First_Name], "_ & "[Last_Name] FROM [Members_Contact_Details];") dbs.Close End Function...
  7. V

    Volunteer needs help with select statement

    The code that is not working is as follows Set rst = dbs.OpenRecordset("SELECT First_Name, " _ & "Last_Name FROM [Members_Contact_Details];") Its not recognizing this command and i don’t know why as the table exist and i have taken out the underscore and replaced with spaces
  8. V

    Volunteer needs help with select statement

    Now i get a defferent run time error as follows Run time error 3061 too few parameters, expected 2 any ideas?
  9. V

    Volunteer needs help with select statement

    Here is what i have Option Explicit Function BuryPostCode() Dim dbs As Database, rst As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT First_Name, " _ & "Last_Name FROM [Members_Contact_Details];") dbs.Close End Function Private Sub Command4_Click()...
  10. V

    Volunteer needs help with select statement

    By the way there are spaces between the words, i have tried [] but still does not run
  11. V

    Volunteer needs help with select statement

    I have tried both your examples but unfortunatly non of them did run. I am still getting the same error message. Can you help further
  12. V

    Volunteer needs help with select statement

    Hi all, I am creating a database for a charity in the UK and having a problem with the following Select Statement. As you can see I am only selecting the fist and last names. I am kind of new to this so any help would be appreciated As I run the code an error message appears as follows...
Back
Top Bottom