Search results for query: *

My setup is VB6/Access2K. When loading a Form, I'm using this code: Private Sub Command15_Click(Index As Integer) Me.MousePointer = 11 Load DbDepForm DbDepForm.Show Unload Rent_Deposits_Menu Me.MousePointer = 0 End Sub The Form has a DataGrid1 and an Adodc1 connected to...

My setup is VB6/Access2K. I need a click event on my VB Form that will append all of the Records from one Access Table (tblTEMP) to another Access Table (tblPERM)in the same Access mdb. Can someone help me with this one? Thanks in advance!

Several members (DrJavaJoe and others) helped me to get this code to work and I would like to share it with anyone who might have a similar need. My setup is VB6/Access2K. I needed to search the records of a bank deposit Access mdb table I setup by deposit dates and print a DataReport of the...

My setup is VB6/Access2K. I have a Field named "DepositDate" in an Access Table "DepositsDatabase" and need to filter all Records from the Table that fall within two dates (including the end dates) that the user enters on the VB Form, "Starting Date" txtBox and "Ending Date" txtBox and then have...

I'm using VB6 and have created a DataReport. However, when I try to print the report, I get the message "Report width is greater than paper width" - can someone tell me what I need to do with the DataReport property setting to correct this. I've tried different setting with the properties...

My setup is VB6/Access2K. I have a DataGrid connected to the Access mdb via an Adodc on my VB6 Form along with a cmdButton. Can someone tell me the code so that when the cmdButton is clicked the DataGrid will display only the Records where the "DateCompleted" Field is blank. And then when the...

My setup is VB6 connected via an Adodc to an Access2K mdb Table. I've got a DataGrid on the VB Form with its DataSource being the Adodc. I've got a cmdButton on the Form for printing the selected Record of the DataGrid onto a DataReport. The cmdButton code is: Private Sub...

My setup is VB6 connected to an Access2K mdb via an Adodc. My Access database has two Tables with identical Fields. The Tables are named "TEMP" and "PERM". I need to move all of the Records from the "TEMP" Table to the "PERM" Table when a cmdButton on my VB Form is clicked. The result of the...

The VB6 DataReport feature is driving me NUTS! I see that the properties of the DataReport have "ReportWidth" and "Width" and I assume the the "Width" refers to the paper width. I've tried various values for both of these fields and still get the message "Report width is larger than paper...

I'm using VB6 and I need to print a horizontal line on a report printout. The printout is a report and I would like to print the line under the Report title. Can anyone tell me where to add the "Draw Line" code in the following: Private Sub cmdPrintRecord_Click() Screen.MousePointer =...

Can anyone tell me the code syntax to display the printer's "Print Dialog Box" before the print operation takes place so that the user can select the paper size, no. of copies, etc.? I've tried: CommonDialog1.ShowPrinter This is what is suggested in the MSDN Library, but it's not working...

I'm trying to get my VB6 Report to print out on 11X17" landscaped paper, but it's printing on 8-1/2X11" landscaped paper. Here's the code I'm using for the print operation when the cmdButton is clicked: Private Sub cmdPrintRecords_Click() Printer.FontName = "New Times Roman"...

My setup is VB6/Access2K. When I run the PDW on my VB app everything seems ok and the setup.exe and cab files are created, but when I run the setup.exe file I get the following error message" An error occurred while registering the file 'C:\WINNT\system32\msado20.tlb I check "Ignore" and the...

My setup is VB6/Access2K. I have a DataGrid1 connected via ADODC1 to the Access2K Table. On the VB Form, I have the DataGrid1 and ADODC1 along with a Command Button. When the Command Button is clicked, I would like each Record from the Access Table to print out on a VB DataReport I created...

My setup is VB6/Access2k. I have a Form with a DataGrid, which is connected to the Access mdb Table via an Adodc. Tek-Tips member. CCLINT gave me the following code (which works fine) to print the currently selected record of the DataGrid onto a VB DataReport. The code I have on the...

Anyone know how to make the Setup.exe that the VB6 PD Wizard creates an "Auto-Run" or "Auto-Play" file? Any suggestions, thread links, third-party apps, etc. would be greatly appreciated!

My setup is VB6/Access2K. I'm using DataGrids connected via Adodc's to the Access mdb file. When I run the PD Wizard, create the Setup.exe file and install the program everything works fine on the PC I created the VB app on, but when I run the Setup file on another PC, I always run into the...

My setup is VB6/Access2K. When I run the PDW on the app, a box appears asking if I want to check the following two files as being "Dependency Files": msado20.tlb MSSTDFMT.DLL Whether or not I check either one of them, I still get this Dialog Box when running the Setup File that the PDW...

Can someone tell me why everytime I create a VB6 Form, a FoxPro file is also automatically created in my prj folder and what is the FoxPro file for? Will I mess things up if I delete the FoxPro files? It seems that the FoxPro file is not created for all of my VB Form, but only created if I...

I must have an option incorrectly set in my VB6 project. As I make changes to items in my project I notice that suddenly I have numerous (sometimes hundreds if not thousands) of temp files, which I delete to keep the size of my folder down. Everything in my project seems to work without them...