Hello everyone,
How do I query only the max date to show up on the database with 2 or more contacts.
I have this query but it will show all record regardless of the follow update. I only need to show the up to date follow up date not the previous date. Any help will do.
I try the...
Hello everyone,
I have this SQL Statement:
'Add record to first table contact to print the First Contact Letter
DoCmd.RunSQL "INSERT INTO tblFirstContact (LName,Address,Address1,Address2,Address3,City,Province,PostalCode," _
&...
hello I have2 table tblClient(main) and tblActivity.
tblClient has the following fieldname.
PolicyNumber -> Primary Key
Name - Text
Closed - Y/N
tblActivity
ActivityID - Auto Number
PolicyNumber - Integral relationship to tblClient(main)
Comments - Memo
Paid - Currency.
Now how do I move...
I'm getting syntac error on this RunSQL
DoCmd.RunSQL "UPDATE tblCollectionsData Set tblCollectionsData.ContactMain = 1 WHERE (tblCollectionsData.PolicyNumber) = " & rst![PolicyNumber]
...Dim LetterMessage As String
Dim stDocName As String
Dim StrSql As String
Set dbs = CurrentDb
LetterCount = DCount("*", "qryFirst")
* Set rst = dbs.OpenRecordset("qryFirst") *
DoCmd.SetWarnings False
If LetterCount = 0 Then
MsgBox ("You...
I could used a bound form but I just wanna give it a try first using the ADO if its the best route especially the data are access by quite a lot of people.
....Open
End With
Set rs = New ADODB.Recordset
With rs
Set .ActiveConnection = cn
.Source = "SELECT * FROM tblCollectionsData"
.LockType = adLockBatchOptimistic
.CursorType = adOpenKeyset
.Open
End With
Set Me.Recordset = rs...
Here's final code
Private Sub txtExpDate_AfterUpdate()
If IsNull(Me.txtExpDate) Then
Exit Sub
ElseIf CDate(Me.txtExpDate) < CDate(Now) Then
MsgBox "Expiration date entered should be greater than date today", vbInformation, "Lunch Voucher"
Me.txtExpDate = ""...
Hello everyone,
For some reason the txtExpDate_AfterUpdate()
does not carry the date to next record. If date is entered manualy will work but if I choose the date from the form Calendar thats pop up when click doesn't carry the value to next record. Any Ideas.I try everything and seems not...
I need help on expression builder on the report.
Needs to reformat the output for policy number when opening the "credit" report.
the field strPolicy on table is showing like this 601234567
Output on report if strCompany = "A" then
strPolicy = 1234567-60 Else
strPolicy 60-1234567.
I'm not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.