Private Sub FormIndividuals_OnClick()
DoCmd.OpenForm "formIndividuals", , , , IndividualType = "Emp"
End Sub
Could someone help me. The above open method is not working. :(
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
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
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 :(
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...
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...
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)...
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...
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...
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]