Search results for query: *

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...

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

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...

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...

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...

Hello, I have a problem, I wrote this code for getting BIOS information but it is not working on Win 98, Do you have any idea why it doesn't work? Function Get_BIOSSerialNum() As String Dim strComputer As String, S As String Dim objWMIService As Object, colItems As Object, objItem As...

Hello, I have a question and hope you can help me. I want know how I can get the Low Level Hard Drive Information? Low Level Hard Drive Information: This refers to the master hard drive serial number in hardware. Note that this is not the drive serial number which can be set from software...

Hello, I have a problem and hope you can help. In "Group Footer" section of my report, I defined just a Subreport. I want that this section (GF) is suppressed when the subreport is blank or Null. How can I do that? I appreciate your help in advance, --Bita

Hello guys, Does anybody know how can I invisible the Customize... item on the shortcut menu in Excel? As you know when you right-click a button on any toolbar or the menu bar in Excel you will see the shortcut menu. Thanks for your help in advance. --Bita

Hello, I appreciate your help in advance. I open a word document in my VB6 program in this way: Dim WD As Object Set WD = CreateObject("Word.Application.8") With WD .documents.open FileName:="C:\Bita.doc" .Visible = True .displayalerts = False End With I...

Hello, I have a problem and hope you can help me. There is a VB6 application (test1.exe) that is running on system. In another VB6 application (test2.exe) first I check if test1.exe is running or not and then if it is running I'll activate it by AppActivate. The problem is that if the...

Hello guys, Is there any way that I can find, how many users are connected to a access database named e.g. RMS.mdb? I want to do that from my VB6 program. Thanks for your help in advance. --Bita

Hello guys, I need your help. I want to invoke an excel file named "Main2.xls" from my VB6 program but first of all I need to check if this XLS file is running already or not. So if it is running I won't run it again. How can I do that? Thanks for your help, --Bita

Hello, I hope you can help. I want to change the RecordSelectionFormula property of a subreport in a report by code in my VB6 program. Do you have any idea? Thanks, --Bita

Hello guys, I have a Visual Basic 6 program that uses a local (on the same machine) database. I'd like to put my database over the Internet and be able to connect to that database over the 'Net (through a web server if possible). I know that, I may have to switch to some other database server...

Hello, Would you please help me and let me know, how can I change the font of bottuns in a Toolbar Object. Thanks in advance, --Bita

Hello friends, The following is my code. oShell.Run returns an error <Method 'Run' of object 'IWshShell3' failed', I think it is because there is a blank in &quot;My Directory&quot; , do you know how can I solve it? sub main() Dim oShell As Object Dim nRet As Long Set...