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...
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...
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
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!
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...
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...
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.)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.