Search results for query: *

I have a database that we use to monitor user network traffic. I use a simple form and a query that is pointed at a .txt file for the information. We have multiple sites and would like our database to ask us where the log file is instead of hard mapping the query. Each proxy server generates...

Hey all I have a query that powers a report. I want the query to be based on criteria on a form the manual criteria is >=#8/1/2004 12:00:01 AM# And <=#8/31/2004 12:00:01 AM# I need to get Forms!JobLog!txtDateBegin and Forms!JobLog!txtDateEnd in this criteria. I just want to switch out the...

Hey there all, I have a form that I use to close helpdesk tickets that calculates the time spent on the ticket. I decided a few weeks ago to allow the users to have all the forms in the database be pop ups instead of the normal form. This allows the user to shrink the Database window down and...

I have a query where a user is loging information on a monthly basis. We are monitoring changes in performance. the issue I am having is getting the query to show the most current date Client Code DateChecked ASP Capacity ASP Percent BI 4/5/2004 3.93G 85.8167 BI 5/6/2004 3.93G 87.2490 BI...

Hey there everyone. I have a form that has a sub form in it. The parent form has command buttons that open a new form and edit data in a table that the sub form gets from a query. What I need do is have the sub form refresh its query every 30 seconds or so. I think I can set the from...

Hello Made a database to keep track of how many calls we are getting in a day. We are also trying to use this database as a helpdesk log that let us keep track of what issues are closed and which issues are not. Anyway We want to use a primary key with this structure. YYYYMMDD#### The #'s...

I am trying to help a user that has a session that she opens up to connect to an AS400 via tcp/ip. On the sign on screen an old user name is already typed, however the new user can not over type the old name or delete the old name. Any Suggestions Krash

Hello, I work for a company that supports many AS400s with different OS levels. I am responsible for maintaining a database on all of the systems Maintenance. Here are a few of the commands I use to get a visual display of the information I am looking for. DSPOBJD QGPL *LIB 5 I then look at...

I am dealing with an AS400 that handles email. The users are using Outlook to get their email but when sending and receiving, the sending portion times out. They are receiving multiple copies of the same email but they cannot send out. When I do a NETSTAT to see the SMTP and POP3 stuff. I...

I had a user tell me that she could not open her Outlook 2000 today. I started looking around and could not get it to open either. I then looked at Task Manager and noticed that there was about 20 instances of Outlook open. I tried rebooting but it did not have any effect on the instances of...

At netstat option 3, you are looking at a particular telnet connection. From the IP adress and port, how can we tell what device and job this connection is supporting? Conversly, if we are looking at a job that we know is connected via tcp/ip, how can we discover the ip address and port that...

We have a pc that has Word Perfect installed on it. When the user logs onto the domain and tries to launch the program an error occurs that says program &quot;failed to initialize&quot;. When the user logs into the local computer (Windows 2000 pro) the program runs fine. Any ideas? Krash

What could cause word docs to open slowly when accessing them from a Win2k server with WinXP while Win98SE opens the files at normal speed from the same Win2k server?

I have a task of converting Dates over to a number like the following 02/31/01 to 023101 However when I change it in excel it is saved as a custom date so when I try and convert it over to and AS400 02/31/01 to 36935 What I need to do is change the 02/31/03 to general text without it...

Is there a way to get all the system information off an AS400 with out looking at 6 different screens. I guess what I am looking for is a way to have the AS400 dump all the System information into a spool file or even a text file. Thanks Krash

Hello, I set up a FTP site on our server. I went to the folder that I designated for FTP and built permissions. I built a user group called FTP that only has access to the FTP site. Right now it works. My boss would like to have me enable an IP filter along with the User Name and password...

Hello, I am new to the exchange area. My boss gave me the following 3 things to do. Can someone tell me where to begin to find out about these? Thanks Krash Kenny, I would like you to do some research on the following: 1. Find out how to turn of the Delivery Receipt Function on...

I have a feild that is based on the following Calculation. MA=Member Assets TA=Total Association Assets LF=Legisilative Fee which is 4000 right now MF=Members portion of Legislative fee. (MA/TA)LF = MF Ok not that I have this answer I have to go to the next step. If MF > 12.00 then MF=MF...

I use a form that looks to a query. The query has a criteria of currency for a txt box that resides on the form. The criteria is Like &quot;*&quot; & [forms]![frmArchiveChargeBack]![txtSearch] & &quot;*&quot; Can I make it convert the text to currency here? Krash

I have a table called tblRecords and another table called tblRecordsArchive. To keep the speed of the database up I manually copy any record that is more than 90 days old to tblRecordsArchive. I usually do this on the first of every month. I would like to make a macro or module that would...