Recent content by iainmid

  1. I

    email address from access to outlook

    I have a table contacts with field email which hold contacts email addresses. How do i create a command button so that on click it takes all the email address from the contacts tables and transfers them to outlook in the To: address field.
  2. I

    Combo box not passing Parameter to query

    Yeah i have tried that. Here is an example of what i have done on the form when you select nottingham from the combo box the report still runs as if you have selected Leicester
  3. I

    Combo box not passing Parameter to query

    I am having a problem using a combo box to pass over a parameter for my query. My query does not seem to be picking up the value from the combo box on the form. I have created a Contacts table within that there is a field City as a text box so the user can imput any value. I've created...
  4. I

    Using option group to open form with command button

    Cheers thanks a lot for your help
  5. I

    Using option group to open form with command button

    Cheers How do i code it so that the first two options open a form and the third option opens a report
  6. I

    Using option group to open form with command button

    Cheers for that it seems to have worked. What would the code be if i was to add another value to the option box. i had hoped it might be something like this but this doesn't work Private Sub Command9_Click() Dim strForm As String If Me.ReportOptions = 1 Then strForm = "Contacts" If...
  7. I

    Using option group to open form with command button

    I've checked the name and it seems to be correct. i've uploaded an example of what im doing if you can see where im going wrong
  8. I

    Using option group to open form with command button

    This is the code i have tried to use on click on the command button but a compile error keeps occuring Private Sub Command9_Click() Dim strForm As String If Me.ReportOptions = 1 Then strForm = "Contacts" Else strForm = "Main Menu" End If DoCmd.OpenForm strForm End Sub
  9. I

    Using option group to open form with command button

    I have an option group with two options form1 and form2. What do i have to do to use a command button to open form1 or form2 depending on the selection from the option group.
  10. I

    Using Combo Box in a Query to run report

    How do i create a parameter to use a combo box instead of just typing a value in my sql statement to run a report. I know you can do it from a combo box on a form that the parameter in the sql statement point to but i just want to do this from the sql query itself. This is the sql statement...
  11. I

    Search on form using mulitple fields

    How would i go about doing this using the search form i have setup. I have been using an sql query with the fields on my search form as parameters but this only works if you enter data into all of the fields. i need to somehow say if one field is null don't use in the query
  12. I

    Search on form using mulitple fields

    Hi Im fairly new to access and am trying to find out how to create a form that searches a table using multiple fields. I have Contacts table with the fields (Organisation, Address, Street, Town, Postcode, Telephone No, Main Activity, Secondary Activity). I have created a Search form which i...
  13. I

    Trying to create a count query

    when creating the summary query for my table how do i group the records by month because start date is in short date format
  14. I

    Trying to create a count query

    I have create these two count querys that count the no of booking in January and the other no of bookings in Febuary SELECT Count([Booking Order].[Booking No]) AS [CountOfBooking No] FROM [Booking Order] WHERE ((([Booking Order].[Start Date])>#12/31/2006# And ([Booking Order].[Start...
  15. I

    Count no of bookings in Jan and Feb query help

    im not to sure how to go about this are u able to explain further
See more
Top Bottom