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!

Register Log in
  • Congratulations derfloh 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. vedicman

    oracle date issue

    I'm just starting to work with oracle dates. What is the correct way to pull svc.SV_ADJ_DATE (s) that are greater than 1/1/2005? Select Distinct svc.SV_ADJ_DATE From MI50_RMH.SERVICES svc Where svc.SV_ADJ_DATE >= 01/01/2005 Thanks...Franco
  2. vedicman

    DoCmd.RunSQL mystery

    Remou Thanks alot! I don't get into Access very often, and it's a challenge when I do. this line did the trick: intInt = DCount("*","Table Or Query Name","FieldX=1") Thanks....Franco
  3. vedicman

    DoCmd.RunSQL mystery

    Remou Thank for the clarification. Perhaps you can tell me how to do this another way. What I want to do is run a SQL statement that gets a count of Doctors and assigns the value to an integer variable. Any suggestions...with sample please. Thanks....Franco
  4. vedicman

    DoCmd.RunSQL mystery

    When I run the following sub, a message pops up saying, "A runSQL action requires an argument consisting of a SQL statement" Sub test() Dim sSQL As String sSQL = "SELECT PRCR_ID FROM [Access PCPs Counts Only]" DoCmd.RunSQL sSQL End Sub Can...
  5. vedicman

    Defining a named Range covering multiple worksheets

    Is it possible to define a named range in XL that spans multiple worksheets? If so, please include the details on how to do it. I've tried this: Names in Workbook: MyRange Refers To: =Results!$A$1:$A$65356,Results1!$A$1:$A$1700 It doesn't seem to work. Any Suggestions. Franco
  6. vedicman

    Link to a folder on C drive

    Double quotes was one of the options I had already attempted. I tried it again as you suggested and it still doesn't work. Any other ideas? Franco
  7. vedicman

    Link to a folder on C drive

    I want to create a link to a frequently visited FOLDER on my local C: drive. The following link worked OK on the PC at my last job, but it doesn't work on the PC at my current job. Here, the OS is XP Pro, and the browser is IE7. <a href='file://C:/Program Files/WindRose/ProTable/'> I've...
  8. vedicman

    Enabling a disabled button in datagrid footer

    ca8msm We've come full circle...how do I enable the button when txtWeek changes? See my initial post. Thanks...Franco
  9. vedicman

    Enabling a disabled button in datagrid footer

    jbenson001 With the following code, the button(btnAdd) is loading disabled, but when I enter data into the textbox(txtWeek) it is not becomming enabled. I'm still missing something. Any other ideas? Sub EnableAddButton(sender As Object, e As System.Web.UI.WebControls.DataGridItemEventArgs)...
  10. vedicman

    Enabling a disabled button in datagrid footer

    Can you provide some details? I wired the OnItemDatabound method of the datagrid to the sub below: Sub EnableAddButton(sender As Object, e As System.Web.UI.WebControls.DataGridItemEventArgs) Dim btnAdd as button = e.Item.FindControl("btnAdd") btnAdd.enabled="true" End Sub I'm...
  11. vedicman

    Enabling a disabled button in datagrid footer

    I have a button (btnADD)in the footer of a datagrid for adding new rows to the grid. Initially I am setting the enabled property to false, then I want to enable the button when data is entered into a specific textbox (also in the footer). I'm using the ontextchanged event to run: Sub...
  12. vedicman

    Add new row to Datagrid

    dvannoy.... Is there a way to have the scroll bars appear on the left side of the datgrid? ca8msm.... Would you provide a code sample using an achor tag to make the page appear at 'the relevant point'? My problem is not being able to see the header row when adding a new row at the bottom of...
  13. vedicman

    Add new row to Datagrid

    dvannoy Thanks for responding. Personally I have no problem with having the add row in the footer. My boss is the one who would like it at the top because the data grid is more than 40 columns wide and each week a new row is added and now that we're in to week 22 or thereabouts you can no...
  14. vedicman

    Add new row to Datagrid

    Is there a way to add a new row in the first row under the header of a datagrid, instead of adding the new row at the bottom in the footer? If so, please provide a code sample of how to do it. Thanks....Franco
  15. vedicman

    trouble with hyperlink

    Same behaviour! The page cannot be displayed The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings. It still opens OK if I paste the filepath in the address box. Any other ideas?
  16. vedicman

    trouble with hyperlink

    \\entersvr1\e$\Financials\weeklyrevenue\BestImageWeeklyRevenue-BudgetReport.pdf If I paste this into the browser address box, the file opens OK. However as a hyperlink coded as below it does not open. Please show me what I need to change. <a...
  17. vedicman

    Pass a parameter from an asp textbox to another page

    In the aspx I am handling some calculations that produce a string of 7 letters (A thru G) in various sequences (a 'sequence code' if you will). The txt page that is being opened uses this 'sequence code' to change the background colors of the page in the order described by the 'sequence code'...
  18. vedicman

    Pass a parameter from an asp textbox to another page

    I need to assign it to a Java Script variable in the txt file. Would the parameter be available if the extension was hta or html instead of txt?
  19. vedicman

    Pass a parameter from an asp textbox to another page

    I have a hyperlink control on my aspx with the following navigateURL: 'http://10.2.1.50/Samples/ColorDemo-dev.txt' Is there a way to pass in / append a parameter from a textbox on the aspx page and have that parameter be available in ColorDemo-dev.txt? Thank You......Franco
  20. vedicman

    Changing color of text box

    Hello I've have got it working more or less, but there is still a small glitch. The first color in the sequence displays briefly, then the backcolor goes white again, then the colors display in sequence for 5 seconds each as they are supposed to do. I will paste the entire code below, and I'm...

Part and Inventory Search

Back
Top