Search results

  1. Smart

    monitor server performance ?

    If you go to control panel then administrative tools then performance you see a graph of the server / PC's performance. How can I extract this data using code so that i can run a package every 15 mins and extract and store the data in a table. Any help would be greatly appreciated
  2. Smart

    Programmaticaly Add user to secured dbase

    Can anyone help please How do you add a user to asecured database using vb Thanks
  3. Smart

    Date and Time difference

    I have four fields Date Sent (date) Time Sent (Time) Date Recvd (date) Time Rcvd (time) I want to know how many hours have elapsed between date and time sent and date and time rcvd Any Ideas please as I am having a blonde moment
  4. Smart

    Syntax

    Not sure if this question should be her but I am using a stored procedure to update a table Con.Execute ("Exec sp_Update_People_Root_Cause '" & Me!TxtbehaviourDriver & "','" _ & Me!txtRootID & "','" & Me!Person_Responsible & "','" & Me!DTPicker9 & "','" & Me!cmbLevel_1_ID & "','" _ &...
  5. Smart

    Syntax

    I am using a stored procedure to update a table Con.Execute ("Exec sp_Update_People_Root_Cause '" & Me!TxtbehaviourDriver & "','" _ & Me!txtRootID & "','" & Me!Person_Responsible & "','" & Me!DTPicker9 & "','" & Me!cmbLevel_1_ID & "','" _ & Me!CmbLevel_2_ID & "','" &...
  6. Smart

    View Parameter

    In access you can in a query type [Please enter name] in the criteria section and when the query runs it asks for a parameter. My question is how do I achieve this with a view in SQL? (I know how to achieve it with a stored procedure) Any Help gratefully received Thanks
  7. Smart

    working days in a month

    Does any one know how to calculate how many working days there are in a month IE Total number of days in a month minus Saturdays and Sundays All contributions gratefully received Thanks
  8. Smart

    Button Single click

    I currently have a form with a button that once clicked displays a word document,however I have to double click on the button even though the code is on the single click event property.The only line of code is as follows OLEFile.Action = acOLEActivate Does any body know how I can get the single...
  9. Smart

    Closing a report from within a form

    I currently have a form with a combo box that shows all employees When I select an employee a report is run in preview mode (after update of combox) If I then select another employee from the combo box I want to close the previous report preview and open the report for the newly selected...
  10. Smart

    Closing a form

    When a form is open you can also see on the task bar that the form is open If the user right clicks on the form(on the task bar ) they get the following options minimize , maximise , close. Does any one know how I can stop the user selecting Close please ?
Back
Top Bottom