Search results

  1. M

    Switchboard

    Private Sub FormIndividuals_OnClick() DoCmd.OpenForm "formIndividuals", , , , IndividualType = "Emp" End Sub Could someone help me. The above open method is not working. :(
  2. M

    Combo Boxes on Forms

    Linkage: Button to main Form Bump :o .............
  3. M

    Sub form to match main form

    Bump :o .............
  4. M

    Combo Boxes on Forms

    Can someone help me with the above? I have posted it in the MACRO section but I have had no response. An answer by 7pm today would be welcomed. Thank you in advance.:D
  5. M

    Sub form to match main form

    Bump :o.............
  6. M

    Sub form to match main form

    Bump :o .............
  7. M

    Sub form to match main form

    Could someone please help me with the following post please. Sorry I do not know how to transfer it to the Macro section. Many thanks. http://www.access-programmers.co.uk/forums/showthread.php?p=1166868#post1166868
  8. M

    Combo Boxes on Forms

    I have been playing around with a new FORM and I think the keys are the: - Link Master Fields - Link Child Fields If they are both set to INDIVIDUAL ID it seem to be working. However, the BUTTON COMMAND "TrainingRecord" does not list the above links :(
  9. M

    Combo Boxes on Forms

    All forms have been created from the tables so the sourse of frmTrainingRecord is tblTrainingRecord and so on... The tables are link by the Individual ID numbers. Individual ID numbers have been allocated to all Employees and Residents. Thank you for your patience I am new at this...
  10. M

    Combo Boxes on Forms

    Sorry by Combi Boxes I mean the grey BUTTONS (Form Control) on the right handside i.e. Training Record etc...
  11. M

    Combo Boxes on Forms

    I need the INDIVIDUAL ID of the employee on the screen to match the one on the Training Record.
  12. M

    Combo Boxes on Forms

    Here's the table (mixture of Empoyees and Residents): Sorry what code do you need? eg. I am looking for information on Doreen Grey (Primary ID = 1) When I click on the combo button on the right i.e. Training Records, the information on the screen does not belong to Doreen Grey. It belongs...
  13. M

    Combo Boxes on Forms

    Anyone? :o
  14. M

    Combo Boxes on Forms

    Hello, I have created tables and forms containing several combo boxes storing information about Employees & Residents: - Once I have found the Employee I need to check or add information on - I click on the combo box eg. Training Record but the information does not match the Employee. 1)...
  15. M

    Data duplication on report

    Thank you. I do need the dates though.. Is there another way around this or another way of presenting it i.e. in a calendar etc..?
  16. M

    Data duplication on report

    Could someone help me understand why data are being duplicated on my reports? I have created my first two reports based on staff SICKNESS and ANNUAL LEAVE. From the attached print screens: 1. Doreen Grey booked two periods of annual leave (refer to Annual Leave print screen) 2. I do not...
  17. M

    Find & Replace - Multiple Word 2007 documents

    I had forgotten to enable macro... However, it is still not working. Can you check if this is right? Sub DoReplace() Const Find1 = " company name " Const Replace1 = " GREEN GIANTS " Const Find2 = " service user " Const Replace2 = " Resident " I selected about 4 words documents and it went...
  18. M

    Find & Replace - Multiple Word 2007 documents

    This is a print screen from your document...
  19. M

    Find & Replace - Multiple Word 2007 documents

    Sorry :o I do not see a quoted section. It is blank/grey... See print screen attached. Sorry I have never used this feature before. Please kindly let me know what to click on exactly. Thank you. [/URL] Uploaded with ImageShack.us[/IMG]
  20. M

    Find & Replace - Multiple Word 2007 documents

    Not to worry. I am using the record feature of Macro and doing one document at a time. Thank you for your help.
Top Bottom