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 wOOdy-Soft 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: *

  1. ByronJohnson

    Ping VBScript

    How would I add a rule to skip all unvailable machines? If the ping result is could not find host the script fails. Thank you Set objExcel = CreateObject("Excel.Application") ' Sub to make Excel Document objExcel.Visible = True objExcel.Workbooks.Add intRow = 2 objExcel.Cells(1, 1).Value =...
  2. ByronJohnson

    VBScript to gather info then report to excel

    I am trying to edit this script so that I can gather who the currently logged in user is to the machine. Stuck on where to add the userID string Here is the code Option Explicit On Error Resume Next Const ForReading = 1 Const ForWriting = 2 Const ForAppending = 8 Dim strFileName ...
  3. ByronJohnson

    Printing Reports based on date and day of week

    Hey all, I am sure this is easy for most but I am stuck I want to create a cmd button on a form that prints a certain report based on the date and if it is a Monday this is what I have for code If Date = (mm / 1 / yyyy) Then DoCmd.OpenReport "1stoftheMonthReport(andNotaMonday)" Else...
  4. ByronJohnson

    Outlook 2002 Question

    The problem is that within the calender day view the form will only display up to 15 all dayevents for the day. Is there a way to change the view so that it will so more than this possibly 15 all day events. I have searced and serched thru options and properties and didn't find anything. Any...
  5. ByronJohnson

    VBA Help

    Hey Everyone, I am getting back into the programming game and am stuck. I have a form and want to into a value into a text box which goes and looks for this in a table, if found then it will display the values in the appropriate text boxes on form. If not found allows the user to enter in...
  6. ByronJohnson

    Adding Contact in Outlook 2002 Issue

    One of the users that I support is having a issue. whenever he goes to add a phone number within new contact it brings up the add new connection window and gets a loop and will eventually lock up. Any one ever run into this issue. It is a brand new dell laptop running XP Pro on it. We have...
  7. ByronJohnson

    OS Exam

    Well I took the exam today. Passed the Hardware but didn't pass the OS part. I thought the OS part was really tough. I got a lot of Questions on Networking, WIN95, and 2K. Any websites out there with some good practice questions geared towards the OS part. I studyed a lot but I guess not...
  8. ByronJohnson

    ICS between mac and pc using dsl modem

    Hey Everyone, I can't seem to figure out how this networking issue. Networking is not one of my expertises. I am trying to share a dsl modem between a mac and a pc. I am using a rounter for the network. The ISP is Earthlink. Anyone ever done this before? Any insight would be greatly...
  9. ByronJohnson

    Pulling data from a list box into a report

    Hey everyone, I don't even know if this is possible but I am trying to move data form a list box into fields in a report. The thing is that the data in the list box is not being stored anyway. It is just for display. If any one can help I would greatly appreaciate it. Here is the code that...
  10. ByronJohnson

    Help with insert Query

    Hey Everyone, I am stuck on this problem. I am trying to string together three different fields together and insert them into a table all within in the same column, same row. Here is my code. Private Sub cmdUpdate_Click() Dim lacvar As Integer Dim codonnum As Integer Dim codonstr As String...
  11. ByronJohnson

    Global Variables

    Does any one know how to declare a variable that can be used by one than one form. Example: I have a main form where when the user clicks on a text box then a pop-up menu comes up which then displays data depending on what was selecting on that field. Then I want whatever is selected to be...
  12. ByronJohnson

    Add records to a list box

    I am new to access and can't figure out how to do this. I have six combo boxes that the user choses from. When 0 or all combo boxes are selected, records are displaed in a list box pertaining to what was selected. Now I want it so the when the user selects fields in the combo boxes the records...
  13. ByronJohnson

    Moving Data from a List Box to A text file

    I have a form with multiple combo boxes on it. When they are selected then information pertaining to those combo boxes are displayed in a list box. I want to move some of that information in the list box into a text file. Does anyone have any example code of how to do this? Thanks, Byron
  14. ByronJohnson

    Problem with Left String Function

    Here is my code. Private Sub cmdCompute_Click() Dim critstr As String, x As Integer For x = 1 To 8 If Me(&quot;combo&quot; & x) <> &quot;&quot; Then critstr = critstr & Me(&quot;combo&quot; & x).Tag & &quot; = '&quot; & Me(&quot;combo&quot; & x) & &quot;' And &quot; End If Next x critstr =...
  15. ByronJohnson

    Form with multiple combo boxes refering to a List Box

    I was wondering if any of you knew the best way to set up a form where depending on what items are selecting in the combo boxes will display inforomation in a list box that is based off of a query. In the query all the fields that are displayed in the combo boxes are in the query. The list box...
  16. ByronJohnson

    Having Trouble with Counting Totals

    I have a form with more than 7 combo boxes. Than I have a list box that will either display all records if no combo boxes are selected or some records are displayed depending on which info was selected in the combo boxes. The list box displays three fields. Two are pulled a query which I am...

Part and Inventory Search

Back
Top