Search results for query: *

dear all, i have created an application in vb6 and i created a help file for this application using Microsoft visual studio 6.0 tools -> Help Workshop. I wrote the rtf file in times new roman font and generally the document is in Greek with Greek characters. When i save and compile the project...

hello all, i relativelly new in vb6. I have a form that user types values for fields of a table, then another form displays the results if the record/s exist. I also created a data report shows these results and my purpose is to print the datareport. I didn't use data enviroment at all but ado...

hello everybody, I am new in vb6 and datareports too. I am using vb6 and i am trying to display a data report based on an ado shape sql query. My query collects fields from table orders and table orderDetails and the 2 tables relates with OrderID. My problem is that when i display the report in...

Hello, i am trying to display a data report assigned on user's criteria. My problem is that when the search_invoiceRep appears, appears a message box too, says ERROR Datafield 'ORDO2' NOT FOUND. I had a look to forum but i didn't found something to help me. I haven't understood what causes this...

Hi all, I am getting a runtime error Invalid Sql Statement, expected 'DELETE','INSERT','PROCEDURE','SELECT' OR 'UPDATE' sql= "Select * from Orders " & _ "where OrderID like " & 'ORD02%' & _ " and ShipName like " & '%' sqlOrdDet = "Select * from OrderDetails " & _ "where OrderID='" &...

hello all. I have created my database with Visual Data Manager -> Microsoft Access -> Version 7.0 MDB I am using VB6. i am using a sql query in code of my application with where clauses. My query is like this: "select * from orders where OrderID " & _ "like '" & FuncTxt.Text & "%'" The...

hello everybody. I am using vb6, I created a data report with data enviroment and the what i want to do, is to display a record by page. I mean in the first page the first record, in the second page the second record etc. Does anyone know about this? Thank you very much.

hello everybody! I have created a sql query in visualdata manager of vb6 "SELECT sum(OrderDetails.ProdSumPrice) as totalSum from orderDetails group by orderID;" saved as sumPriceQry. It calculates the sum price of all products a customer has ordered. I am trying to create an invoice report with...

hello everybody! I have created a sql query in visualdata manager of vb6 "SELECT sum(OrderDetails.ProdSumPrice) as totalSum from orderDetails group by orderID;" saved as sumPriceQry. It calculates the sum price of all products a customer has ordered. I am trying to create an invoice report with...

Hello all. I am new in Visual Basic 6 and i need your help. I am creating an application which handles a database created with Visual Data Manager (Microsoft Access Version 7.0 MDB). I use ado recordsets in my source code. I have an invoice form represents the data in text boxes and flexgrid...

Hello all. I am new in Visual Basic 6 and i need your help. I am creating an application which handles a database created with Visual Data Manager (Microsoft Access Version 7.0 MDB). I use ado recordsets in my source code. I have an invoice form represents the data in text boxes and flexgrid...

Hello all. I'm using adodb recordset in vb6 for my application in vb6. My operating system is Windows XP SP2. I execute my program and it executes fine but in one point it gives me "binding collection error Field not updatable, Bound Property Name: text, FieldName:ProdID" This error message...

i'm gonna use an sql variable which type is string to determine in my code my sql query. i' m trying to declare it static in general declaration: static sql as string but when i push the start button to run it causes me a compile error invalid outside procedure. How can i declare it? I want it...

hello i am new here and i need your help i am a new programmer and i programming in visual basic i declare an adodb recordset in my code like this dim rs as adodb.recordset in form load: i open the connection, i open the sql query with the rs object Set rs = New ADODB.Recordset rs.Open sql...