Search results for query: *

I am using Outlook 2002 with SP3. My email account stores emails on the server and periodically the server will expunge old emails. I prefer to keep all my emails so I created personal folders with the same structure as the exchange account and I use rules to move a copy of emails to the...

I am trying to make a lilo boot floppy but for some reason when it comes time for the lilo install it just spits out the lilo options as if I am missing something. The directions that I am following are at http://www.yolinux.com/TUTORIALS/LinuxTutorialRecoveryAndBootDisk.html#LILO One...

Hello, I have an Access situation that I haven't been in before, but I'm sure it is much easier than it seems. I have a table called "ips" (as in IP addresses). The table is very simple simplconsisting of a server name, domain, and IP. The problem is that each system can have up to 4 IP...

Hello, I am running RedHat AS 2.1 and I am looking for parameters in linux that are similar to the following HP-UX kernel tuning parameters: maxssiz: 8388608 maxssiz_64bit: 8388608 maxtsiz: 67108864 maxtsiz_64bit: 1073741824 maxdsiz: 990056448 maxdsiz_64bit: 1073741824 maxfiles: 256...

Hello, I am trying to find system names with duplicate entries in our database with a duplicate query. It works sort of. Right now it lists every duplicate instance of some systems and only one of the instances for other systems. It appears that if the (allmid_cpu.sa_suitsid) field is blank...

I am having trouble with my automount. I want to have server.example.com:/extra/common to mount on /common locally. I did a showmount -e and the export is active. My auto.master looks as follows: /common /etc/auto.common --timeout=60 and auto.common looks like * -ro,soft,intr...

Hello, I have RedHat 7.2 and would like to switch from using LILO to GRUB. Currently they are both installed, but LILO is being used. Can I just do a grub-install to make it the default or must I uninstall LILO for this to work? Any other steps involved? Thanks.

Hello all. I have a field in a query that counts all the fields that have a date, regardless of when that date is. It looks like: sw908scount: Sum(IIf(IsNull([sw908_submitted]),0,1)) Now I would like to count them only if the date in "sw908_submitted" is a year or less old (within...

I have 20+ linked tables in my Access '97 DB. They are linked to an Informix DB via ODBC. For some reason whenever I try to link a table, I get an error. It happens at the point where I actually select the table(s) that I want to link and hit "OK". The error is: "msaccess.exe...

I have two tables, one represents information about servers. Each server will have an SA. So it looks like: CPU table SERVERS SAs server1 id1 server2 id2 servre3 id1 I also have a table of users. These are people who are allowed to log in and change the...

I have a strange problem here. I have an Access app. that exports 50 queries into Excel. I recently had some problems which I solved that had to do with my linking tables. I reinstalled Access and brought it back up to speed...or so I thought. Now, when I try to export a query with a name of...

Hello all. I am trying to make a query that consists of several tables, but only two tables are important for this issue. CPU table -sys_name (samplename) -dns (sampledns.com) Performance table -sys_dns (samplename.sampledns.com) -tot_occ (integer) I need to get total_occ in the...

I have a database that until recently would export 50 reports with the DoCmd.Transferspreadsheet command. Well, I had computer problems that required me to reintall Access and now when I do this I get an error 3027 "Database or object is locked or read only". I tried to export the...

I would like to know if I can somehow manually link a table? I have a database with 14 linked tables and 3 native tables. The 14 linked tables work great right now, but if I try to link any more tables from the same remote database, or if I delete a table and try to re-link it, I get a fatal...

Hello all. I am new to the Office/Excel board, but have been around the MS Access board for a while. I am curious if there is a way to do a countif on text color and/or cell color in Excel 2002. The cells/text were manually formatted, so there isn't a criteria that I can plug in to the...

I have the code below which works flawlessly when Outlook is open, but if Outlook is closed, it sends the message the next time I open Outlook, not immediately. By the way, I am using redemption. Any suggestions? Thanks Public Sub MailIt(name As String) Dim olItem As Outlook.MailItem Dim...

I would like to know how to check if outlook is already open. Thanks in advance for your help.

Hello all. I have a program that run's queries in Access on tables that are linked to an Informix database via ODBC. If I close the Access database then re-open and run the program I get a screen that shows the server name, database name, and asks for the userID and Password of the informix...

I have a database linked via ODBC to and Informix database. If I don't run any queries for awhile or if I close Access and run a query upon re-opening I get a text box that shows the server name, database name, etc and it asks for the userid and password. How can I get Access to remember the...

I have a form that allows me to hit cmdRunReports and it will run 50 reports over a few minutes. I have a text box called txtTime that I would like to show the elapsed time (count up from 0 in hh:nn:ss format) since cmdReports was hit. Any suggestions? I am new to these forms so please be...