debasisdas

try to use this as connection string. [B]Provider=OraOLEDB.Oracle.1;Password=tiger;Persist Security Info=True;User ID=scott;Data Source=orcl[/B] hope that solves your problem.

The problem for you is others should only be able to select records not change ,right. Its so simple you need to grant only SELECT previlege on that specified table to the users not full access.

Nice explanation.

First you need to establish the connection witht he database. Then only you can execute some SQL commands for all the operations.

If you are using crystal report viewer to display the crystal report just enable the export button from the property pallet of the crystalreport viewer.

Please follow the steps. 1.Add to master table 2.commit the transaction. 3.Add to Child table and commit.

Kindly post what you have done so far. Post where you are struck.

.CPP and .H files can't be directly referenced fronm VB. compile to .DLL file and then instanceate in VB.

there is no problem with the query . You might need to change the join condition . Kindly post both of your tables structure for more details.

INDIA My country.

Make the variable storin g the username a public variable in a standard module.

No way you can trap the events of Win Key using Vb 6.0. that is a special key for which microsoft provides no methods to handle that.

May i know how can i help you . Do you expect me to do the project for you ?

its better write your own function for the purpose with all the formattings.

Kindly post your code for reference of our experts.

Kindly post your question in pure English only.

instead of using 3 combo boxes use DTPicker control and then find out the .Date .Month .year property of the control.

Try this [code=vb] select tf.time_id from tf where(((tf.rac_id= "'" fac_type & "') And ((" & tf.reserv_date)= " & booking-date & "))" [/code]

Try to use the [B]Listindex[/B] of the item else try to use [B]ItemData[/B] property of the control.

How do u expect all that here in a free forum like this.

Find out the dfference between both the dates using Datediff. then apply the logic U want to implement.

kindly post your table structure for further details.

Check for existance of username and the corresponding password in database using SQL. Try to use count() . If it is 1 then login else prompt to enter the correct username and the corresponding password.

try to use the RND fuction with the total no of records (using COUNT) as the max value. teen use MOVE method to move to that particular record no. NOTE:- that might repeat the same record.

Your question is already replied in the other thread.

simply try this [code=vb] MsgBox Day(Now) & " " & Month(Now) & " " & Year(Now) [/code]

check the system time at a particular time interval using the timer event. Whwn the time is required time call the Procedure.

simply u need to trap the start and end date of the month and run a BETWEEN query in the database using ADO to get the output.

Try to use [B]UNIQUE[/B] for [B]field6[/B]

Choose a topic on which you have minimum knowledge of the requirments of the application.

You can call the commondialogcontrol.showsave on a timer event. But that is not a good option to ask the user to save very frequently. why dont u call the same at the end (at the time of closing).

Try to use [B]GetChunk[/B] and [B]AppendChunk[/B] method of recordset object of ADO for the same

if u are using crystal report viewer to display the report then set the [B]EnableExportButton[/B] property =true.

what is the database you are using ?

Use suitable joins to retrive data from multiple tables.

Join both the tables using SQL command and display the output on grid.

The error message itself suggests the reason of error. U need to specify complete path of the file. Else u can store the file in the path of the exe and specify App.path in the code to avoid this error message.

can you kindly post your table structure for reference of our experts in the forum.

It is always recommended to use [B]Oracle Provider for OLE DB[/B] or [B]Microsoft OLE DB provider for Oracle[/B] not using the DSN for connection to Oracle from VB .

please specify the problem clearly. Waht do you mean by a [B]list[/B].

Yo can't modify the existing one. Try to create your own component with desired options.

Hi Seth Welcome to Daniweb. Hope you find the forum useful.

Try to implement the search logic using SQL .

try to use [B]FileSystemObject[/B] for the purpose.

Try to use the crystal report viewer to display the report.

try to use TRIM before using MID

Hi TLEGEND Welcome to Daniweb. Hope you find the forum helpful.

try the following code [code=vb] Public Sub DailyReportDisplay(Query As String) Set CRXReport = CrystalReport2 Set CRXDb = CRXReport.Database CRXReport.DiscardSavedData inti = 1 Do Until inti = CRXReport.Database.Tables.count + 1 CRXReport.Database.Tables.Item(inti).SetLogOnInfo strdblocation, "das", "debasis", "debasis" inti = inti + 1 Loop CrystalReport2.SQLQueryString = Query With FrmReport .Show .CRV1.ReportSource = CRXReport .CRV1.ViewReport …

Please post what exactly is the error that you are facing.

Its really very difficult to suggest from here without having the knowlwdge of actual requirment at your side. I would suggest you instead of storing them separately ,store with some flag setting as a single entity.