Search results for query: *

Thanks, that was something I had overlooked. The pagefile has indeed been moved to the d:\ drive.

I have inherited a Dell Poweredge 860 system with SBS 2003. I have just noticed that it has been configured NOT to use a pagefile. It has 4GB RAM and is running ISA and Exchange for about 10 users with roaming profiles. The 25GB space on the c: partition is running very low (under 200MB free)...

I have been using MDBTask which is available from http://www.pb-sys.com in the retired products section. It's free and works well for me.

Thank You....works a treat

'TblMonth' has 2 fields: OrderRef, ProductNo 'QryOrders' has 2 fields: OrderRef, ProductNo I need to determine the records that DO exist in 'TblMonth ' but that DO NOT exist in 'QryOrders'. i.e. Find the records where TblMonth.OrderRef matches QryOrders.OrderRef BUT subsequently there is no...

I'm working on an XP machine was once riddled with spyware, and using a combination of AVG, HijackThis, Ad-aware SE & Spybot it now appears to be clean. Using IE6 SP1, I get the "Page cannot be displayed" the first time I open up IE. Once I close that window and open it a second time it works...

I'm struggling to pull one record at random when using a select query with a WHERE clause. Table = TblPlayers has 2 relevant fields: NAME & SEASON. I need to select just one RANDOM record WHERE the season="2004-05". I'm sure this is an elementary question, but I just can't figure it out.

I don't think that solution works. For some reason the Me.Pages value stays at 0 throughout the Pagefooter Format event for each page and only the Me.Page value increments with each additional page. Maybe this is just in Access2002? I too would be interested to see if anybody has any other...

Yes I've grasped the Printout function, but the question requires a command button on a customized toolbar that prints just the Current Page 7 times. It seems like a reasonable enough request and it will save users time in going through the the routine of Print--->Set Page From, Set Page To and...

I'm still struggling with this. There must surely be an easy way to capture the current page number in an Access Report preview?

UPDATE: I thought I had this problem cracked when I created a routine that fired when the Report Footer got formatted, but it only fires on the first view of each page and not subsequent views. The same thing happens for the Report Page event. Can anyone help? Surely there must be some way of...

I don't follow. This is a Report, not a Form.

I have an Access 2002 report that has multiple pages and contains a customized toolbar. The buttons on the toolbar run macros which call VBA functions using the Runcode command. I'm trying to work out a function that allows the user to print just the current page whilst in acviewpreview mode...

There is code posted at: http://www.mvps.org/vbnet/index.html?code/locale/localeenumtime.htm that allows you to retrieve all the regional locale settings. This might help you.

At last I've found the problem. After many hours of testing I narrowed the fault down to on commonly used report. I re-created this report from scratch in the exact same way and the problem went away. Unfortunately I have no explanation as to why this occurred.

Could it be a typing error? It's .visible not .visable

I've found the answer, the code at: http://www.slipstick.com/dev/code/quarexe.htm formed the basis of my solution.

There are several ways to do it, but perhaps the easiest is to leave the first form open and set the Control Source property of the text box to something like: =Forms!Form1![Combo1].[Column](1)

I'm trying to automate the movement of emails into specific folders in Outlook 2000 & 2002. The rules I would like to create would go something like this: Rule1: If an email is receive from 'abc@xyz.com' which has a .xls attachment then put it in folder 'Excel'. Rule2: If an email is receive...

I had difficulty in re-creating your problem, but the following code might work: Use the 'On Format' event of your Report's detail section: ---------------------------------------------------------- Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsNull(MyDate) = True...