Search results

  1. E

    Make a report the same as form and sub using mail merge

    I think report would be fine if I can make it look the same as my word document template which I should be able to do. What kind of VBA code do I need or is there somewhere I can read up on how to do this?
  2. E

    Adding info from form to report or word document

    Hi, I'm trying to add the information from a form and subforms to a report. This would be a medication mar sheet and needs to be in the format of the attached word document. I'm happy to do it in a report and change the formatting if that will work better. The personal info needs to go at...
  3. E

    Make a report the same as form and sub using mail merge

    Hi, Just wondering if this is possible. I am using mail merge to add info from my database to my word document template. I want to make it the same as my form I have set up which gives me a patient name, dob, GP details as head of main form then a subform (continuous) of their medication. When...
  4. E

    Append only the last row

    Ok is there a way to append only new last row. ie. unique numbers and not two of the same. I have the query running on a button and if the button is pressed without data inputted it will add the last row again. Not a major problem but trying to find a way of not letting the end user mess it up.
  5. E

    Append only the last row

    My lord I am in love with you!. Thanks so much. I've tried to sort that out for hours!!:D:D:D
  6. E

    Append only the last row

    Hi, Newby here to here and access really! I have an append query and want only the last row (Unique ID) to be added rather than the whole table. Is it do-able? Here is the SQL... INSERT INTO TblCoursesRebooked ( StaffCourseID, Course, [Date], Staff, [Renewal Date] ) SELECT...
View older results
Back
Top Bottom