Search results for query: *

Hello, I am using Shell to execute files on the click of an Access button on a form. In the code below Me.filename is the value from a control on the form which is the file name and extension. It is generated and saved in the same folder as the mdb file so CurrentProject.Path completes the full...

Hello I have a spreadsheet with 2 columns A and B this is an example of my data: A B 1 Cat A-34B 2 Dog B568 3 Tree GGG5 4 Dog B569 5 Box 98-7POY 6 Car 989867 7 Plane TTT-9-0 8 Boat A9-A9-X789 9 Horse B7709G 10 Tree GGG3 11 Dog B568...

Hello I have the following code which creates a rounded corner box using only CSS and no images and works in IE. I need to modify the CSS to include hover and active states so that the box Background colour changes to white when the mouse hovers over it and yellow when it is clicked. Can...

Hello I have the following code which creates menu or rollover buttons with rounded corners using only CSS and no images and works in IE. I need to modify the CSS to include the OnClick or Active state which I think it is called in CSS so that the button Background or Border or Text changes to...

Hello I have the following C# code which I compile to a windows exe. However there are 2 problems I need to resolve: 1) It contains 3 list boxes which require modifying to allow you to copy and paste the contents. 2) The first box where you enter the URL needs modifying to trap errors from...

Hello, I have the following two sub routines (please see below). I need them to be combined in one function. The subUpdatePageLinks must run before the subUpdateConnStr. Also at present when the code runs it selects the dap in the database window making the database window visible even if it...

Hello, Can anyone help me by modifying the following code to include StrComp Function to make the ValidPassword sql variable case sensitive? ‘***************************Code Start************************************************** Private Sub cmdOK_Click() On Error GoTo Err_Handler Dim...

Hello, I have the following values currently stored in a Table with others waiting to be added: Exit Database which is a True/False Application Name which is a String But I want to delete the Table and use a different method to store these values. I want them in VBA code say in a Module...

Hello I have the following code: Private Sub Form_Load() Dim lngBool As Boolean lngBool = fCmdButTextPic(Me.CmdColorButton1, 12058623) lngBool = fCmdButTextPic(Me.CmdColorButton2, 12058623) lngBool = fCmdButTextPic(Me.CmdColorButton3, 12058623) lngBool =...

Hello I have an access form called Form1 which opens as a standard form no popup etc and it can be maximised and has sizing handles. Its opening dimensions are 15cm x 10cm. The form has a box / rectangle control called Box1 which is set to 15cm in length. When the form opens the rectangle...

I have the following data with this formula =IF(D1=0,"",(B1/100*D1)*(1-E1%)) in column F. In this portion of the expression ...(B1/100*D1)... I need D1 to increment over the twelve months of a year and not just *D1? So in the following example with the formula above the total in column F is...

Hello I have the following two formulas in a Microsoft Excel 2003 spreadsheet: =IF(OR(B3=0,C3=0),"",SUMPRODUCT(--(LEFT(‘Places won'!$B$2:$B$574,LEN(B3)-5)=LEFT(B3,LEN(B3)-5)),--(RIGHT(‘Places won'!$B$2:$B$574,6)>=RIGHT(B3,6)),--((‘Places won'!$C$2:$C$574)=5000),--(RIGHT(‘Places...