Recent content by Graham Bucknall

I have a large database containing a variety of information about firms. I have 7 different fields each of which relates to a user type eg youth, women etc. I want to set up a query where the user clicks a button "Search by user type" and then another "box" opens up with a list of the 7...

Thanks Many thanks - I knew it was soemthing simple. It all works fine now.

user defined type not defined I tried the simple approach to send a bulk email to a list of people from a query and used: --- Private Sub Command0_Click() Dim rsEmail As DAO.Recordset Dim strEmail As String Set rsEmail = CurrentDb.OpenRecordset("qryEmailList") Do While Not rsEmail.EOF...

I am trying to set up a system to choose a number of criteria, run a query with them and then send a bulk email to those on the query list. I have been following through things from elesewhere in the Forums. The query works OK but when I choose the send email button I get "User defined type not...

I have a membership system which prints invoices, letters etc. When there is a page to print it always prints a second blank page and, when there is nothing new to print it still prints a blanl letter etc. Is there a way of stopping this?

Thanks for that. I have looked at some and it seems to help except I get small boxes instead of Carriage return/Line feed for the Chr(10)&Chr(13). Any ideas? If I use VbCrLf instead it just askes me for an input.

I have a table with the usual add1, add2, add3, town,county, postcode. I want a letter with the address at the top but withour blank lines if there is no add2 and add3 etc. Does anyone have any suggestion as to how I can do this? Many thanks

I work for a small charity in the UK. I need to write a fairly simple ordering/inventory system to keep trachk of our accounts. Does anyone know of a sample database which I could look at to start me off with some ideas?:confused:

I have a table with details including a field "email". I would like to be able to double click this field in a form and then the email programme would start with the address filled in. I think a macro might be the way forward. What would the macro be?

Where does this go? (Sorry - bit of a novice)

I have a form to list businesses. There is a button which starts an "add business" form but when I add a new business and save it does not appear on the original form. I have to shut down the form and restart it -refresh doesn't work. The original form is a tabbed form with firm details on...

I want to be able to compile my access database (I think) so that it will run as an executable and therefore keep the user away from the tables, code etc. How can I do this?what do I need?

Thanks for that.:) Sorry abotu being in the wrong section - I'd been going through different sections and thought I was in Forms!!

I have a form with a person's email address as a field. I would like to be able to double click on it and start Outlook with the email address in place. Is this possible, and if it is, how??

Thanks for that but how do I do it - is it by creating a macro and, if so, do you have a sample macro or the lines for it?