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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Talonjpc
  • Content: Threads
  • Order by date
  1. Talonjpc

    Check if Outlook is already open

    Hi Everyone: I need to know how to check whether or not Outlook is open. I have searched through the forums and have not found a solution. Any help would be appreciated.
  2. Talonjpc

    subform requery problem

    Hi everyone. I have a subform that displays the software installed to a server. I also have another form that deals with software by itself. I have that subform on a master form. When I open the software entry form and add a new piece of software or delete a piece of software, the software...
  3. Talonjpc

    Stop Header from showing when there is no data

    Hi everyone: I have a subreport and in the report footer the following is located Total Number of Internal Drives x Total Number of EMC Spaces x X is the number for that particular server. Anyway my problem is that I also have a Header based on Computer ID (the linking field between the...
  4. Talonjpc

    Sum number of records in a subreport based on criteria

    Hi Everyone: I have looked all over this forum but can't seem to find an answer. I have a subreport, srptDiskStorage, and I want to count the total number of drives that are of storage type 2 on the report. The would involve counting the records for each time a storage type 2 drive appears. I...
  5. Talonjpc

    Printing a variable on a report

    Hi Everyone: I have a public string in a module for a report. I want to place that variable on the report somehow. Is there anyway to do this? Thanks, Vinay
  6. Talonjpc

    Increment or decrement a value in a table after form event

    Hi Everyone: I have a field in a table that keeps track of the total number of installed instances of a particular piece of software. When a piece of software is added to a server in a form, I want to be able to increment the number in that field. Additionally I would decrement it when a...
  7. Talonjpc

    How to display label if variable equals something

    Hi Everyone: Here is my problem When I run this code: If SelectString = 3 Then Me!lblWebDeveloperRequired.Visible I get the following error: Run Time Error 438, Object doesn't support this property or method. If I go to debug the following is highlighted: Me!lblWebDeveloperRequired.Visible...
  8. Talonjpc

    Hi Everyone: When I run this cod

    Hi Everyone: When I run this code: If SelectString = 3 Then Me!lblWebDeveloperRequired.Visible I get the following error: Run Time Error 438, Object doesn't support this property or method. If I go to debug the following is highlighted: Me!lblWebDeveloperRequired.Visible Basically I am...
  9. Talonjpc

    Adding Criteria to a report without a premade Query

    Sorry if this question seems dumb to anyone but I need some help. Can I open a form with certain criteria without creating a premade query, like putting a SQL WHERE statement in the OnOpen or OnActivate Events? The criteria would be based on a variable Thanks in Advance, Vinay
  10. Talonjpc

    Storing user entered criteria in a variable

    Here is my problem: I have a filter with the criteria [Enter Software Name:] that opens a report based on what the software name is. It then tell you which computers have this software on it. If the Software is not installed on any servers or does not exist, the report has no data, which is...
  11. Talonjpc

    Criteria with SQL LIKE Problem.

    Talonjpc (Visitor) Jul 29, 2002 I know the SQL LIKE command allows someone to search for a value that matches part of the criteria. However, how do you use the LIKE command with User entered criteria. I want the user to enter a server's network name, so in the criteria I put Like [Network...
  12. Talonjpc

    Criteria with SQL LIKE Problem.

    I know the SQL LIKE command allows someone to search for a value that matches part of the criteria. However, how do you use the LIKE command with User entered criteria. I want the user to enter a server's network name, so in the criteria I put Like [Network Name] However the []means something...

Part and Inventory Search

Back
Top