Search results

  1. A

    Order forms

    Hi I have created a system for a client who has been using many spreadsheets until now and feels there are too many errors this way. There are two tables. One for the weekly orders and one for the monthly flour orders. I have made an order form which the user should be able to put in customer...
  2. A

    Macro button to mail merge info

    Thanks for your response. I am trying to create a labels from the tables in access and wanted a macro to do this. What would you say is the best way to go about this?
  3. A

    Macro button to mail merge info

    Hi thanks for your response, Yes please!
  4. A

    Macro button to mail merge info

    Hi I have a form that I would like to have the option to mail merge the information to word document. I want a macro button to dot his. Could you tell me the correct way to go about this please? Many thanks Abigail
  5. A

    How to make a switchboard

    Thanks for that! Is it possible to link tables and queries as well as forms onto the switchboard? I made a hyperlink but I am sure there is a more sophisticated approach?
  6. A

    How to make a switchboard

    Thank you for your detailed responses. Perhaps I wasn't clear enough or i didn't understand your instructions. I have a database screenshot below. Instead of the user having to find the table, form, report or query that they want, I want a main menu page with links to the table, form, report or...
  7. A

    How to make a switchboard

    Hi I would like to create a main menu page that would be the first thing the user sees when opening the database. Instead of having the use open the tables, queries, forms and reports from the navigation pane, I want links on a main menu page to these so that the user has easy navigation. Could...
  8. A

    How to make Parameters

    I have a number of tables in my database and I am trying to create a query to have a question come up upon clicking it asking a clients name. Once the name is entered, their details from the numerous tables should come up. Would you be able to give me guidance on how to do this please? Many thanks.
  9. A

    Quickest method for adding order preferences

    Thanks for your support. This is a screenshot of the price list. Each person gives in their order to the company by paper. This is a screenshot of a sample of the orders. The secretary uses the VLOOKUP formula to link their order with the price. The name of each client goes at the top each...
  10. A

    Quickest method for adding order preferences

    Hi there. I have an client who wants a method of adding their clients orders to a list in alphabetical order which they will then print out for their records. Currently, they use Excel and sort it manually. This method obviously has numerous human errors which they would like to reduce. The...
Top Bottom