MsgBox won't display custom fields 1

[bvbowes]

After inserting records from Oracle into a table in Access I want a msgbox to display the count of records inserted. I thought this would work and it doesn't, what am I doing wrong?

daily_count = "SELECT Count(tblDaily.VENDOR_NAME) AS Count From tblDaily"

MsgBox "Daily table import has completed! & daily_count & ", vbOKOnly, "Import Status"

 

[PWise]

try

daily_count = dCount("*","tblDaily")

MsgBox "Daily table import has completed! " & daily_count ,vbOKOnly, "Import Status"

 

[bvbowes]

you da man pwise...

 

[MajP]

Public Sub dailyCount()
Dim daily_count As Integer
daily_count = DCount("Vendor_Name", "tblDaily")
MsgBox "Daily table import has completed! " & daily_count, vbOKOnly, "Import Status"
End Sub

 

[MajP]

Sorry, a little late.