Search results for query: *

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

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

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?

I actually found a solution to the datagrid of checkboxes where i can choose items and click a button to get the relevant values, but the datagrid will not let me page. The error is: AllowCustomPaging must be true and VirtualItemCount must be set for a DataGrid with ID MyDataGrid when...

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

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

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?

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

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

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

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

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

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

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

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

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

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

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.

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

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