Recent content by Krash878

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

I tried this and I get a syntax error SELECT [Monthly Updates].[Client Code], [Monthly Updates].DateChecked, [Monthly Updates].Version, [Monthly Updates].[PTF Level], [Monthly Updates].[ASP Percent], [Monthly Updates].LNBU, [Monthly Updates].LFSS,t1.* FROM [Monthly Updates]t1 WHERE...

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