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!

  • Congratulations bkrike 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. DerekMcDonald

    dbf tables disappear from ODBC directory

    Greetings! I'm having a problem that's been bugging me for a couple of months now. We have a runtime Visual Foxpro timecard/payroll database (created with VFP version 6.0, I believe) that we're trying to connect to Crystal Reports and Access 2002 through the Microsoft VFP ODBC drivers...
  2. DerekMcDonald

    Power Management for Users Group

    We're running a Windows 2000 server/client network. Although I can change the power management settings on a client desktop or notebook when logged on as an Administrator, those settings aren't passed to users in the Users group, nor can they change their own settings. I can't find a Group...
  3. DerekMcDonald

    Cannot run any setup.exe programs!!!

    I have a pretty serious problem... When I try to run any non-Microsoft setup.exe programs on my Windows 2000 server, the file will unpack (to the "temp" directory) and then nothing happens. The "setup.exe" process will be running in the task manager, but that's all (so I...
  4. DerekMcDonald

    Conditional visible button on continuous forms

    I've seen a lot of questions on conditional text formatting, which I understand... But here's one on conditional formatting buttons within continuous forms. I have continuous subforms within a main form, showing up as rows. Within each subform/row, I'd like a button cmdGoTo to be visible only...
  5. DerekMcDonald

    Another Function as Criteria Problem...

    Hi! It seems like this should be simple, but... I have a permanent query where I'm trying to set the criteria through functions that grab data from a form. Let's take the [Date] field as an example. In the query, the function getDate() is in the criteria field. If the user chooses...
  6. DerekMcDonald

    For Each... Next - How do I reference subreports?

    Hi! I have a report with 4 unbound subreports in it. I'd like to be able to loop through the subreports to determine if they contain no data, and then display a label if they're all empty. Trouble is, while I can do this with forms, I can't figure out the code for reports. Here's kind of...
  7. DerekMcDonald

    Changing Win2K logon password deletes email addresses

    I'm running a Windows 2000 network with Exchange 5.5, which clients access through Outlook 2000. Win2K server and Exchange are connected through the Active Directory Connector. I originally had my Win2K client accounts set up with a fixed password that they couldn't change, but for security...
  8. DerekMcDonald

    Duplicate IP Address error on standalone workstation

    Please bear with the long description of our problem... We have an SDSL account with a series of eight static IPs. The router/gateway has static IP xxx.xxx.xxx.xx1. I've got a Windows 2000 server with two NICs. One is external, and bound to the single static IP xxx.xxx.xxx.xx2. The second...
  9. DerekMcDonald

    Word 2000 maximizes off center

    I just had the distinct pleasure of upgrading to Office 2000. Now, occasionally when I start Word or maximize it, it maximizes off center, cutting off the right scroll bar or sometimes more. In its maximized state, I can't get it back to the center of the screen. Sometimes closing and...
  10. DerekMcDonald

    Send number of duplicates to find based on form data?

    Hello, friends... How can I tell a query to find X duplicate values, where X changes based on the number of combo boxes filled out in a form? This relates to my question from yesterday about finding multiple criteria from the same field. I have a form with three combo boxes. The user can...
  11. DerekMcDonald

    Form input PLUS multiple criteria from same field?

    Hi! This would seem to be a pretty common query, but I can't find many helpful answers on how to set it up. Please bear with me and read on: I've got a contacts database. Table 1 holds the contacts names and addresses. Table 3 holds the contact types (Board Member, Donor, Ex-Staff, etc.)...
  12. DerekMcDonald

    Changing account name -good idea?

    One of our staffmembers recently got married and would like me to change her NT Server account (logon + e-mail) name accordingly. We're running Exchange Server 5.5 and Small Business Server 4.5. The User Manager for Domains has a tool to change the account name, but given my experience with...
  13. DerekMcDonald

    Imported null values read as zero-length strings

    Hi. I'm trying to append records from an imported table to an existing table in Access 97, but I'm getting the "validation rule violation" error message. If I change the "allow zero-length strings" property to "yes" for the fields to which I'm appending, I don't...
  14. DerekMcDonald

    Trapping subform movement and new records

    I have a main form and a subform based on two separate tables with a one-to-one relationship. If my data entry person wants to create a new main record or move to the next main record while the focus is on the subform, the subform record advances and she gets the inevitable "duplicate...

Part and Inventory Search

Back
Top