Search results for query: *

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

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

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

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...

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

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

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...

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

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)...

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...

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...

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...

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...

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

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?

\\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...

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'...

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?

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

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...