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 =...
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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
Here is my code.
Private Sub cmdCompute_Click()
Dim critstr As String, x As Integer
For x = 1 To 8
If Me("combo" & x) <> "" Then
critstr = critstr & Me("combo" & x).Tag & " = '" & Me("combo" & x) & "' And "
End If
Next x
critstr =...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.