Search results for query: *

  • Users: fie
  • Order by date
  1. F

    Connection Property has not been initialised

    dear friends please help me. I have a table called tblclass that contains 3 fields in SQL database fclasscd int fclassdesc nvarchar fcono int I created a form in sql that will link with the table i have done all i know that could make me link the table but it is always...
  2. F

    Linking a form VB.Net to SQL Server

    connection property has not been initialised Thanks your response, but the problem still persist. I have greatly improved on form design and it is very encouraging, however the same error still persist on the form below. I have done the connection string properly the way you suggested. kindly...
  3. F

    Linking a form VB.Net to SQL Server

    I am new to VB.Net. Please help me I have an SQL Server recident on my system and I am writing a VB.Net program to link the SQL database called books. I have designed a form with 3 fields and the table called Authors which contain the following 3 fields. 1. Authorid: int 2. Firstname...
  4. F

    Crystal Report Design

    Hi Dav, Thanks for your response. I guess you have seen my report. I am attaching the report design features, may be that would throw more light. Thanks Fie
  5. F

    Crystal Report Design

    Crystal Report design Please find attached a sample copy of what I am trying to talk about The detail line falls within the range of @startdate and @Enddate range and the Balance bf is positioned at the Account Number Grouping line. I tried editing the Balance bf field as follows...
  6. F

    Crystal Report Design

    Pleeeeeeeeeease I need your help greatly and would appreciate your kind assistance. 1. tblAgt - Table fconsole numeric fagent 2. tblDebit - Table fmending Date field AccountNo fagent...
  7. F

    Crystal Report Design

    Please i am new to crystal report design. I need your help I have designed a crystal report from VB.Net that has series of columns (fields) generated from the following two tables. 1. tblAgt - Table fconsole numeric fagent 2. tblDebit -...
  8. F

    Select Command in VB.Net GUI form to relate with SQL Server

    Help- Crystal Report Please i am new to crystal report design. I need your help I have designed a crystal report from VB.Net that has series of columns (fields) generated from the following two tables. 1. tblAgt - Table fconsole numeric fagent...
  9. F

    Reference Another Project

    Hi everyone, could you help me pls. I have a 2 projects in a Solution Explorer written in VB.net 1. series of Data Entry Screens connecting to SQL Server 2. reports in Crystal format I have a GUI Menu form to link both I have succeeded in linking the Data Entry Screen but could not...
  10. F

    Binding A Combobox To A Foreign Table

    Hi, Pls is there anyone there who could help me. I am a learner of VB.Net, I have a form that contains series of textboxes that includes 2 comboBoxes that are linked to a table (tbldebit) but I want the 2 comboBox to be linked to two different tables (tblBranch and tblclass) so as to display...
  11. F

    Binding A Combobox To A Foreign Table

    Hi, Pls is there anyone there who could help me. I am a learner of VB.Net, I have a form that contains series of textboxes that includes 1 comboBoxes that are linked to a table (tbldebit) but I want the 2 comboBox to be linked to another table (tblBranch) so as to display the contents of that...
  12. F

    Select Command in VB.Net GUI form to relate with SQL Server

    Linking a ComboBox on a GUI form to a Table Yes trying to link up with another table in SQL Server Database
  13. F

    Select Command in VB.Net GUI form to relate with SQL Server

    Linking a ComboBox on a GUI form to a Table Hi, Thanks for teaching me all that I have known. I am so happy but I just discovered that comboBox creation is not all that easy. Please I have searched through the thread for relevant combo experience for beginners but found none. On my form...
  14. F

    Select Command in VB.Net GUI form to relate with SQL Server

    O dear, I so greatful, it was a mistake on my part, I just realised that I had increased the with of the username instead of the password in the database and immediately I changed it it worked. Thank God. I can now smile Thanks! Thanks! Thanks MY PROGRAM IS WORKING FINE. Good to have a...
  15. F

    Select Command in VB.Net GUI form to relate with SQL Server

    Hi Good day, How was your weekend? Yes I did what you asked me to do, 1. I reduced the size of the password field in the database to 20 2. also set the MaxLength properties on the GUI to the same size with that in the database 3. Run the program It din't work initially, so i wandered what...
  16. F

    Select Command in VB.Net GUI form to relate with SQL Server

    This is what I have in the table tblpassword Column Name Data Type Length UserID nvarchar 3 UserName nvarchar 8 Password nvarchar 50
  17. F

    Select Command in VB.Net GUI form to relate with SQL Server

    This is what I did pls Try UserOleDbDataAdapter.InsertCommand.ExecuteNonQuery() Catch Ex As System.Data.OleDb.OleDbException MessageBox.Show(Ex.ToString) Catch Ex As Exception MessageBox.Show(Ex.ToString) End Try the error I got System.Data.OleDbException: Statement has been terminated...
  18. F

    Select Command in VB.Net GUI form to relate with SQL Server

    The error is An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
  19. F

    Select Command in VB.Net GUI form to relate with SQL Server

    Thanks I am been handled by another genius like you name TechGnome and I think am on the right part I appreciate you. Fie
  20. F

    Select Command in VB.Net GUI form to relate with SQL Server

    Oh my God, what have I done wrongly again. Can't understand why the Insert command that was ok before is now giving problems again. I am so sorry for bothering you. I must say thank you for your patient. I am so greatful I can see my fault gradually. I really really appreciate you. Thank...
Back
Top