Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
mminfo queryspec "Not Equal" comparator?
We have a large enterprise, and I am only responsible for the Windows Server environment. That being the case, I am trying to script some reporting using mminfo. Is there a queryspec comparator for "Not Equal" that works on "Group" or "Pool" names so I can filter out that yucky UNIX garbage...- abhodges
- Thread
- Replies: 1
- Forum: Data Recovery general discussion
-
I need help to Query via Form Value on Event
Remou, I don't follow exactly what your saying about the key field. However, I changed the WHERE statement per your example and added the Requery sub and the form now works just as I wanted it to. Thanks for the tips on the spaces and SELECTions. And a BIG THANKS for providing a solution. Bruce- abhodges
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
I need help to Query via Form Value on Event
>hermanlaksko (Programmer) 31 Mar 06 1:42 > >1. Are you using a textbox or a listbox... >2. ...what are you trying to update. >3. External app should not get data from a subform, only from a table or query. 1. I have been attempting to get a listbox to work, but without much success. So...- abhodges
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
I need help to Query via Form Value on Event
Form: ServerDetail Table1: ServerDB Table2: MasterAppList Link: ServerName I need to populate textbox or listbox with all matching records from MasterAppList based on ServerName, and have it update, everytime ServerName changes in the ServerDetail form. NOTE: Not all servers have a...- abhodges
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
Date/Time Calculations (Possibly DateDiff)
Sorry, should have also stated that I am working with long date formats, including time. eg. Wednesday August 28, 2002 6:14pm. DateDiff doesn't seem to work when the time is included. -
Date/Time Calculations (Possibly DateDiff)
I am trying (without much luck) to calculate the elapsed time in days and hours between two date fields. Anyone care to help? Oh ya, I know almost nothing about VBScipt! Brusifer
