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

  1. barrykellett

    Looping Issue

    I have a Football League database which stores several tables including a table with Team Details and a table which stores the results of fixtures of those teams. For Example, My teams table looks like this: TeamID SeasonID LeagueID DivisionID Name 1 1 1...
  2. barrykellett

    Formatting SQL in string format

    I am trying to use the following SQL code: SELECT t.Title, DCount('[username]','[guestbook]','[threadid] = ' & gb.threadid) AS CountAllReplies, gb.username FROM guestbook AS gb INNER JOIN thread AS t ON gb.threadid=t.threadid WHERE (((gb.Original)=False)) ORDER BY gb.thedate DESC , t.Title...
  3. barrykellett

    Custom Paging

    Thanks Adamroof, I have used this code sample but the data grid will not allow me to page. Says the datasource (I used a data reader) will not allow ICollection :( Anyone help?
  4. barrykellett

    Datagrid Checkbox

    ...Dim strConn as string = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source = c:\Inetpub\wwwroot\aspnet\diving.mdb" Dim sql as string = "Select * from Contacts" Dim conn as New OleDbConnection(strConn) Dim objDR as OleDbDataReader Dim Cmd as New OleDbCommand(sql...
  5. barrykellett

    Datagrid Checkbox

    Hi all I need to create a datagrid with a checkbox in each row which will allow me to choose the clicked row when i press a button on the form. Pretty much like the address book on yahoo email. Anyone with any examples? Ta BK
  6. barrykellett

    Custom Paging

    Does anyone have a simple example where a checkbox is displayed in each row of a datagrid and how do i access it so i can retrieve the rows data
  7. barrykellett

    Passing text box content

    I have an email page and a seperate page for choosing email addresses for the email. How can I click a button on the addresses page that will take the items in a text box in it and transfer them into the address bar on my main email window, closing the addresses window in the process?
  8. barrykellett

    Passing text box content

    I have an email page (In asp.net) and a seperate page for choosing email addresses for the email. How can I click a button on the addresses page that will take the items in a text box in it (A list of addresses I have processed in the asp.net code) and transfer them into the address bar on my...
  9. barrykellett

    Custom Paging

    Is there a way I can page a massive amount of items in a checkboxlist? Its a list of email addresses and its currently about 100 items long! I want to be able to select items in the check box list and then page to the following pages of checkboxes and choose more addresses. Thanks :)
  10. barrykellett

    Creating a count column

    Hi Scrivb, the first portion of SQL code you posted there works! Super!!! Thanks a million BK
  11. barrykellett

    Creating a count column

    Hi Scrivb, when i run the DCount query i get: You tried to execute a query that does not include the specified expression 'DCount(gb.username, "guestbook","[threadid]= " &gb.threadid)' as part of an aggregate function I have emailed you the database to the address on your profile to see if you...
  12. barrykellett

    Creating a count column

    Thanks scriverb, I have tried your SQL and it creates a column but counts one reply for each thread. I am trying to change it to get it to count correctly but not having much luck. If you like i could send you the .mdb file? Thanks again for your help on this BK
  13. barrykellett

    Creating a count column

    I am making a simple guestbook using an access database and have two tables, one with the thread title and one with all the thread replies. I use this SQL to create a table of thread titles: SELECT thread.threadid, thread.Title, thread.threaddate, guestbook.username, guestbook.ID FROM guestbook...
  14. barrykellett

    Creating a count column

    I am making a simple guestbook using an access database and have two tables, one with the thread title and one with all the thread replies. I use this SQL to create a table of thread titles: SELECT thread.threadid, thread.Title, thread.threaddate, guestbook.username, guestbook.ID FROM guestbook...
  15. barrykellett

    Recursive string creation

    Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Line 34: Line 35: Next Line 36: Stuff = Stuff.Remove(0,1) Line 37: If Stuff <> "" Then Line 38: Label1.Text = "<b>You...
  16. barrykellett

    Recursive string creation

    I had tried this, but if i place both lines inside the loop it produces addresses twice
  17. barrykellett

    Recursive string creation

    Hi, I have the following simple piece of code: For Each Item In ListBox1.Items If Item.Selected Then Stuff = Stuff & "," & Item.Text End If Next This Will create me a String of email addresses seperated by ","...
  18. barrykellett

    Working with system folders

    I need to produce some sample code which will produce a list of folders and sub folders and the files in these folders. Would anyone have a sample piece of code that would do this? I have been searching for a long long time on the web without much success for this.
  19. barrykellett

    Problem with recursive file listing functions

    I tried this and then the code just doesnt work! Did you read the article? Ive stepped through the code and it seems logical, i just dont understand why its flagging this
  20. barrykellett

    Problem with recursive file listing functions

    The below snippet of code: If includeFiles Then For Each pattern As String In filePattern.Split(";"c) al.AddRange(dirInfo.GetFiles(pattern)) Next End If Gives the error: Compiler Error Message: BC30451: Name 'pattern' is not declared. Source Error: Line 39: If includeFiles...

Part and Inventory Search

Back
Top