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

I ended up using >=[forms]![joblog]![txtDateBegin] And <=[forms]![joblog]![txtDateEnd] Thanks Krash

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

make the query entry something like this but with your form name and textbox name Like "*" & [forms]![MainClosed]![txtDate] & "*" It will be a total wildcard system Hope this helps Kenny

Recently I took and excell spread sheet and imported it into Access. I used Access's export function to export and define the record lengths and fields. Then I used Client Access to transfer the file to the AS400. Worked well and now is very quick. Hope this helps Krash

Have you tried using a Worstation Customizing Object to force the portrait print? Krash

I am checking up on our clients AS400 systems to see if they are doing nightly and full system backups and how full the harddrives are. I have to generate 3 onscreen reports that tell us which clients are being bad and at the most risk. When the client then gets the backups done or frees up...

That worked perfect. Now I can build more queries based off of that one. Thanks so much. Krash

I started over with a new query based on the table instead of a query to simplify things. Krash

...[Monthly Updates].Version, [Monthly Updates].[PTF Level], [Monthly Updates].[ASP Percent], [Monthly Updates].LNBU, [Monthly Updates].LFSS,t1.* FROM [Monthly Updates]t1 WHERE t1.DateChecked In (select top 1 t2.DateChecked from [Monthly Updates] t2 where t2.Client Code = t1.Client Code ORDER BY...

ok, I just got confused. this is the way my SQL looks SELECT [Monthly Updates Query].[Client Code], [Monthly Updates Query].DateChecked, [Monthly Updates Query].[ASP Capacity], [Monthly Updates Query].[ASP Percent] FROM [Monthly Updates Query] ORDER BY [Monthly Updates Query].[Client Code]...

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

Apparently one of the emails (not the one duplicating) was infected with a virus. I displayed the email and saw it was bogus so I deleted it from the AS400. Now when the problem comes up I know that I need to go look at that users email file and get rid of the bogus/virus email. Thanks, hope...

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

...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 “Save date/time . . . . . . . . . . : 02/25/04 02:05:23” DSPOBJD SAVSYS *CMD 5 I then look at “Last used date . . . . ...

...the POP3 are &quot;time wait&quot;. I have IPLed the machine and have restarted the mail server using the following commands. ENDTCPSVR SERVER(*SMTP) ENDTCPSVR SERVER(*POP) ENDMSF OPTION*IMMED) STRCPSV *SMTP STRCPSV *POP STRMSF Only to get the same response. I do not know what to do next...

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