Search results

Probably me being thick but what is WMI API and where do i find it

if you go to windows explorer and select search from the menu then select documents (word processing,spreadsheet etc) then select use advanced search options then enter yourd word in the box 'a word or phrase in the document' then select where to search in 'lookin' you will see a list of...

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

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

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

syntax Thanks gemma the huskey I dont have a problem with the date picker but pdx man gave me the answer to removing the apostrophe as follows & Replace(Me!Person_Responsible, "'", "''") & works like a dream thanks again for your advice

syntax Thanks PDX man it worked like a dream

Re Syntax 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 & "','" & Me!CmbCustContacts & "','" & Me!TxtResponsibletxtBox & "','" &...

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 & "','" _ &...

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 & "','" &...

If you create an unbound text box in the page footer (to replace the current box) Select the box and then format, conditional format Select Expression is (from the condition 1 drop down list in the field next to it type [page]=[pages] then select the paint can and selct a light colour then...

Yep you can import data only using the DTS wizard You can import tabvles buy creating and deleting them from the server before copying them over or you can append the data overor you can copy and replace data (the method i Prefer) see attachement

Create a query that selects the Id and name in the criteria section under name type forms![yourform]![yourcomboboxname] In the after after update of the Id field on your form Type Dim IDname as string IDname = nz(dlookup("ID","Queryname"),"") Yournamefieldon the form = IDname

Set the can grow option of The field on the report that is to hold the memo information to Yes (properties,format,cangrow)

in the page footer make sure you have the page number set Create a text box with the following as its data source ="Page " & [Page] & " of " & [Pages] Create another text box and set its data source to =IIf([Page]=[Pages],"Regards - Joe Blogs ","") if the page is number 2 and number of pages...

I would try the on load event of the form maybe even the on open event

I have attached some instructions on how to create a menu Once created go to tools startup and choose your new menu from the menu bar drop down list and deselect the boxes below

REIs this possible within Access 2003 You can do it by creating your own menu / Tool Bar have a look in the help to get you started and then post back if you have any problems

Try this in your code bit long winded but it works If YourField = ZoneNumber Then YourField.BackColor = vbRed ElseIf YourField = ZoneNumber Then YourField.BackColor = vbBlue ElseIf YourField = ZoneNumber Then YourField.BackColor = vbYellow ElseIf etc Else YourField.BackColor =...

Do you have error trapping in your code like this. The MsgBox Err.Number & vbCrLf & Err.Description part will give you the error number and then you can check for this error number (where the ???? are and then either resume and exit or display a msg box etc On Error GoTo Err_Record_Click...