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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Report based on records updated today
Thanks!!! I checked, and the CDO reference was missing on the NT workstation - it works fine now...- encode
- Post #3
- Forum: Microsoft: Access Reports
-
Report based on records updated today
Hi all, I am currently working on a 'Daily report'. When a record is updated using a form, the date it was changed is added to the record. That part works fine. The difficulty arises when trying to do a report. The sql query I had been using uses the where statement to filter by date, as...- encode
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
-
After update error using mde file
Darrylles - thanks for your help. I just finished fixing the problem - and you are right - it was a problem with the after update event on the subform!!! :)- encode
- Post #3
- Forum: Microsoft: Access Forms
-
After update error using mde file
Hi, I'm developing a form for a database. The After Update event code is shown below: Private Sub Form_AfterUpdate() On Error GoTo Err_Form_AfterUpdate Dim AlreadySent As Long Dim day, month, year As String Dim Today As Date Dim Subject, msgtext, Name As String day = Format((Date)...- encode
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
How to code export of report
Hi, I'm fairly new to this sort of stuff. I'm trying to automatically generate a snapshot file of a report, and then attach it to an email to send to multiple recipients. The report is already created. Any help would be appreciated. Thanks.- encode
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
