Search results

  1. I

    Creating a letter in Word with records from Access

    That is where you stop using the MS Word interface to create your rule and start typing/coding your stuff. The code is hidden text which will be between these marks -->{ } . To view/edit this hidden text you hit alt + F9. Now you can do things like if this is x AND that is y then do this. Or...
  2. I

    Creating a letter in Word with records from Access

    Ok so for question 1 open your table in design view and then for the data type next to the title field select lookup wizard -->I will type in the values that I want then enter all your titles e.g. mr, mrs, miss dr etc in one column and your dropdown is done 2- if you are going to be using words...
  3. I

    Creating a letter in Word with records from Access

    I may be wrong, but I think where you're going wrong is that you finished the merge. You don't need to do that, thats what you do to create the actual letter from word, you're going to do that automatically form access. So go to mailings tab --> start mail merge Select recipient list Write your...
  4. I

    Creating a letter in Word with records from Access

    I'm not quite sure what you mean. Basically create fields in your table that cover all the info you need. So for a letter a good starting place would be: Title (this one you could create a lookup to give you a dropdown with options e.g. Mr, Mrs, Miss etc.) Forename Surname Address 1 Address 2...
  5. I

    Is there any way to link two separate clients?

    Hi, thanks for your reply, To be fair, the db doesn't need to know the nature of the two parties' relationship, just that there is one. Therefore either party could be the sole claimant, or add their partner as the secondary claimant (ideally at the click of a button). Their partner should be...
  6. I

    Create a front end application for an Access Database

    Hi mcalpine, Maybe I'm stating the obvious, but it sounds like you can do all this from within MS access. After creating your table, create a form for your table (essentially an interface showing one record at a time so its like you're working through the table row by row, viewing one record at...
  7. I

    Creating a letter in Word with records from Access

    you're welcome. good luck and let me know how you get on Sam
  8. I

    Creating a letter in Word with records from Access

    OK I found it. The code in VBA to do this is called a MergeSingleWord (I think) The module containing all the code to do this was written in 2001 by a guy called Albert Kallal, so all credit to him. I've attached the DB containing everything you need. What you need to do to get this to work for...
  9. I

    Creating a letter in Word with records from Access

    Hi pw4000, From what you're saying it sounds like you want to go to a particular record, click a button in your MS Access form and automatically have it open a MS Word file and fill it in for you, for the particular person you are viewing in access. If so, you are in luck! I had the same problem...
  10. I

    Is there any way to link two separate clients?

    Hi CJ_London, Thanks for your reply. So essentially I create a link table in order to have a many-to many relationship? 2 things about that though: 1 how will the db know to group parties A and B as husband and wife 2 in theory this means I can add more than 2 people to a claim. Also would...
  11. I

    Presenting a many-to-one relationship in forms

    I kinda built on this question in another thread (245101) if it wouldn't be too much trouble could you have a look? Thanks for everything Sam
  12. I

    Is there any way to link two separate clients?

    Hi all, uber noob has another question! Ok so I'm creating this database for a claims management company. Yesterday I learnt about making a many to one relationship between the claims and clients tables. Turns out its more complicated than that. Since I'm dealing with claims, a person may add...
  13. I

    Presenting a many-to-one relationship in forms

    Many thanks for the link pbaldy, works really well.
  14. I

    Presenting a many-to-one relationship in forms

    Thankyou for replies @pbaldy thankyou for reply. I follow up until the master/child bit. Is that the relationship between form and subform, without me changing anything, if so great :D Oh and congrats on becoming moderator, just saw it. @jdraw thanks for reply. you were both very fast! sorry...
  15. I

    Presenting a many-to-one relationship in forms

    Hi all, I am creating a database for a claims management company. They want a system where one customer can have multiple claims assigned to them. So as far as i know this means i need one table for the customer and all their details (tblCustomer), and another for the case (tblCase). I need...
  16. I

    Want Command Button Visible For Certain User

    Re: Help Hi Bob. I've quoted your message below. I followed your instructions. The only change I made was adding the speechmarks in red below to make it work. Set rst = CurrentDb.OpenRecordset("Select * From tblAuthUsers") It works brilliantly! The only thing is I would like the username...
  17. I

    Question Help needed with access mail merge

    Hi all, my name's Sam and I'd like to start my first post by saying thank you to the users of this forum, it's been so useful that I just had to join. My dilemma starts with me taking on a job which was supposed to be a simple mail merge (which I planned on doing from excel). This was made...
Back
Top Bottom