LEARN MS-ACCESS TIPS AND TRICKS |
|
| Listed in | Programming on position 10 and overall rank is 2190 |
| Country | Oman |
| Language | English |
| Owner | aprpillai |
| Member Since | December 28, 2007 |
| URL | http://www.msaccesstips.com |
| Pagerank | 0 |
| Tags | tutorials | dbms security | asp | charts | mailmerge |
|
|
|
Latest Posts on: LEARN MS-ACCESS TIPS AND TRICKS
Retrieved latest 5 posts at: http://msaccessblog.blogspot.com/atom.xml
SharePoint and Access: How do they fit together?
Access and SharePointIf you’ve been working with Access for a while, it’s hard to miss the push Microsoft has been putting behind SharePoint integration with Access. The integration started as early as Access 2003, continued through 2007 and has blossomed with 2010. Without question the number one feature in the latest release is publishing you..
Posted on 16 June 2011 | 2:00 pm
Criteria for the current month in a query
The other day I needed to create a query where it returns all records with dates for the current month. I did not want to hard code the beginning and ending dates in the query, so I came up with the following line of code you can paste into your query:Between CDate(Month(Date()) & “/1/” & Year(Date())) And DateAdd(“m”,1,CDat..
Posted on 10 June 2011 | 1:43 pm
How to create Outlook message from Access
Note: If you need to send out a massive amount of emails this code is not for you, instead we recommend FMS’s Total Access Emailer.Note 2: You must add a reference to Outlook in your Access project in order for this code to work, if you need an alternate version that does not require it then look at the next section of this post below:Dim objOutl..
Posted on 10 June 2011 | 1:42 pm
Power Tip: Use the Form property when referencing subforms in your code
Form variables can make your code sizzleI love using form variables. They make my code faster and easier to read, and they also provide a great way to remote control another form without being on that form or having it be the focus. Another advantage is that reading record values off a form is far quicker than using a recordset using a table off th..
Posted on 26 May 2011 | 4:59 pm
Custom OpenForm code - Close and open your form
One of the major issues with DoCmd.OpenForm is it doesn’t close the form before opening it again. This can lead to unexpected behavior of your application, so of course I created my own open form code:Public Function OpenMyForm(strForm As String, Optional DataMode As AcFormOpenDataMode, Optional WindowMode As AcWindowMode, Optional strWhere As St..
Posted on 26 May 2011 | 4:36 pm