Search results for query: *

I am having this same problem with a project that I am working with. I'm wondering is this a dead thread? No resolution at this time or? This does have an impact on what I'm doing as we have a complete flash site going up but what I'm seeing is that updates to the swf file are now showing...

Just looking for a good example to bind some data from a SQL query that I'm running on our backend tables to an Excel workbook. I've done this before and don't remember it being that difficult but having trouble setting it up at the moment. Anyone able to point me to any good examples I hope...

Thanks guys... just for everyone's information what I eventually ended up doing was simply using the old VB6 formatting on the hyperlink setup and while .NET complains some about it, it does actually except it and link the code. So, what I ended up with looks like this: Dim...

I'm struggling with this one and am thinking that I'm close but setting up something incorrectly. Basically I build detail pages with customer information and on a main page summarize the data. For ease of use I'd like to set up a link to the other pages in column A. The .NET code that I have...

Spoke too soon... here is what WILL work with constants... (more hoops to jump through) Range = CurrSheet.Range("A1:A3") With Range .Borders(XlBordersIndex.xlEdgeBottom).LineStyle = Excel.XlLineStyle.xlContinuous...

Thanks PHV... basically I don't get a reference to the constants so while I know those exist they aren't readily available. Sooo... once again Skip appreciate the response and that was the direction that I ended up going. Just annoyed that I have all those fancy constants and I'm back to...

Ok back on this topic after I thought we were completely done. Just to be clear I'm using vb.NET and while I've seen repeated postings aobut Excel border changes etc. including the helpful macro listings when I port this code over to the .NET side what I'm getting is an undeclared variable...

Well for crying out loud... I've programmed around Excel for years and I've never even thought of that Skip! lol... Time for me to go over to the wall and bash my head some... Thank you... AND... here's ur star :) CF I always makes things much harder than they should be... that way later I...

Hookay... Skip had posted this section of code in the past and frankly it does pretty much everything I need it to do but strangely enough I'm getting an undeclared on the linestyle formatting (ie xlThin, xlContinuous). I am importing the microsoft.office.interop so not sure why I'm getting the...

I know that this is probably not difficult since I have found some reference to the Excel .move method but I'm having problems with positioning a newly created worksheet. Anyone have a quick example of how to move a worksheet available? Thanks! I always makes things much harder than they...

Ok not exactly on the mark but you've given me something to take a look at... soooo... STAR for you and I'll come back with the completed post ~assuming that I can make this onery bugger work :)~ CF I always makes things much harder than they should be... that way later I can slap myself in...

Ok get the feeling I'm trying to paddle uphill here... What I was hoping to do (and it does not appear to be working) is to fill a listbox on the fly from an employee's table and then use the "EmpCode" listed in the code below later to properly fill a data field for a submitted meeting table...

Sorry been AFK... this is a Gridview(2.0) I always makes things much harder than they should be... that way later I can slap myself in the forhead after spending hours and hours on two lines of code and say to myself "DUH!"

Nothing going on in the rebind... Chris I always makes things much harder than they should be... that way later I can slap myself in the forhead after spending hours and hours on two lines of code and say to myself "DUH!"

What I've posted is the submit button code... and I am not doing anything on the pageindexchanging event... sooo... hrm not sure how I would go about rebinding but will play with that for a moment whilst you digest the above :) Thanks! Chris I always makes things much harder than they should...

Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim ConnectionString As String ConnectionString = System.Configuration.ConfigurationManager.AppSettings("appConnectionString") Dim cnnSql As New...

Good Morning All :) Well the problem that I'm having is that I've built a gridview of available employee information with the data coming from a stored SQL procedure linked to a submit button which retrieves the records I require. All of this works fine but I'd like to implement paging on the...

Thanks Jeb, Tried to repost in the ASP forums but they seem to be down at the moment (or busy) I'll give it another shot here shortly. I always makes things much harder than they should be... that way later I can slap myself in the forhead after spending hours and hours on two lines of code...

Good Morning All :) Well the problem that I'm having is that I've built a gridview of available employee information with the data coming from a stored SQL procedure linked to a submit button which retrieves the records I require. All of this works fine but I'd like to implement paging on the...

Have a gridview where I've written come vb.net code to highlight each of the rows etc. on the mouseover even and will want to process a click event on the gridview control but don't want to see the "select" column and would rather the user able to select the row just based on the highlighting...