Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by JeffChr
-
Relationships / Ref Integrity
OK - that makes perfect sense. Guess that's the way to do it. Thanks for your help!- JeffChr
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Way of referring to a previous row in a table using vba?
I think some clarification is needed. Are time1 and time2 fields in a table or variables in code? And how are time1 and time2 set?- JeffChr
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Relationships / Ref Integrity
I gave that a thought. However, I am writing this for end-users who may unwittingly delete "Unassigned". If I manually turn-off RI, everything works. But I don't think RI can be turned-off/on using code.- JeffChr
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Relationships / Ref Integrity
I am using code to add a record to a table - CUSTOMERS. CUSTOMERS is related to table SALESREP by a (SALESREP) one to (CUSTOMERS) many, on field REPID. I can't figure how to indicate that although a relationship exists, there does not have to be a REPID in the CUSTOMER table. I get an error...- JeffChr
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Default Value on a form not working...?
It could be this simple: From the BeforeUpdate event for the data entry form build code similar to this: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Computer = MachineName End Sub "Me" references the open form "Computer" references your field, which I assume is the field name of...- JeffChr
- Post #2
- Forum: Microsoft: Access Project (ADP)
