Search results

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

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 :)

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

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 :(

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

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

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

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

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

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

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.

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.

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?

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

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

How do you link the contents of certain records in one table to the contents of one record in another table and vice versa. Needs to be visible in form view

Hi guys, Please would some be able to help me? I have created a query (its a holiday chart). The table the query is created from shows dates taken in each of the 12 months under the 'month name' column and then in the next column it has the total for each of the individual month. For...

I created a form a little while ago, how I have recently added a couple of columns to the table that the form gets its information from. The only thing is it will be a lot of hard work to re- create a new form - from my table, so I what I need to do is go into design view and add two more...

Please would someone be able to help? I am working in access and I have a main form, which has a subform. When creating the subform I made the search between say 'field 1' of the main form and 'field 2' of the subform. However I am now adding another field to the table which my subform was...

Chergh - Thank you so much Chergh It worked! Just want to say a massive thank you to you. You are a genis! Thanks Nats