Search:

Fantastic
That's it.
Thanks a lot DataMiser.

Can anyone get me working code please.

When I double click on a file from windows explorer, it opens my program (as default program).

But, how I can I get the file path the file opens was double clicked (to open it)?

Example:
Take...

I think better you count characters other than lines

Thank you verymuch GaryMazzone and brucevde

sorry! ''muti-user'' - actually I mean multiple PCs.
I need to make a client server application. (A server PC and few client PCs on local network).
On the page...

Long time tried but cannot findout the answer on the net....

I am thinking of using SQL SERVER Free (express edition) for multi-user support (not more than 10 users).
Now the Question :
SQL...

I've worked with PHP mySql.
I need to show Items of the catagory without reload full page.


So how can i do it--
on click on a catagory - display its Items.

any sample code please.

---

Do you try to make a virus type something?

Or, you need a false Progress bar to display?

Yes VBFnewcomer

VB6, Crystal report 8.5
----------------------

I want to view a report file aaa.rpt from VB form runtime.
Is there any sample to use Crystal report 8.5 with VB6.
or the F1 Help file of Crystal...

there is no entry for each product everyday.
So we have to findout last entry for each product (max date and less than mydate)

Hack , PilgrimPete is right in the post 12

ok PilgrimPete, serviceID is actualy ClientID (no need service details except amount). Sorry, this is not my axact table (colum names are edited)

i was wrong in this reply

my collumns and data at the attachment

Id = text
serviceID = Number
Amount = Number
date = date
Serial = Number

I've tryed both and I like


SELECT serial, date, serviceID, Amount
FROM [b0prStk_Save]
WHERE Serial IN (SELECT MAX(Serial) FROM [b0prStk_Save] WHERE dInNum < myDDD GROUP BY ClientID)

But...

Thanks PilgrimPete,

I have to include a
WHERE dInNum<#" & myDDD & "#
I cannot complete It.

in table "b000" when a client get any serviece a row added hare.
collumns are = serial(unic serial number), date, servieceID, Amount.

Now I want to make a list off all clients with his last...

thank you verymuch PilgrimPete

Thanx PilgrimPete,

I want - "the maximum serial number of product y"
-----
thanx Hack, I'll try


.

do you like to use this



rst2.addnew
rst2.Field9 = rst1!Field1
rst2.update

vb6, ADO, Access 2000
-------------------
can I select more collum with max

rst3.Open "SELECT max(Serial),amount FROM [b000] WHERE
aa=" & bb & "", cn, adOpenKeyset, adLockPessimistic

thanx...

vb6, ADO, Access 2000
-------------------
rst3.Open "SELECT distinct(Products),amount FROM [b000] WHERE Serial<" & myDDD + 1 & "", cn, adOpenKeyset, adLockPessimistic

I want to add a max(Serial)...

with Reply#4
Is there any other way to detect that, is the table "Priorities1" Exist or not?


with Reply#5

Dim catDatabase As ADOX.Catalog
hare is an Error massage = "User defined typpe not...

Thank you very much to all

I want to create a table in a access 2000 db from my Vb6 application.
It will contain 3 collumn - ID(text), name(text), class(number)

Please help

Thanks for help and quick response

ok. but how can i detect double click?
and How to add a new row?

Thanks in advance

I have a flexgrid with 5 collums
(1) on click on 1st collum - label1.caption="clicked on 1st collum"
(2) on click on 5th collum - label1.caption="clicked on 5th collum"
(3) when I double click on...

I've worked with the dbGrid using Data control.
Hare I cannot use any Button to modify any row. So now I am thinking about flexGrid.

How can i connect a flexGrid with a access table?
Can I use...

this is that massage.

Yes, If I installed vb5 or vb6, then it can work.

no

Not right now. I'll tell the exact error message another day. (after checked by another PC)

I have a application working with Ms Access database.
I've made the setup.exe
After finished the setup process (in a new PC where VB not installed), when I run my application It massaged something...

But my Id column is not unique. What to do Now

I need the Learget "Amount" only (i mean 1 result only), but it returns all rows

Thanks brucevde, GaryMazzone

do you mean create

I think there is no probelm to create 10 table in a database, i've worked with more.
and
I think also no probelm to open 10 table at a time. Do you feel any problem to open...

VB6, Access2000


rstAAAA.Open "SELECT Amount,Max(id) From [table]
WHERE otherID ='" & myid & "'", cn, adOpenKeyset, adLockPessimistic
It returns Error massage:
"You tried to execute a query...

i've solved