Search results for query: *

I am trying to run a query that returns individuals born after 1/1/1994. I am working with a legacy database and the birth date is stored as text. I was able to convert the records to date format using CDate. However, when I include a search parameter for people born after 1/1/1994 I get a...

I am trying to use Access to generate a report that will list the average time difference between two events by month. At first I tried using a calculated field in my query then group by month in the report and use an unbound control and the Avg() function in the group footer. My formula in...

I have some code that allows users to filter a list of street address. It works fine except for when a user makes changes to a record then goes to search for a street. I get error number 3219 "Operation not allowed in this context". And the program stops on the Close method (see code below...

I am using the code below to filter a list of names that appear in a datagrid. As the user types in the letters of the last name, the program filters the recordset to those records that start with the letters typed in. The code works fast as long as there are records in the recordset...

I am trying to install the SP3 Rollup. I downloaded this file: Exchange2000-KB870540-v2-x86-ENU.exe and double clicked on it. It decompressed several files, shut down some services, and then installed the files. I then rebooted the server. However, when I view the server properties under...

I have VB application that manages a SQL Server 2000 database. I also use a CRViewer control to allow the user to view and change reports designed in Crystal Reports 7.0. The reports display fine, however when a user clicks on the refresh button it displays the following error message: "Server...

I am resposible for a small 100Mbs ethernet client/server network. We have a total of 10 clients and we are going to move 4 clients to a far corner of our building. Can I run a single cable from our existing hub to the new area and plug it into a new hub and then plug the relocated clients...

I am using Outlook 2003 and Exchange server 2000. I use the Junk e-mail protection that comes included with Outlook 2003. Since the last update from Microsoft, I find that it does a pretty good job of blocking spam. The only problem is I cannot find a way to make it check both of the e-mail...

I am starting to think I have a worm on my Exchange 2000 server. For the second time in a week the C: drive has filled up. And I am getting some strange messages in the application log. For example, Event ID 482 "An attempt to write to the file C:..E00tmp.log failed, their is not enough space...

I have a datagrid that I define in code. The code looks like this: 'For colums in dgdDonHist Dim colDonHistAcctNum As Column Dim colDonYear As Column Dim colDonAmt As Column Dim colDonPostDate As Column...

I a using Crystal Reports 7 and I want to combine several fields related to addresses(HouseNum, Fraction, Street, AptNum) into one address line in the details section. If I just insert the database fields and line them up, the result is messy because some the fields maybe blank and the values...

Can I connect to and display an MS Access report in a VB application. I know how to connect to a table and am wondering if I can do a similar thing with a report because I find the DataReport included with VB difficult to use. Thanks in advance for any assistance! Timoteo

I am having a great deal of difficulty displaying my data properly using a datareport. I want a simple report the displays the items assigned to an employee, and then prints their name below a line, on which the employee can sign their name. So it would look like this: Item Description...

My Symantec Antivirus detected the sobig worm. For what ever reason it was not able to quarintine or delete the e-mail where it was located. I then tried to manually delete the file I could not find it. My virus scanner told me it was located in this folder C:\Program...

I am using VB 6.0 (SP5) to access a SQL Server 2000 database. I have a tempory table that stores and displays the data until the user confirms the update. How can I move this temparary data to the permenent table? Thanks in advance for any suggestions. Timoteo

My boss suspects that one of our employees is using his e-mail inapporpriately. He wants me to find out for sure. The problem is I know very little about Exchange Server 2000. Is there a way I can view a users sent items? Or better yet, does Exchange keep a log of e-mail addresses a user...

When I run the self extracting W2KSP4_EN.exe, I recieve the following error message "W2KSP4_EN.exe is not a valid win32 application". Does any one know what the problems is? Thank you in advance for any assistance. Timoteo

I am trying to keep the numlock key on my WXP and W2K machines. I have followed the instructions in faq779-1386 to no avail. I am having three problems: 1) On my xp machines the IntialKeyboardIndicators setting in the registry keeps resetting its self from 2 to 0 2) On my xp and 2k machines...

I am trying to join acomputer to my Win2k Server domain. I keep getting an error message that says domain name is invalid or does not exist. But it is valid, I have triple checked and it is the same domain name I used for all the other computers on the network. Its not a cable or other...

I am trying to use the Execute Method to update a table and I keep getting an syntax error message for my update statement. It's drining me crazy, I've gone over the code a dozen times and I can't find where I am going wrong. Can anyone help me find the problem. Here is my code: strMemoSQL...