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 Rhinorhino 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: *

  • Users: Gill1978
  • Content: Threads
  • Order by date
  1. Gill1978

    Display of query result set

    Hi, I have a sql query (stored procedure) that returns a set of results as follows: Date [Count Post Midday] [pre midday] Heldover ------------------------------------------------------- 1/07/2007 0 2 1 2/07/2007 0 0...
  2. Gill1978

    Change results of query

    Hi, I have a query (below) that displays all the dates of a given month and a count of messages inserted into a table on each day of that month ie. Date Count -------------------- 1/07/2007 0 2/07/2007 0 3/07/2007 5 4/07/2007 10 5/07/2007 0 However is...
  3. Gill1978

    Query to bring back every day of month

    Hi All, I have a query that brings back a count of a field in a table grouped by Process_Date. This brings back the right count but if for some reason nothings processed on a particular day of that month it doesn't bring back a data row for that day. What I would like is for the query to bring...
  4. Gill1978

    Excel in Access Report

    Hi, What I'm trying to do is create charts in an Access Report. My thoughts on this was to create an embedded excel chart in an Access report ... the excel chart would use a stored procedure that is located in the sql server back end. What I'm stuck on is how to actually link the stored...
  5. Gill1978

    How to embed Excel chart

    Hi, I have a sql server stored procedure. What I need to do is use this stored procedure to create an excel chart that will be embedded into an Access report. I'm not having any luck in finding how to do this bit ... though I've got some info on how to manipulate the chart once its embedded...
  6. Gill1978

    Stored Procedure to run in excel

    Hi All, I have a stored procedure that I need to run in excel to create a chart, which will be saved as an object in sql server ... does anyone know how I go about this? Really have no idea ... please help! Thanks Julie
  7. Gill1978

    Display excel chart in Access Report

    Hi All, I need to display an excel chart (that is saved in a sql server table) in an Access Report? Can anyone tell me how this is done ... I have no idea??? Any help would be greatly appreciated? Thanks Juiie
  8. Gill1978

    Starting Actuate

    Hi all, I've just been handed an Actuate project, bearing in mind my back ground is SQL Server/ transactional database's. Having a look at the Actuate overview, this is based on OLAP and cubes. The point of the project is to load data from a sql server to an actuate server (is that right) ...
  9. Gill1978

    split div tag into 2 sections

    Hi all, I've got a div tag within in a header, and I'd like to split it into 2 sections next to one another. However whatever I try the sections go one below the other. Can anyone help ... been a long weekend I think ... <div id='wrap'> <div id='header'> <p align="left"><img...
  10. Gill1978

    Sql server dropping connection with Access view

    Hi there!! Havin a right mare of a problem with a linked table (generated through vba code in Access). When I run this code it opens a form with data retrieved from a view in sql server. There is a button on this form that when clicked is used as a search form and uses the same view (which is...
  11. Gill1978

    Access losing connection with SQL Server intermittantly

    Hi there!! Havin a right mare of a problem with a linked table (generated through vba code in Access). When I run this code it opens a form with data retrieved from a view in sql server. There is a button on this form that when clicked is used a search form and uses the same view (which is...
  12. Gill1978

    Turn ListItem into Link

    Hi, I'm trying to turn a checkbox listItem into a hyperlink which will open the document when the users clicks it. Does anyone know how to do this ... i've tried puttin a hyperlink tag around the text but this didn't work. Here's what I have: <asp:CheckBoxList AutoPostBack="true"...
  13. Gill1978

    Text box value into Powerpoint presentation

    Hi, I have a web application that merge's powerpoint presentations into one new file which is saved to the Network. I'm using interopt to do this ... However I need to copy text box values from the web page into th first slide of the new presentation. Does anyone know how to go about doing...
  14. Gill1978

    Pass ListBox Items to an array

    Hi, I'm very new to C# ... so I don't really know how to interpret potential solutions ... like the one below given below: Not sure what the <string> bit means ... do I pass the name of the ListBox (which contains the collection I need to pass) ... or is this a new variable? protected void...
  15. Gill1978

    Checkbox event handler not working

    Hi, I got a list of checkbox's that when the user selects/ deselects them the OnSelectedIndexChanged is fired and the value of the checkbox(s) should be copied into the listbox. However the eventhandler isn't being triggered. This is what I have so far: aspx page: <%@ Page Language="C#"...
  16. Gill1978

    How to add checkbox values to list box

    Hi, Does anyone know how you can add the value of a checkbox (selected by user) to a listbox in the order that the user selects. The users will select from a list of files in directory, and the locations will be added to a collection. Any help with this would be much appreciated. Thanks J
  17. Gill1978

    Programmatically merge powerpoint presentations

    Hi all, I'm trying to figure out a way in which I can get a powerpoint macro to automatically (based on file selections made on a .NET front end), merge the selected filed into a new powerpoint presentation. However, since I've never worked with VBA - have no idea whether this is possible or...
  18. Gill1978

    Replicate windows explorer

    Hi, I'm trying to create an app which shows the user a windows explorer tree in a box which the user can select files that once selected will move or be diplayed on box containing all selected files. I have no idea how to accomplish this ... have surfed the web for a hint ... but so far come...
  19. Gill1978

    Dynamically set the title of page through code behind

    Hi All, I've got a sqldatasource bringing back the value (field name: FullName) that I need. I've got this so far in the code behind Protected void Page_Load (object sender, EventArgs e) { Page.Header.Title = } How do I set the title to the value being brought back from the...
  20. Gill1978

    Changing the DefaultMode of a FormView

    Hi, I'm trying to change the DefaultMode of a page (e.g Page2.aspx) from Edit to Insert when a user selects a button in another page (e.g. Page1.aspx). In the rest of the application Page2.aspx should always run in Edit mode except for the above occassion. Can anyone point me in the...

Part and Inventory Search

Back
Top