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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: datatech7F
- Order by date
-
Editing my email message
Or use & chr(13)- datatech7F
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need to update the table with new values
UPDATE BlackBerry SET Model = '1' where Model = '950'; then... UPDATE BlackBerry SET Model = '2' where Model = '957'; I don't believe it can be done in one SQL statement, unless you wanted to go VBA... Set dbsThis=currentdb Set rstBerry = dbsThis.OpenRecordset("BlackBerry") With...- datatech7F
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
test for empty dataset
Use the .recordcount property. Also, be aware that if you're using DAO rather than ADO, you'll have to .movefrist .movelast in order to get an accurate count (old DAO bug, but if you're only workgrouping or running local, it's less overhead than an ADO connection).- datatech7F
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Opening a Word document from Access?
I've had better luck storing the path info for the docs in question in a text field, then using the CreateObject trip to make an instance of WinWord, and append the field holding the path to its .Documents property. Since you're already using an autonumber as the key, you can use sripting...- datatech7F
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
Automatic E-Mail to Outlook
This function exports an Access report to a *.snp (snapshot) and emails to all addies in the RECIPIENTS table Function MailDaily() Dim dbsThis As Database Dim rstSel As Recordset Dim rstRec As Recordset Dim olApp As Outlook.Application Dim olNameSpace As NameSpace Dim olFolder Dim olMail As...- datatech7F
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
