Posts by abu taher

any body help me please

I don't mean that. I have no problem with field name. I mean the 'nine'. you fixed it. If I write 'ten' then it show the last roll of class ten.
I want in vb project I write nine then show last roll of nine or I write ten then show the last roll of class ten.

I write code for three date like:
SELECT * FROM Table1 WHERE (Date1 AND Date1 BETWEEN DTP1.Value AND DTP2.Value) AND (Date2 AND Date2 BETWEEN DTP1.Value AND DTP2.Value) AND (Date3 AND Date3 BETWEEN DTP1.Value AND DTP2.Value)

But it not work.

SELECT MAX(roll) AS THEMAX FROM TableName WHERE class = 'nine'

yeah this code work well. but a few thing. here you write class = nine, but it will be change by my vb project. if you fixed then how I get result by changing class?

here it show the last iValue order by iID. but it not similar with me. I mean iID may be various. Like:

class roll
nine 2
ten 5
five 7
nine 3
ten 6

I mean it sorting by class. it show the last roll of every class. like:

class roll
nine 3 ' the last roll of nine
ten 6
five 7

in vb6 I want i write ten (in a textbox) and the roll will come (other textbox) automatically.

I don't understand this. help me.

any body help me please

all this code is for vb6.

to enter a data in textbox:
place a command button and data object and connect the database write code in command button.
"data1.recordset.addnew"
this code save data in the database.
data1.refresh
it update data.
connect the listbox with database. for search data write this code:

Dim Searchit As String
Dim Founder As Boolean

Searchit = UCase(InputBox("Enter name:", "Edit"))
If Len(Searchit) > 0 Then
'add this line
Data1.Refresh
Data1.Recordset.MoveFirst
Founded = False
End If

Do While (Not Founder) And (Not Data1.Recordset.EOF)
'u can add UCASE i just removed it for my query
If UCase(Data1.Recordset.Fields("name").Value) = Searchit Then
Founder = True
Exit Sub
End If
Data1.Recordset.MoveNext
Loop

If Not Founder Then
MsgBox "Unable to find the required item", , "Not Found"
Data1.Recordset.MoveLast
End If

Ok. vb5prgrmr. you mean they need a relationship. If i make a primary key both table then I think It will solve.

How can I show my data in a combo box. I need help . anybody help me.

Table2
iNameID Number Foreign Key

here foreign key mean............? please explain

u can use it so easily. double click on combo box from toolbox. then it automatically set in your project.

I made a Data report. I write code like:
select *from table1 where date1 and date2 between dtpicker1.value and dtpicker2.value
but the data not show in report. but when I write like:
select *from table1 where date1 and date1 between dtpicker1.value and dtpicker2.value
then data show. what problem? another thing I used three date and I want all data of this three date will show in report.

please check it.

one thing, why you want to use excel? access is better.

please check and try the attach file.

lot of man come here to learn many thing. so don't worry. Dezirous give you the answer. so check it. good luck.

I made a queiry. but every data show in this queiry double. I mean every data show two time in this queiry. why this problem occured. any body help me please.

I made a datareport. I select a date from dtpicker and the datareport show that date data.
here I want the selected date (by dtpicker) will show in the report.
like:
05-06-09
or
from 01-06-09 to 05-06-09
any body help me please.

and if you it increase auto then check under check box.

and if u hide the 1st form then write
me.hide

or

form1.hide

please write the full code

1 problem. here only show the last roll. but I want when I enter ten then show the last roll of class ten.

another thing , I use this code in that query?

you mean I make a query where have only the roll field. and I use this code against that code?

I use this code. but it not work. the last roll not show in text box automatically.

I don't understand.

Thanks for details help. Its helpful for me.
>>Now, I know that does not solve your problem but you have the hints in the add new button on how to find out how many students are enrolled.
u right. but how i find out how many stdent..........please help me. fristly you told me to make a query. so please

If don't mind can you modify my attachment. please..............

at 1st: class name entry in a text box (by add new button). access file is store it. then in a another form (when a student admitt) enter all data of this student (in few text box) without class name. when I want to entry the class name then I press enter button and then a form show with msflexgrid and the msflexgrid show that data what I entry at 1st.(I doit for save the time).
however, here I want, a student admitt in class nine. his roll is 01
I entry it manualy. and class name entry by that way. second time another student admitt in class ten. roll is 04. I want when I enter class name the roll no. will entry automatically. I mean I enter class ten the roll will 05. (the last roll will show, cause I don't know what was the last roll in every class). How can I do it. help me any body please.

I didn't creat any install file. just creat exe file and try to run it another pc. every thing is ok but when I want to see report then show this msg. but when I install vb6 that pc then it run well. no problem occured.

but this code not work properly. did you check it. If you check it then please modify it.

the data store in ms access file. it connect by data control.
[QUOTE=Jupiter 2;878098
How do you view the output? example in a textbox on the form.[/QUOTE]
output show in report. if I edit the data then it show in the text box.

its a databse project like student databse. I add some data. and then when I want to see report then show this error. the report made by vb6.

did you use any backend file? like access or other. or you want to do it one time? just input customer type, number of books purchased and cost of each book and then get the result?

Many programmers are removing components for demo or trial products. This might be your only option.

don't mind. I need a easy way. so I start this theard. help need.

You need to pass more information.

what kind of information you need. please ...

I made a database project. when I run it another pc it was run. but when I see the report (in my project) it show a error msg.
it is :
error number: 713
application defined or object defined errro.

another thing it is exe when i run it another pc. any body help me please.

check it

I attach a file. In this file I make a querie. all the (data) field of both tabel show in the querie. I want all data will add up in querie.
I mean a calculate field. like : (200,200,300) this amount was in both table. in querie it will show 700.
any body can help me with modify this attach file.

try as like debasis. he said easy way.

I want to make a data report. I write a name (like: taher) in a text box then press a button and then (taher's) all data will show. how it possible? I want it many ways. like name, ID, date. I mean I write name or ID or date and then all data of this ID or date will show. any body please help me.

you use win 98 se. db is 2002. db 2002 is upper version from win 98. so it show that msg. u need win xp.

help me

I think same as vishalgupta9x .

you can connect msflexgrid with the database.

Private Sub Form_Load()
Dim ExpiryDate As Date
ExpiryDate = "14-04-2009" 'your program expiration date
If Now() > ExpiryDate Then MsgBox "THIS PROGRAM EXPIRED": Exit Sub Else MsgBox "CONTINUE..."
End Sub

you fixed a date. but I want it auto create. when the exe 1st run it create the file with current date what said crackerjacker . how it work by your code? can you help me please?

FlamingClaw
wow. Its out of my range. you are you are so so so work hard. its realy helpful.

debasis can you help me more.
where I use this code. you make a function. and I mean where I will call it?