Search results for query: *

Hi all, I am trying to create a report using VB's report writer, that is similiar in style to an income and expenditure statement. I need it to select all the records in a specific table(Access DB) and then allow me to group hem using the group by clause. However once this is done the only...

Hi everyone, I have created a Vb application and have my exe which runs fine when run on the same machine it was created on. What do I have to do to allow this exe run on a different machine. It is connected to a microsoft access database which is on the same machine. I know I will have to save...

Hi SauerC, I am not sure what to store them as . I am using access so data field of type numbers I suppose, with some form of format setting on the type..Could you help me here please as I have never done this before. Thanks in advance jpb...

Hi there, Has anyone ever tried to enter a series of numbers in a textbox sparated by commas and stored the in the database, similiar to the way in which you would enter a selection of pages to be printed in a print dialog box. I cant find an examples of it done before and have failed to see it...

Rick, I have found what was wrong with my code. Before I called the AddNew method I was assigning the text properties of my text boxes to "" so when I pulled up the form on screen the boxes would be blank . But since the addNew method does this already then I was simlpy doing it twice...

Thanks Rick, Here is the error number. " -2147217842" Any ideas would be great as It has me very puzzled Thanks in advance jpb

Hi Rick, Tried that , but my problems seems to be purely with the Addnew method , I stepped trough my program and found that the update was being cancelled .UPDATE CANCELLED is my error what could be causing this does any one know..I have the same code in a few places in my code and it works...

Hi, I am using the addnew funtion associated with a recordset object to add data to a Table in my database... The table has an ID field which of the type auto number so each new record added is supposed to be added at the end of the table. However this is not happening..Instead each new...

Swany, I Tried that but no luck...still gives me the same error. It does appear as if the size of my application is being limited in some way, like you said because it will run it as it is but will not let me make it any bigger... Any other suggestions greatly appreciated.. Thanks in advance jpb

I have a lot of them ...is there a limit to the number I can create...can this limit be changed... I have about 60 forms in my project so I have about 100 connections...some of which are set at design time and some at run time

Thanks Swany, I am using OLEDB...not ODBC does this make a difference.. Also I have Alarge amount of design time controls in my project could this be a problem.. The project still runs perfectly ie..retrieves data from the database...but it give the error if I want to add new bound controls or...

I get this Critical error message when I try To assign the Datasource property of control ..at design time " ADODC1 Unspecified error"...box appears about 4 times.. after it is gone I cant assign a field in DB to a control..(Datafield property.) This has lead to this critiacl...

I get this Critical error message when I try To assign the Datasource property of control ..at design time " ADODC1 Unspecified error"...box appears about 4 times.. after it is gone I cant assign a field in DB to a control..(Datafield property.) This has lead to this critiacl...

How do I sort the group by fields in a data report.. An order by clause in my SQL statement bonly sorts the records in the details section not the actual group orders..

using data reports...I am trying to create a profit and loss account and balance sheet...I can get all the subtotal from the different accounts by grouping them ..ie..I have the total value for sales and expenses but am unsure as to how I am going to be able to calculate my net profit or loss I...

I am trying to print a profit and loss report using report writer....I have a table in my database which stores all the account details...name, balance type etc... I want to display this on the report as follows... Account Name (income) Balance . . Total...

I am trying to design a report useing vb report writer . The report is a profit and loss account. I have a table in my DB called accounts, which containds the account name , type(incom/expense) accumulated balance. I want to print the account name and their individual balances , and a total at...