General

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

formatting a date in a text field
In Access 2003, an import spec could be set to recognize 8-digit fields as dates. Interestingly, Excel 2007 still can import them correctly. I wonder why Access 2007 forgot how? "John W. Vinson" wrote: On Mon, 25 Feb 2008 11:09:02 -0800, dchristo <dchristo(a)discussions.microsoft.com> wrote: I ne... 2 Jul 2008 12:55

Custom Tabs
I've created a custom tab on the ribbon with design view, datasheet view and form view. All three appear when there are not any security settings, but when I apply the security settings form view disappears. How do I get form view to reappear when the settings are applied? ... 2 Jul 2008 12:55

Pausing VBA Execution Until Form Closes
All - I have a form where I want to launch a report. I have another form where the user enters the date range for the report. Once the parameters have been entered, I'd like to have the form close and open the report. My question is...is there a way to pause the VBA call of opening the report until the da... 2 Jul 2008 14:59

Partial Matching issue
Hello, I am trying to have Access pick out and match the last 2 characters of a 5 character field entry so that I can assign a seperate value via query. Here is my current query: SELECT tbl_PayRates.Rate_Code, tbl_PayRates.PayRate FROM EDVR, tbl_PayRates WHERE (("Where [tbl_PayRates].[Rate_Code]" Like [EDVR].[A_... 3 Jul 2008 19:43

Find and replace ?
I converted a database and it changed all single quotes to question marks. I need to do a find and replace, but when I put in ? it thanks it's a wild card. How do I do a find and replace to look for a question mark? ... 2 Jul 2008 16:01

Multiple users, how can users view only their entries
I have a databse which has been split. I have about 6 users and I want to tailor their front-end forms so that when they browse back through their records (which, in this case, is done on the same form they enter data on), they can view onyl their information. How do I tailor a front-end form to view only rec... 2 Jul 2008 16:01