• Member Avatar for G_Waddell
    G_Waddell

    Began Watching Connect 3 Tables of Single Database to a Single Form using 1 ADO Control

    Iv 10 Tables consisting of atleast 10 fields each in a single Database. Bt, Im only able to connect 1 table at a time to a form using an ADO …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Connect 3 Tables of Single Database to a Single Form using 1 ADO Control

    You could `JOIN` the tables using [SQL Joins](http://www.w3schools.com/sql/sql_join.asp) in your query...
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching dir

    I have a dir list box db.Close 'Kill (App.Path & "\PhoneTel.mdb") our = (Dir1.Path + "\" + File2.filename) mitt = Left$(File2.filename, 12) ' phonetel.mdb SourceFile1 = our ' DestinationFile1 = …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in dir

    Hi, You should check that Dir1.path is not equal to the App.path, are you having an issue with the code?
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in How is the weather today in your country?

    Now lashing rain - normal service is being resumed...
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching How is the weather today in your country?

    How is your weather in your country? I am living in the Philippines and the weather here today is stormy and according to news, we are overloaded of typhoons in …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in How is the weather today in your country?

    Unseasonably sunny with a temperature of about 10 Degrees Centigrade in Ireland today
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching data source

    Hello. How can i know the data source of my sql 2008? Dim strconnection As String = "Data Source=.............;Initial Catalog=DatabaseConnection;Integrated Security=True;" How am i suppose to know the the data …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in data source

    Book mark the following link [www.connectionstrings.com](http://www.connectionstrings.com) It will explain and show all the different types of connections strings for you.
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching data table will not populate with complex sql select statement

    Below is the code I am using: Dim safe10_comp As Integer Dim ref_date As Date Dim dr As DataRow Dim dt As DataTable = New DataTable() Dim da As OleDb.OleDbDataAdapter …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in data table will not populate with complex sql select statement

    Hi, Your query is soo complex that the connection string is probably timing out. If you run that query in SQL (not through code but Management Studio,) how long does …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in inserting images to ms access database

    No Worries - remember to mark as solved!
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Christmas is coming

    Santa or father Christmas represents St. Nicolas.. However the red coat comes from a Coca Cola advert... He used to be green
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching Visual Studio 2013

    Microsoft is ALMOST giving this away to people who already own VS 2012 Pro -- just $99.00, compared to $400.00 price without VS 2012 Pro. There were a few changes …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Visual Studio 2013

    I have visual studio 2013 and 2012 and 2010 and I'd much rather develop in 2010. Hate the dull horrible interface THAT SHOUTS AT ME all the time in 2012 …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching How does one write the following statement correctly?

    Geeks, My client, an international online modelling agency, needs to state the following: "Age restrictions depend on the juristiction over your nationality". He has a section where applicants can apply …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in How does one write the following statement correctly?

    I just spotted another legal hole in the "contract" if a person is not legally allowed to appear in these photos due to being under the age of consent then …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching Christmas is coming

    Christmas is my favorite time of year. I love to go christmas caroling and my favorite eating a big christmas dinner.
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Christmas is coming

    Christmas is all a matter of perspective, for instance, for me Christmas is December 25th but it does actually not fall on Christs birthday (As Diafol pointed out, it was …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Bad Grammar

    > I think the rule of thumb with regard to h comes down to the hardness of the sound. A hard 'h' should be preceded by 'a', e.g. a hard …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching inserting images to ms access database

    Private Sub btnsave_Click(sender As Object, e As EventArgs) Handles btnsave.Click 'to check if the records already exists... Dim sqlQRY As String = "SELECT COUNT(namee) AS namecount from staff WHERE namee='" …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in inserting images to ms access database

    Hi, Does Access support binary data? If it does, [This link here is an example of doing it with MS SQL Server](http://net-informations.com/vbprj/dataset/insert-image.htm) If not, SQL Server Express is free and …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching vb net crystal report - The report has no tables

    Hello everyone. I would like to ask for your help, I've been stuck in this problem for wholde day. every time I run this code it gives me an error …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in vb net crystal report - The report has no tables

    Hi, I assume that your debugging msgbox shows there are row in the datatable, have you tried setting the crystal reports datasource directly to the datatable instead of using a …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching Picture Box Image browsing from Folders

    Hi Daniweb, I have posted the question before also but for more clarity I posting my question again. Request a quick positive response. I have googled a lot but not …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Picture Box Image browsing from Folders

    Hi, Have you attempted any of this yourself? Where is your code and what errors did you get? 1. Use System.IO to browse the folder 2. Use a menubar with …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching Collecting vintage video game consoles

    Any other collectors of vintage video game consoles on DaniWeb? Or am I really the only person sad enough to have more than 1000 of the things in my house? …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Collecting vintage video game consoles

    Nostalgic waves are sweeping over me.... My first console was I think called a GrandStand something or other - we are talking around about 1984 - it came with three …
  • Member Avatar for G_Waddell
    G_Waddell

    Gave Reputation to happygeek in Collecting vintage video game consoles

    I forgot to mention the fact that I have boxes full of ZX80s, ZX81s, Spectrums, Dragon 32/34s etc (working and non-working for spares)... We are beyond help, methinks.
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching we lose a good and nice man paul walker

    Hi freinds how are ? we lose a garte man paul walker i m so sad tel me about some paul walker plz
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in we lose a good and nice man paul walker

    The Porsche they were driving actually produces more power than an 1980's F1 car. Also, unlike most modern cars the GT4 is primarily built for the track not the street …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching Favorite fast food places

    So whats everybody's favorite fast food place/ restaurants
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Favorite fast food places

    The good old local traditional Fish and Chip shop! But not too often! When out after an evening drinking in Dublin (again not too often especially nowadays,) I tend to …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching Bad Grammar

    I can't take it anymore. At first it was only occasionally. Now it seems that every time I turn on the TV someone else is doing it. Doesn't our school …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Bad Grammar

    My main pet peeve is when an oh so helpful “spelling” program insists on marking up words as misspellings (or worse, “auto-correcting”,) when they are typed correctly because I write …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching Sad, sad news - Nelson Mandela passed away today

    Today is a sad day for South Africa, Africa, and the world; with the passing of Mandela there is an emptiness in the world that will be hard to fill.
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Sad, sad news - Nelson Mandela passed away today

    @jwenting One man’s terrorist is another man’s freedom fighter - Black and coloured people were terrorised in South Africa every day by the Police and the Army - they were …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching Filter listview using two datetimepicker with access

    I want to filter the values in the listview using the date range selected in two datetime picker. Here is my code: Dim reportstring As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Fe\Desktop\SADsystem\SADsystem\stockroom.accdb;Jet OLEDB:Database …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Filter listview using two datetimepicker with access

    Hi, Put a break point in where you generate your sql query and a watch on the SQL query. Now copy the query text into Access querybuilder in SQL mode …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching Trouble with code on add new record to database

    i am using employee table to test if i am doing the whole program correct. I have 5 buttons. one is to add records and another to save(commit), to update, …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Trouble with code on add new record to database

    Hi, Did you specify the [Update, Insert, and Delete commands](http://msdn.microsoft.com/en-us/library/tf579hcz(v=vs.110).aspx) for your dataadapter to use with the [Update method](http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update(v=vs.110).aspx)
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching ioexception unhandle.. the process is being used by another program

    Private Sub btnsave_Click(sender As Object, e As EventArgs) Handles btnsave.Click Dim com As New OleDbCommand() ' Try Dim fs As New FileStream(str, FileMode.Open) Dim data() As Byte = New [Byte](fs.Length) …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in ioexception unhandle.. the process is being used by another program

    Hi, It could be any process that has the file open - tell me, by any chance did you run through a debug on this process before that opened the …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in retrieve and display columns and rows of a dataview

    OR If you know the number of columns in the view then loop through the rows with a watch on each column in the datarow.
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching retrieve and display columns and rows of a dataview

    I am using .net framework 2.0. In immediate window running debug mode with VS 2008, how I retrieve and display all column names and the content of all rows of …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in retrieve and display columns and rows of a dataview

    Not straight off the bat, if you put a watch on the dataview you should then be able to see a count of the rows and columns... Then add a …
  • Member Avatar for G_Waddell
    G_Waddell

    Began Watching forecasting sales

    I am doing an academic project, making a sales forecasting using holt-winters forecasting method. I really need help to make it in vb.net and searching in google for example but …
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in forecasting sales

    Hi, Maybe explain the holt winters forecasting method? Is it a formula or a set of actions to be carried out?
  • Member Avatar for G_Waddell
    G_Waddell

    Replied To a Post in Retiring a Windows 2003 Small Business Server

    Thanks Tigergeek, Thats the joys of working in a small company, I'm a developer by trade but you have to be willing to try your hand at everything. I think …
  • Member Avatar for G_Waddell
    G_Waddell

    Marked Solved Status for Retiring a Windows 2003 Small Business Server

    Hi All, Two questions really: 1. Is Windows 2003 still supported? (With all the fuss about XP support ending, I'm not sure if I missed it) 2. We have an …

The End.