Search results for query: *

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)...

'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 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...

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 have the code to automate the saving of attachments for emails received in Outlook. http://www.freevbcode.com/ShowCode.asp?ID=1154&NoBox=True This works fine when the attachments have different filenames. What I can't figure out is a way to automate this procedure when all the attachments...

I have a module that uses the 'Microsoft Shell Controls and Automation'(Shell32) reference to browse for a folder. It uses the 'Shell32.folder' term and works well on Win2000 & Windows 98. The problem arises with NT4 installations which use an older version of the shell32.dll (pre version...

I've been having trouble with the MSAccess.exe process not quitting every time I close the database. I know an object is not unloading somewhere along the line, but I can' just put my finger on it. The problem doesn't seem to follow any strict pattern. I have used the Switchboard Manager to...

I produce invoices using a standard Access report. Several fields are in currency format. Can I make the currency format conditional so that if the invoice is for a UK company the currency symbol displayed is '£' and if the invoice is for USA company the currency symbol displayed is '$'? I have...

Any suggestions as to how to go about populating a listbox with the names of all the files in a specified folder: ("C:\Dropbox") that have the file extension .xls ? Many Thanks, Neil

How can I pass the value in a text box in a VB form to an Access report. I have managed to open Access report directly from a VB6 command button, but I don't know how to link a a parameter for a label on the report. Many thanks, Neil

Got a problem with Access 2002 on a Win2000 Pro machine. On closing an mdb database, the "MSACCESS.EXE" process fails to terminate. This means that users cannot restart Access until they go into Task Manager and use the "End Process" command on the "MSACCESS.EXE&quot...