Search results for query: *

Would like to backup an Access database. Right now I am using Filecopy sSourceFile, Filename which works until I open a record. Then I get a 'Permission denied' msg. My code so far: cn is the database connection If cn.State = adStateOpen Then cn.Close FileCopy sSourceFile, sFilename Thanks.

I have a form with a bunch of txt boxes, combo boxes and check boxes. I would like to capture when the form changes to alert the user when a movement is made to leave the form without saving the data entered. An example would be clicking a cmd button to clear the form. Thought about using the...

When populating a mshflexgrid, the first column is MT. How to have the first line to be the starting point? So far I have With flgTracks .AddItem rst!trackid & vbTab & rst!Title & vbTab & rst!Duration End With flgTracks.Col = 0 flgTracks.Sort = 1 rst.MoveNext...

Trying to populate a treeview. Works if a record is not deleted from the database. However, once a record or two are deleted the treeview will not populate because of the 'index out of bounds' msg. There are three levels (nodes?) for this treeview. The first is to show the artist, the second...

With a click in a treeview the records populate a datagrid. Each record has 3 fields; an ID, Title and length. When a record is clicked in the datagrid three text boxes are filled with the data for editing. There are 2 areas of concern: 1. When the datagrid is clicked the first time the first...

Am trying to populate a listview from 2 tables. In the form load the headers are added. Populating the listview works when using only one table. This code shoots past everything because it is .EOF. [vb] Public Sub DisplayArtists(ByRef pCol As Collection) frmSSTab.lvwArtists.ListItems.Clear...

On several forms some of the text boxes have a bacground of white whereas other are yellow. Is there some way to change the color to my choice not a random white/yellow thing? Thanx. Kim

Did a search on tree view and nothing. Where can I go to get some idea on 'how to'? thanx.

Have two hard drives both have xp os. One with development files and the other without. I now want to have only one bootable drive. Changed D from primary to logical. How to get startup not to recognize the now non-bootable d drive? Thanx. Kim

I use CR9 with VB6 for a deployed application. Also use PDW to get the files and dependencies then use a 3d party installer. Have done this successfully for about 2 years. Lately I made changes to the installer files because of the various OS requirement changes. Left the order of the VB6 and...

Whenever I open vb6 there are many .tmp files created either in the root directory of C or D drives. Is there a way to eliminate these annoyances? I checked the microsoft site and was not successful in finding anything. Thanx.

I am getting a 'Run-Time error 713 Application defined or object defined error' whenever I try to run any of my crystal reports through vb6. The rest of the program is running as intended. At first I thought it was because CR9Deploy.reg was not installed. But that error is 50003. Any help...

I have a program that I would like to use the ampersand. Like A, B & C. However whenever I use it all that shows up is an underline. Here is what I have: lblampersand.caption = "A, B " & chr(38)& "C." Any ideas would be appreciated. Kim

Is it possible to add a query to a Access mdb programatically in VB6? I have copied a db to a new db, placed all the fields in the new that are needed. Now I would like to add a query. Thanx. Kim

Am trying to copy the contents of a field from one table to another. Have added the new field to the copyto table with ALTER Table Members ADD Column Deceased LOGICAL but am stuck when trying to copy the contents from one table to the new one.

Recently I formatted and re-installed everything. Including Office XP. All works well except Word. Each time I try to open Word, the msg pops up that Word failed to start correctly last time. If yes, then I get a blank page. If no, msg says to send or not to send info to Microsoft, then closes...

I have two workbooks open, one I am copying from and the other copying to. Workbook from could have multiple worksheets. I would like to load the worksheets into a user form in workbook to. The first form I asked for the name of the workbook from which to copy. After the user fills in the name...

The ShellExecute starts IE where I would prefer to use Firefox. Is that possible? Here is my code: Private Sub Form_Click() ShellExecute Me.hwnd, vbNullString, "http://mywebpage", vbNullString, "C:\", SW_SHOWNORMAL End Sub This is entered into a module: Public Declare Function ShellExecute...

I use a list view to pick out a record which fill data on a separate form. Then if I want to scroll through the database from the present record, I have two arrows to move forward or backwards. The database is indexed on fldTitle. fldTitle is not unique to one record for two artists can be...

Have filled a listview with checkboxes with ID, Lastname and firstname. I now want to add the ID to a collection but am having trouble identifying that all are in the collection. Here is what I have: Dim i As Integer Dim cCol As Collection Dim lstItem With listview1...