Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. XP2000

    Why No Pagefile?

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

    Why No Pagefile?

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

    Need to use scheduled task to run an access macro

    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.
  4. XP2000

    Comparing a Table with a Query

    Thank You....works a treat
  5. XP2000

    Comparing a Table with a Query

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

    IE6 Cannot display page error

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

    Select one Record at random from a Select Query

    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.
  8. XP2000

    Changing the page footers within the same Access Report

    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...
  9. XP2000

    Print Current Page in acViewPreview mode

    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...
  10. XP2000

    Print Current Page in acViewPreview mode

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

    Print Current Page in acViewPreview mode

    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...
  12. XP2000

    Print Current Page in acViewPreview mode

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

    Print Current Page in acViewPreview mode

    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...
  14. XP2000

    Regional settings

    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.
  15. XP2000

    MSACCESS.exe process not terminating

    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.
  16. XP2000

    HELP - HELP - HELP!!!!!!

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

    Outlook Attachments

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

    Opening a form and entering data from another form

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

    Outlook Attachments

    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...
  20. XP2000

    Don't want report to show null information

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

Part and Inventory Search

Back
Top