Search results for query: *

How could I print a VB6 form with full size on the printing paper, says, letter size? Hopefully I do not need to buy a 3rd party software. I am thinking about to enlarge each control and the form and then print it out and then resize them back to their original size. However, I do not want the...

Hi, I am using VB6 in Visual Studio 6 Enterprise Edition. Does it bundle with Crystal Reports? I cannot find anywhere to install Crystal Reports. If it is not bundled, where can I download it like an add-in? Jeff

Hi, In Word macro programming, is it possible to set the mouse pointer to glasshour while the code is processing? How to do that? Jeff

Hi, I am writing some Ms Word macros. I need to export data to an Excel worksheet. I need a button to open a dialog box and let users to select the Excel file. How can I create a dialog box in Word macro? Jeff

Hi, I use Word macro to check if an Excel file is alreay opened. If Not FileOpened(ActiveDocument.Path & "\myFile.xls") Then Set objExcel = Nothing Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.workbooks.Open(ActiveDocument.Path & "\myFile.xls", 0...

Hi, I am writing macros to copy data from Ms Word tables to Ms Excel. Here is my questions: Before paste data onto Excel, I try to search for the last row on a worksheet. Dim lastrow As Integer lastrow = objExcelWorksheet.Cells.Find(What:="*", _ SearchDirection:=xlPrevious, _...

Hi, Is it possible? I have 2 sets of data for X and Y. I want a VB6 program to general a trendline with 4th order polynomial equation automatically and then take all the coefficients for other purposes. However, the machine do not have Excel installed. Can I still do that? Jeff

Hi, I have a form with a button to cycle the machine. The form also contains some custom menu buttons created from Menu Editor. Each time the cycle machine routine do a lot of stuffs such as timer count down, control a motor, read data, etc. Meanwhile, even though I set the menu buttons to be...

I am using Office XP. I created an Excel worksheet and had some calculations cells. Then I linked it to a Word document as the following procedures: 1. On Excel, Page Setup -> Sheet tab -> checked Gridlines box 2. Selected the desired columns and rows and Copy 3. Switched to my Word document...

Hi all, Same problem as so many people but still cannot fix it. Database: MS Access 2000 Program: Visual Basic 6 Tables: One of them contains a Memo field. Sympton: A customer was using the VB 6 application with the database. One time the VB program cannot be started because the database...

On a VB6 Data Report Designer, I tried rptDataReport1.Orientation = rptLandscape but got an error about no such property. Unless I set my printer default preference to Landscape, I got an error of report width is too large. I checked with the application references, I found this checked...

By VB6 code program, how to grant or set permission to an Access database file? I need it to be least secured, that is, full control for all users, so that normal operator can use it. I will set other security issues in the VB program to protect the database. Jeff

I have a VB6 application running on customer's machine (XP or 2000) in which they are free to create any users to run the VB application. In run-time, the VB program needs to read and write registries in: "HKEY_CURRENT_USER\Software\VB and VBA Program Settings\" However, this registry folder...

Hello, On my VB6 program, I cannot find the MS Date/Time Picker Control. I selected References -> Browse -> System32 folder -> MSCOMCT2.OCX -> Open. Then there was a Microsoft Windows Common Controls-2 6.0 checked. So I clicked OK. Then I selected Components, a Microsoft Windows Common...

IE6 on XP: I want to leave the AutoComplete Web Address option on but I want to clean up all history but I cannot do it. I tried Option - Tools - Delete Cookies, Delete Files with all offline contents, Clear History; Also tried AutoComplete - Clear Forms, Clear Passwords; Also tried software...

In VB6, I am exporting data to a text file like this: Open cdlSaveAs.FileName For Output As #1 Print #1, myData1 Close #1 ShellExecute vbNull, "open", cdlSaveAs.FileName, vbNull, vbNull, 1 How can I make the file page setup to be landscape?

Can I set borders for a cell or a row by VB code? How?

I am writing macros for MS Word and using VB code to push printing a document. However, the page margin will be out of the printing area so every time there is a pop-up question asking if the user wants to continue printing. Can I write some codes to skip or ignore this pop-up and just keep...

From Windows Run registry, there is a list of tasks specified for running at every time Windows starts up. I have an installer which adds a key to it so after installation and restart a VB6 program will open automatically. Then after the first time openning, the registry key must be removed so...

In a VB6 program, I put this in a module to open a database on the startup form: dbname = GetSetting("myCompany", "DataBaseName", "FileName", ".") Set db = DBEngine.Workspaces(0).OpenDatabase(dbname, , True) Say, the database named is myDB.mdb. When the program is running, some timer controls...