Recent content by Nats

  1. N

    Create mail merge from Access

    njaree, Thanks for your help. The only thing is I more wanted to do an email mail merge straight from access or outlook using my database - do you know if there is anyway to do this? Thanks Nats
  2. N

    Create mail merge from Access

    Hi, I have an access database and was hoping someone can advise me on how to create a mail merge from the access database, so that I can send emails that are personalised. Thanks :)
  3. N

    Making the selection in a combo box stay.

    Hi everyone, I have created a combo box in my form, the options for the combo box are coming from a table. It all works fine expect for some odd reason, when I click on an option in the combo box then come out of access, when I go back into the database the one I had chosen has gone. Do you...
  4. N

    Adding a photo

    Hi guys, I have created a database but would like to insert a different photo into each person files. Please would you be able to run me through the steps of how to do this. I look forward to hearing from you all soon. Many Thanks :(
  5. N

    How to stop rounding numbers down/ up

    Hi Guys, In my form I have a couple of text boxes that you enter numbers to, one is set at '£' with 2 decimal places and the other at 'general' with 1 decimal place. The trouble is in the '£' box if I type £9.33 it automatically changes it to £9.00 and then in the other text box if I put in...
  6. N

    Changing a Password

    Hi Guys, I have set a password on my access document but now need to change it - does anyone know how to do this? Thank you in advance for your help. :(
  7. N

    Updating a query, when still in the form

    I have 2 fields in a form called 'Employee No's' which use a combo box (this information for these comes from a query). However, I have another form called 'Employee Details' (this form comes from the same table as the query is taken from). The 'Employee No's' form opens by a command button in...
  8. N

    Updating a query

    I have 2 fields in a form called 'Employee No's' which use a combo box (this information for these comes from a query). However, I have another form called 'Employee Details' (this form comes from the same table as the query is taken from). The 'Employee No's' form opens by a command button in...
  9. N

    Updating info in one form, so it shows in another coming from the same table

    Thanks for your help on this. I have had a look at my 'record selector' in the second form and it is already on 'yes' and on the first form. I went into the form did 'design' then clicked 'properties' then went to 'all' and down to 'record selector'. Is this what you meant? Would you mind...
  10. N

    Updating info in one form, so it shows in another coming from the same table

    I have created one main form called 'Employee Details' which comes from the 'Employee Details table'. I have also created a second form which has a field called 'Employee No' this field is a combo box (the information for this combo box comes from the 'Employee no' field in the 'Employee...
  11. N

    copy data from a column in one table to a column another.

    Please would you be able to advise me how I would copy data from a column in one table to a column another table. But I need to only use table not a query. Thank you in advance for your help.
  12. N

    Linking records from two tables

    Thank you for the response - just need to be able to add records in either of the forms and then I'm off and running. I presume that it will be possible to do "drop down" lists within the forms without creating duplicate entries? Please can advise? Thank you in advance for you help.
  13. N

    Linking records from two tables

    Thank you for the response - just need to be able to add records in either of the forms and then I'm off and running. I presume that it will be possible to do "drop down" lists within the forms without creating duplicate entries?
  14. N

    Linking records from two tables

    Thank you - getting there but whereas you have got a number of products being subform of a Product Type I also need Procuct Types to be a subform of Products - without duplications. Might make more sense if you were doing customers and products. Customers interested in a product and the same...
  15. N

    Linking records from two tables

    Can you please elaborate a little, please? I need to be able to link a number of existing records in one table to a new record in a different table. What I want is a subform showing all the records that are associated with the main form record and vice versa
Back
Top Bottom