debasisdas 580 Posting Genius Featured Poster

620

debasisdas 580 Posting Genius Featured Poster

620

debasisdas 580 Posting Genius Featured Poster

620 :yawn:

debasisdas 580 Posting Genius Featured Poster

I did n't mean to use horizontal scroll bar for actual display, just to set the value..

It is always better to design your own component for the purpose.

debasisdas 580 Posting Genius Featured Poster

Yes , exactly all that info you should have passed on in the 1st post of the thread.


empty row cannot be inserted.

the error message is self explanatory in nature.

debasisdas 580 Posting Genius Featured Poster

inserting from where ?

using what to insert ?

inserting into what ?

debasisdas 580 Posting Genius Featured Poster

What about using the Horizontal scroll bar .

debasisdas 580 Posting Genius Featured Poster

i am with the host.

debasisdas 580 Posting Genius Featured Poster

If you go through the very 1st post of this thread you will understand what code we are discussing here .

Here the code under discussion is Purely VB 6.0 only.

We are not going to .net and not trying to make that backward compatible.

debasisdas 580 Posting Genius Featured Poster

But how you set the value of the boolean variables ?

debasisdas 580 Posting Genius Featured Poster

Remove rs.Update from move methods.

that needs to be handled separately.

debasisdas 580 Posting Genius Featured Poster

This is VB 6.0 code ?

debasisdas 580 Posting Genius Featured Poster

Both are equally effective.

debasisdas 580 Posting Genius Featured Poster

Why can't you understand that since you are opening the same record set again and again on each click event of next and previous button you are always at the same record.

What you need to do is call the move methods of the recordset object that you have opened in the form load event.

debasisdas 580 Posting Genius Featured Poster

No one can snatch your job if you are competent enough.

debasisdas 580 Posting Genius Featured Poster

Check this sample code.

debasisdas 580 Posting Genius Featured Poster

when you select the combo
pass the code into another SQL and fetch the description and display in textbox.

debasisdas 580 Posting Genius Featured Poster

value member and display member are not available in vb 6.

debasisdas 580 Posting Genius Featured Poster

one question:--

Can a play belong to multiple team under any scenarios ?

debasisdas 580 Posting Genius Featured Poster

follow these steps.

1. populate the combo only (not the text box) from the recordset.

2. to populate the text --capture the value from combo and pass the same back to DB using SQL. Fetch the Description and display in a textbox.

debasisdas 580 Posting Genius Featured Poster

You need to write a recursive function to find and delete all the files of specific format.

Kindly post the code that you are working on currently.

debasisdas 580 Posting Genius Featured Poster

Then you need to work on your own assignment. Students are supposed to do that. I also did that in those days.

Show some effort to get any soft of here form our exports.

debasisdas 580 Posting Genius Featured Poster

what about implement the filter at DB level through SQL by generating and executing queries dynamically at run time.

debasisdas 580 Posting Genius Featured Poster

may be i will read this LONG question in weekends.

debasisdas 580 Posting Genius Featured Poster

620

debasisdas 580 Posting Genius Featured Poster

what exactly you wan to do in the application ?

debasisdas 580 Posting Genius Featured Poster

616

debasisdas 580 Posting Genius Featured Poster

Show the code that you are working on or just pay for the code you want ?

Coding is not a free service.

How much you can pay for the service ?

debasisdas 580 Posting Genius Featured Poster

618

debasisdas 580 Posting Genius Featured Poster

610

debasisdas 580 Posting Genius Featured Poster

Hi Leroy,

Welcome to Daniweb.

debasisdas 580 Posting Genius Featured Poster

610

debasisdas 580 Posting Genius Featured Poster

610

continuing.....

debasisdas 580 Posting Genius Featured Poster

So you want to populate the second grid based on the row you select in the first grid , right,

1. Capture the PK of the 1st table (when you select the row on the 1st grid)
ex--patient id

2. Use the same value to fetch data from the 2nd table, by using in the where clause.

Populate the send grid with the retrieved recordset / dataset.

debasisdas 580 Posting Genius Featured Poster

Is your data getting updated into the DB before yo invoke the report ?

Do you refresh the recordset once the data is updaetd in the DB ?

and finally what is database 2010 ? Is it MS Access 2010 ?

debasisdas 580 Posting Genius Featured Poster

Need more info to help you.

How the datagridview gets populated ?

What exactly you want to show ?

debasisdas 580 Posting Genius Featured Poster

Report , what report ?
Where you enter data ?
Is that connected to database ?
What database ?
How the report gets populated ?

?
??
???

debasisdas 580 Posting Genius Featured Poster

6 1 0

debasisdas 580 Posting Genius Featured Poster

610

debasisdas 580 Posting Genius Featured Poster

610

debasisdas 580 Posting Genius Featured Poster

610

ok, i will leave office early.:scared:

debasisdas 580 Posting Genius Featured Poster

oracle site says.

Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4)
Enterprise/Standard Edition for Microsoft Windows Vista, Windows Server 2008, Windows 7

and x86 means it is for 32 bit OS.


the file anme is
10203_vista_w2k8_x86_production_client.zip

because when that version of oracle was release, Windows 7 was not in the market.

debasisdas 580 Posting Genius Featured Poster

610

Welcome back

debasisdas 580 Posting Genius Featured Poster

England ?

Thea are not assured of a QF berth as of yet.

debasisdas 580 Posting Genius Featured Poster

604

debasisdas 580 Posting Genius Featured Poster

please clarify why you need to open the same recordset each time ?

debasisdas 580 Posting Genius Featured Poster

604

debasisdas 580 Posting Genius Featured Poster

workaround :-

Use a label instead of a button to avoid all the lengthy windows API calls.

and use RGB() to create color of your choice.

debasisdas 580 Posting Genius Featured Poster

before you jump into database or any coding the very first step is requirement analysis.

1. gather the requirement.
2. Plan a solution.
3. decide on front end/ database / system specs etc..
4. Design the DB.
5. Design the application.
6. Test it for proper functionality
7. .....
8. .......


and always need to have have a plan B.

debasisdas 580 Posting Genius Featured Poster

its so strange that i have uploaded my project to show you what iam doing and you are still asking to show you my effort???

the solution to the problem is simple arithmetic.

@satti

so far as uploaded the entire project file is concerned, i am here to share my knowledge because i love to do so but i do not open each and every file / attachment that i come across in net.