Recent content by ksj

So, a client with the ability to send emails from inside their Access database and have the fact that an email was sent logged to the relevant Contact record has asked if we can set it up so that when they send an email from Outlook, it also records it in the Access database, if it finds a...

Link to help I believe this function works. Googling by "business days" and "SQL Server" will turn up more solutions. http://www.sqlservercentral.com/columnists/sjones/businessdays.asp

Source Safe and Access Hey Adam - In Access 2007, the developer extensions are free and include the source safe interfaces. In Access 2003, there is an add-in. http://www.microsoft.com/downloads/details.aspx?FamilyID=2ea45ff4-a916-48c5-8f84-44b91fa774bc&displaylang=en I don't know that...

Total guess But since "User" is a Class in the DAO library, maybe it is objecting to your attempting to use it as a variable? Maybe try renaming the "User" variable in your code to something else, see if it still happens. But this is a random, shot-in-the-dark guess.

Thoughts on SQL Server The thing about linked tables is that you are introducing the ODBC driver into the mix. So you have SQL, the Jet engine, AND the ODBC driver to worry about. In my experience, using the ODBC driver causes an unnecessary number of page locks on the SQL server, and will...

export specification I'm sorry if I wasn't clear. You actually have to create an entire export specification and put it in that spot in the code. This article will show you how to do that in Office 2007: http://office.microsoft.com/en-us/access/HA012263071033.aspx?pid=CH100645741033 And...

On the unload event of the form, Do a me.MandatoryControl.SetFocus If IsNull(me.MandatoryControl) = True or me.MandatoryControl = "" Then ' or whatever your defaults would be... MsgBox "You must put a value in field X.", vbOKOnly, "Data Required" DoCmd.CancelEvent End If It will stop the form...

Erin, you need to create an export specification, otherwise it will use the default one (which uses a comma as the delimiter.) The argument would go where I put the words "RIGHT HERE" (in quotes, or set a string variable to it.) DoCmd.TransferText acExportDelim, "RIGHT HERE", td.Name...

You are missing an "s" at the end of the line, it should be On Error GoTo Err_ExportDatabaseObjects