Search results

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?

I have a form for editing some details of firms (combo box in header etc). When I open it from a switchboard there is always data in the main fields (not the combo box). I don't want to add a new record but I would like it to be blank ready for me to choose the firm I want from the combo box...

I can't get at design view. If I change the printer from the network one to a local one it works fine. Put back the network one and nothing will open in design or any other view.

I wrote a database which worked fine. We have just had our server changed and a new printer. Now it wont print or preview - it just comes up with an error "There was a problem retrieving printer information for this object. The object may have been sent to a printer which is unavailable." I...

That worked fine - many thanks.

What I want to do is to produce some totals on a subform. I have set up a form with a subform. The main form allows an event to be chosen and shows details of that event - date, title etc. In the subform below there is a list of those who are goint to attend the event. I want to see a running...