General

ciao
... 2 Jul 2008 16:01

Email Help
Hello, Here is the code I have behind my email button. So when a user is on a record from there they click the button and the email will pull the info from the selceted fields. Private Sub cmdSendEmail_Click() On Error GoTo EH Dim SendTo As String, SendCC As String, MySubject As String, MyMessage As ... 3 Jul 2008 12:30

Access 2007 Compact and Repair does nothing
Hi all, I have read several posts on this issue, but no one has replied with an acceptable work around. i have an Access 2007 database that requires a compact and repair (due to importing txt files) to be run on close. When I attempt to compact and repair the DB on the network, the DB size remains the same. ... 2 Jul 2008 17:03

Errors when opening Access 2003 file in Access 2007
I have run into several errors when trying to open an Access 2003 file in Access 2007. The first error I receive is when I try to open the database file. “An error occurred while loading 'ReportFileName'. Do you want to continue loading the project?” If I choose no then I receive this error, “The data... 2 Jul 2008 17:03

Run Excel macro with arguments from Access
I want to run an Excel macro from Access. This is the syntax used in Access : Dim xls As Object, xwkb As Object Dim strFile As String, strMacro As String strFile = "PERSONAL.XLS" Set xls = CreateObject("Excel.Application") xls.Visible = True Set xwkb = xls.Workbooks.Open(Macro_Path & st... 4 Jul 2008 00:49

Changing field type from Text to Memo..., any dangers ?
Hi all…, I'm about to change a field type from Text to Memo because I find I'm needing more character spaces that 255. Are there any inherent dangers in doing this ? Thanks in advance. DennisO ... 2 Jul 2008 16:01

Slow logon on a Multihomed server
I have a multihomed server, one NIC is connected to the server subnet and the second NIC is connected to a private and non-routable subnet ( 192.x.x.x ). I can logon very quickly using local Administrator account. But its extremely slow ( up to 2 min ) to log on to the Domain. Is there a way to work around t... 2 Jul 2008 14:59

System.mdw error
Good afternoon. I've got a user running Access 2002 SP3 on a Windows XP machine who receives an error that Microsoft Access couldn't find file C:\Documents and Settings\<profile>\Application Data\Microsoft\Access\system.mdw when trying to open a database stored in C:\Documents and Settings\All Users\Desktop. ... 3 Jul 2008 02:16

How to Handle Feb 28 and 29?
I have a database that triggers a table archive piece when the end of the month occurs. In the case of a leap year, I think that in the case of February the way it is currently written the actions are done on both Feb 28 and 29: If ((Format(date, "dd") = "28") And (Format(date, "mmm") = "Feb")) Or _ ... 2 Jul 2008 16:01

Pivot Chart View
I have a query that gives me hours worked for a employee and sums them up. It has 2 decimal places When I pull this query into the pivot chart view, it rounds up the daily hours and give me a completely different sum value. How can I prevent the pivot chart view from doing that? Thanks, Jasper ... 2 Jul 2008 13:57