use

dataenvironment1.command1.cursorlocation=aduseclient

then show your report

please open a new project in vb and add all your forms and instances one by one and keep saving them in a new location......also add all components and references used in the project earlier.......it...

hello all,


Is there some way that i could create a menu just as we all use in various applications that pops up on mouse right click event with loads of options.......it would surely help me...

use
"date1 between #" & format(dtpck1.value,"mm/dd/yyyy") & "# and #" & format(dtpck2.value,"mm/dd/yyyy") & "#"

and so on

where exactly are you using this

"from 01-06-09 to 05-06-09"

is it in the title. Then simply use a string variable like
datareport1.title="From " & dt1 & " to " & dt2

try refreshing your connection.....ADO ....RDO whatever u r using

use inner join in SQL.....it is available as a sample example in MSDN or anywhere on the net

similarly, for the next transaction try and insert the relevant record into table2 and then delete it...

If you are using Access 2003 or below please add references for ADO 2.1 library if u r using ADO or DAO 3.51 if using otherways.............

why i say this is 'cause i personally don't have time to read all the posts just to find datareports or API's again and again.............what i intended was just to group them up so that reports and...

please post the code as used with the form and connection for a clear perspective and solution

i need to look at ur report first................ meanwhile try to set "cangrow" propert to true for fields in ur report

try this then...........

Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open ("select * from det order by srno"), db, adOpenDynamic, adLockOptimistic
If rs.RecordCount > 0 Then...

use this.........

Private Sub Command1_Click()
'********i just assume ur connection is in form_load..............this is just for the query
Set db = New ADODB.Connection
db.CursorLocation =...

i need to look at your code......if u don't mind or some NDA is not violated

Please set left and right report margins to minimum when designing the report......use pageset only if u change orientation frequently in your application.


Regards

DSP

Good evening.....

I just wanted to share an idea.....can this forum be downsized into categories such as API,FORMS,CONTROLS,DATA REPORTS and so on.....the reason i am saying this is people are...

i can't see the attachment

use this

DataEnvironment1.(your rscommand name).Properties.Refresh
Dataenvironment1.(your rscommand).open
show you report here
Dataenvironment1.(your rscommand).close

Regards

DSP

How many fields are you displaying in a single row???? try and set left and right margins accordingly....keep left margin 0 and right margin 10...try it...

If it does not work....then you have to...

please post your code for us to view first.....

please install crystal reports on the dependent machine as well or ensure that you have the required dll and ocx in your folder and register them accordingly using regsvr32.exe

Boss please upload your project for everyone willing to help u to see the issue and resolve it accordingly.........as far as i can judge from your writing is that your labels are too big and thus the...

just add values to a tmp table and call it to populalte the grid. Every time you press ADD just call the REQUERY function. for details search datagrid threads

what do you need it for?? As far as i know i can multiselect items and do corresponding events without any issues

sure!!! what do u need just let me know

my view is that create a tmp table for your values and populate the grid. see my references for data grid in other post. if not clear then please post ur code and i will look into it.

slow down the process by shifting focus to some other event say a progress bar or just a blank screen for 5 or 10 secs and be sure that your connectivity is in order or the database is in the same...

do this

DataEnvironment1.(your rs_connection).Properties.Refresh
DataEnvironment1.(your rs_command).Open
Datareport1.Show vbModal
DataEnvironment1.(your rs_command).Close

use long format option

current time (long format)

Regards
DSP

try this

'this is using DAO 3.6 object library and access 2003
Dim db As Database
Dim rs As Recordset

Private Sub cmbnm_Click()
If cmbnm.Text <> "" Then
If rs.RecordCount > 0 Then
...

I agree with veena......compile to p-code (psuedo code)....it is faster and more efficient in porting data from comp to comp

PLease be clear.............you say restart your comp ???? it implies you have some issues regarding oracle installation......if not then simply create a module and call it in form_load
the module...

try this
'declaration section
Dim db As ADODB.Connection
Dim rs As ADODB.Recordset
Private Sub Command1_Click()
'now calculate the sum you require step by step or you can create multiple...

you need to break up execution time in order for the records to populate into the dataenvironment.........simply put try adding a progress bar on a new form and run it before datareport.show

Do this

Private Sub cmdSearch_Click()
Dim Searchit As String, Founder As Boolean
Searchit = UCase(InputBox("Enter Item code:"))
If Len(Searchit) > 0 Then
'add this line
Adodc1.Refresh...

What i would do for a similar concept is create a procedure named loadlist and write all the coe to populate list with table records. Later where ever required...like for example when u press accept...

Why don't u use ORDER BY (fieldname) is ur sql query it will definately solve ur sorting and refreshing issue.


Regards
DSP

I often use dynamic grid posting in my applications try this :


Set con = New ADODB.Connection
con.cursorlocation=aduseclient
con.open= "Microsoft.Jet.OLEDB.4.0; Data Source = " & App.Path &...

Please connect your Adodc1 to the database and table first and then run this query

First of all...........is it an exe file with database that u r running on another comp????if yes, please try and load vb6 on the other comp with crystal reports....and compile on that...