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!

Recent content by Talonjpc

  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

    Forgot to say that I tried that, for some reason it didn't requery correctly. I think it has to do with the way to two actions work. I know they work a little differently
  3. Talonjpc

    subform requery problem

    It looks like I figured it out. Instead of having the software entry form requery the subform I created an Event Procedure for the On Activate Event of the subform combo box: DoCmd.Requery "SoftwareName" This is probably inefficient to requery it every time but my database is only...
  4. Talonjpc

    subform requery problem

    hmmm new problem. the subform doesn't appear to be requerying correctly. I see it refresh but the combo box doesn't have the new software. Is there anyway I can requery the specific combo box inside the subform that is inside the form? Here is some more info The software subform is located on a...
  5. Talonjpc

    subform requery problem

    I just used the SetFocus command and it worked. I guess before I was using DoCmd.GotoControl. I guess the setfocus command slipped my mind. wow thanks
  6. 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...
  7. 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...
  8. 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...
  9. 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
  10. Talonjpc

    Increment or decrement a value in a table after form event

    I would need to calculate at any time the amount of entries in the table ComputerSoftwareList named cobol. That table is basically a linking table to link software to servers
  11. 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...
  12. Talonjpc

    How to display label if variable equals something

    Yeh I forgot to include a descriptive subject, and I tried to stop the previous message, but I couldn't. Sorry about that, and thanks again
  13. Talonjpc

    Hi Everyone: When I run this cod

    Thanks BK worked great
  14. 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...
  15. 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...

Part and Inventory Search

Back
Top