Recent content by crt052681
-
C
Count of records in all tables in database.
Is there a way to have a query pull all of the table names within a database and display the number of records in each table? The names, number of tables in the database, an number of records within each table will always be changing, which is why I wanted to use a Query to pull the information... -
C
Delete database before creating a new one
Nevermind... Kill(Filepath)- crt052681
- Post #2
- Forum: Modules & VBA
-
C
Delete database before creating a new one
Hey all, How can I delete a database (different form the database I am placing this code in) using VBA? Basically I am trying to replace DATABASE_A.mdb with a new database titled exactly the same (DATABASE_A.mdb). I tried using the CreateDatabase method hopeing that it would just replace the...- crt052681
- Thread
- Replies: 1
- Forum: Modules & VBA
-
C
Sending Email
Huh, weird. You think it might have something to do with the comcast account? -
C
Sending Email
Here it is. Private Sub Form_Load() Dim objOutlook As Outlook.Application Set objOutlook = CreateObject("Outlook.Application") DoCmd.SendObject acSendTable, "tblFireLog", acFormatXLS, "crt052681comcast.net", , , _ " Report Log", _ "Here is the monthly Log Report", False... -
C
Sending Email
I have been able to create a form that will send an email automatically when the form is opened. Tha problem is, the email will not actually send until I open Outlook. Any ideas? Thanks in advance.