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...

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?

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?

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?

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??

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 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...

I have a query listing those people who attended a training session. The query contains sessionid, attendeeid, surname. I want to be able to add up all of those present. I have tried putting "count" in and just end up with a series of "1". How can I get it to add up all of those who were...

I have a form with an embedded subform. The form has a firm and the subform shows employees at the firm used by us. I want to show the running total in some way or just have the numbers by the side of the columns in the subform. Is there an easy way to do this?

I have a database with firms and employees. In the header I choose a firm, in the main form the data about the firm is dispalyed and then in the subform I have a list of employees who are part of our project. The trouble is they don't come out in alphabetical order by surname which I need...

I have some reports that gather address data from a query. Some fieldds are blank (eg add4 and add5). How can I set up the report so that it doesn't leave blank line where there are blank fields?

I want to run a macro from a menu which opens a word document and runs a mail merge which gets its info from a query. I'm sure this is easy but can't find out how to do it. Any suggestions/examples? Many thanks

I have a form with a combo box in the header section and address etc in the details section. I want to be able to choose a firm from the combo box and then see the results below in the details part. It works fine, but when I open the form first of all there is data in the details section. How...