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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Return a message if no records found
The database is in a product from Addamark Technologies. Basically it is just a log collecting and correlating tool. They use a some proprietary SQL commands, but for the most part it is standard SQL. I'm not sure what you mean by running the query in the prompt, but here is the query if that... -
Return a message if no records found
Is it possible to return a "No records matched your query" message or something similar if no records are found? I have a query that pulls failed authentications from log files, but there is not always data. It would be nice to see a message instead of just 0 to know that the query did in fact... -
Editing records in a table
I am having trouble editing records using a form. When I open the form, I get a complile error for rec.Edit. Here is the code: Private Sub Command0_enter() Dim dbs As Database Dim rec As Recordset Dim strTable As String Dim intLength As Integer Dim strNewID As...- Dohhh
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
