Search results

Hi all, Looking for some help with my access code. Hopefully I can explain this. I have a DB with some dates tracking contracts - ContractEffectiveDate and ContEndDate and then a dollar amount assigned to this for the year of the contract. I have worked out a calculation that determines the...

Hi All, I've done some searching and haven't been able to resolve this one, hoping someon ecan help or point me to a site. I have a Module that all my email automation code is included in I can send an email and all works great. What I'd like to do is include some details from the current form...

Hi All, I'm trying to create a command button that opens a second form and when the second form opens have a matching condition. So basic code would be Private Sub cmdOpenfrmContacts_Click() Dim strWhere As String strWhere = "[Contact] = '" & Me.Contact & "'" 'Open the form...

Hey all, I have an odd situation with some code I have for an Alpha Numeric autonumber field The below code looks at a field determines the highest number, which is in the last 4 positions and then returns the next value- 'autonumber Private Sub Region_AfterUpdate() If Me.NewRecord Then...

Hi, So I'm trying to work out some issues in my db related to using the example that GHudson posted here: http://www.access-programmers.co.uk/forums/showthread.php?t=38364&highlight=Mouse I have two fields on my form that use a DLookup to retrieve a calculated value from a query. When I use...