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

    CR 8.5 not "seeing" some foxpro tables

    I'm experiencing exactly this problem. Did you ever solve this, Kristie? Thanks!
  3. DerekMcDonald

    Power Management for Users Group

    Thanks! I'll look into it...
  4. DerekMcDonald

    Power Management for Users Group

    No! The users are in the Users group- I don't want them installing a bunch of games, junk internet software, etc... Derek
  5. 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...
  6. DerekMcDonald

    Cannot run any setup.exe programs!!!

    Thanks, but I'm afraid that didn't do the trick. Once all my users log off I'll try SFC, then install a bunch of service packs and hope that the increased security doesn't hose my system (like it did on the FIRST install)... Derek
  7. DerekMcDonald

    Cannot run any setup.exe programs!!!

    Of course! Many times... didn't help.
  8. 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...
  9. 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...
  10. 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...
  11. DerekMcDonald

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

    Thanks! That almost works, but here's an interesting Access quirk. According to Microsoft, when a subreport has no data, it's unavailable. Therefore any line referencing the ctl.report.HasData (or any property) generates an error message. In fact, I get this error message even when the...
  12. 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...
  13. 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...
  14. DerekMcDonald

    Duplicate IP Address error on standalone workstation

    Thanks, all! Following your advice we've narrowed the problem down to the server. Here's the new deal: If I unhook the server (xxx.xxx.xxx.xx2) from the router (xxx.xxx.xxx.xx1) and start the standalone workstation (xxx.xxx.xxx.xx3), I get an internet connection. If I plug the server back...
  15. 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...
  16. 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...
  17. DerekMcDonald

    Send number of duplicates to find based on form data?

    Thanks, Rick! That's pretty much what finally occured to me yesterday- I created a function and string variable in a module, set the criteria field to the function, then set the string value to "2" or "3" on the "on update" event of each combo box. Works like a charm!
  18. 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...
  19. DerekMcDonald

    Form input PLUS multiple criteria from same field?

    Here's the SQL from the first query: SELECT tblIdenCategories.ID, tblIdenCategories.ID_IdenCat FROM tblIdenCategories WHERE (((tblIdenCategories.ID_IdenCat) Like [forms]![frm_GetReportCategories]![cmbCats1] Or (tblIdenCategories.ID_IdenCat) Like [forms]![frm_GetReportCategories]![cmbCats2] Or...
  20. 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.)...

Part and Inventory Search

Back
Top