Recent content by Bitaoo

Hello, I am using CR 9 and VB6. In my VB6 code I have CR viewer. I set RecordSelectionFormula when the forms come up for the first time and show the report to the user. There is a drop-down in this form that user can select form, so whenever user change the drop-down, I change the...

Thanks a lot. --Bita

Hello, I make a toolbar in Excel, but I don't want the user to be able to move this toolbar. How can I do that? Thanks a lot for your help, --Bita

Thanks a lot, it solved my problem. --Bita

Yes, I mean DOUBLE-CLICK. I could cover menu command too. --Bita

Hello, I got a problem. :) I tried to disable "Customize..." item from toobar list by the following code: Application.CommandBars("Toolbar List").Enabled = False But now I can easily open the "Customize" window by double-click on toolbar. How can I disable this feature? Thanks for any...

Hi, I found out that if I run the following code: Application.Commandbars("Worksheet Menu Bar").Enabled = False All the menu bar will diapears and also Minimize/Maximize buttons at the right top of winodw goes away. But I need to have the menu bar, I just need to disable Minimize/Maximize...

Hello, I have a problem and hope you can help. I am using VB6 and CR 9.0. I have a report in my program that has about 70 pages and it takes 75 seconds to be shown in Crystal Viewer (I connect to a remote server over the net) I tested this report in Crystal Reports 9 (outside of VB6), the time...

Thanks a lot Roy. That was great. :-) --Bita

I need to do it through a VB6 program. Thanks

Hello, I have a problem, I defined a column named First in my table by mistake and now I cannot delete this column, I think First is a reserved word in MSAccess DB, would you please help me to drop this column from Table, Here the statement that I am using: Alter Table ChartChoices Drop Column...

Hello, I don't know how can I set a code to be returned by my exe program. I have a VB program that runs another VB program in this way: Set oShell = CreateObject("WSCript.shell") nRet = oShell.Run("Test1.exe", , True) Set oShell = Nothing I want to check nRet but I don't know how...

Thanks, but it doesn't work. :( --Bita

Hello, I have a locking problem that I cannot underestand it. Would you please help me to find the problem? I appreciate your help in advance. I ahev a table named T1 with the following columns: Id --> Int primary key Name --> Char(10) R_Id --> Int ValCol --> Int Choice --> Int and here...

Thanks a lot.