October 27th, 2003, 04:34 PM
I'm new in Crystal Reports. I have a question..
I have a VB project, and on one form i have data in DataGrid.
This data are results of an SQL query. Database is Baza.mdb .
October 27th, 2003, 04:22 PM
Thank you doofusboy, Ismeteor and Twodogs.
It's working now, with your help...
October 27th, 2003, 03:43 PM
It says syntax error !
I don't know why...
Is it right to write BETWEEN and then another condition like txtSomething.Text??
October 26th, 2003, 04:59 PM
I would like to try another condition like this:
"SELECT * FROM Table1 WHERE Date BETWEEN " & Date2 & " AND " & Date4 & AND Name = & txtName.text & "
It doesn't work ...any idea ?
October 24th, 2003, 03:39 PM
October 23rd, 2003, 04:56 AM
Data type mismatch in criteria expression!
This is my code:
Private Sub cmdQuery_Click()
If (IsDate(txtDateFrom.Text)) And (IsDate(txtDateTo.Text)) Then
October 22nd, 2003, 02:52 PM
I have 2 fields:
Date1 = txtDateFrom.Text
Date2 = txtDateTo.Text
I would like to use this SQL query:
"SELECT * FROM Base WHERE Date BETWEEN &Date1 AND &Date2"
October 14th, 2003, 03:04 AM
Yes, but I want to call the data from database. Each Id has his own data. What is the connection for that and SQL?
October 13th, 2003, 04:16 PM
Hello, I'm new in VB programming and I need some help.
I have a Access database Base.mdb with some tables: table1, table2,... In this tables are some data with ID's (not autonumber).