Search results for query: *

I have three Access 2000 tables linked by one key field named JobNo. In Access I was able to create a form which displayed all the fields from each table and was able to scroll through the records for each JobNo. However I am having difficulty trying doing the same with a form created in VB6. I...

Can anyone help me code the following. I have picked up help on various bits of this in other forums but would like to see an example of coding from start through to finish so I am posting on this forum which may be more appropriate since it deals with databases... From a Control Button on a VB6...

Can anyone show me how to code the following... I wish to take the value of a cell in an Excel spreadsheet and have it placed in a field of an Access Table? In some instances the cell would hold the word/text "closed" to indicate the excel document was complete. So here I would want this...

I wish to populate a ListBox1 with the field values of a Field named "Specification" from an Access Table named "CustomerSpecs". The next part I have already set up and works to transfer selections from ListBox1 over to ListBox2. The last part is, for me more difficult, where I need to create a...

I have been looking through the posts for info on wildcards within a file name. I have a number of documents (Excel,Word and PDF files)which I need to open from a command button. They all have one thing in common in that they are named with firstly a Job Number followed by a hyphen and after...

I have code which enables me to move a folder and its sub-folders and all their files to a new folder using Copy and Kill. However I would like to have coding check that all the files in these folders are closed before moving them. Any help is much appreciated.

I have a VB6 form which when opened connects to an Access 2000 database named CustomerDetails and displays all the fields of the first record in TextBoxes. Using the Data Control Bar on the form I am able to move to next previous last and first records. However I need to code a ControlButton to...

Working in a small network I was wondering if it is possible to have perhaps a ListBox or TextBox populated with the names of files/documents as and when they arrive in a certain folder? For example if a Word document called "Report-001.doc" was placed in folder named "C:\Reports", would it be...

I am trying to write code in VB6 to replace the following VBA code... PartNo = DLookup("[PartNo]", "EnquiryDesk", "[JobNo]='" & Forms![QAReview]![JobNo] & "'") This line looks at the field value of the JobNo field in the live/open form/table named "QAReview", finds the same field value for same...

I have a form in VB6 which allows me to view and edit data in my Access 2000 table (Tablename = QAReview.mdb). The table has a key field called JobNo which I want to use to open, from my pulldown menu, Word, Excel and Adobe documents relevant to that Job Number which all carry the JobNo within...

I am setting up new forms in VB6 which using the VB Data Form Wizard allow me to connect to my tables in MS Access. I am now at a stage where some forms display the first record of the Access Table and I am able to page down/up through the records. However, although I can change the data there...

Can anyone please give coding to allow me to click on a ControlButton in MainMenu.frm and have it open my second form named EnquiryDesk.frm. This was easy in VBA but I get all sorts of errors in VB6. I now understand I cannot use doCmd.OpenForm from Access. One error I get frequently is "Object...

I am finding a lot of problems trying to get my VB Access programming to run in VB6. For example I am looking for code which will do the same job as Dlookup and Me.JobNo. In trying to use Recordset to access my Access 2000 database which has many tables forms and queries I have the following...

I have been making extensive use of DLookup in my programs running under Access. However I need to tranfer all my coding over to VB6 and when I run them, the first occurrence of DLookup causes the error... "Sub or Function not defined". Can anyone explain why this is the case? Also is there an...

The code below sets a top level path and then searches sub-folders for material certs booked against one particular job number in a table called Booking In Log and works very well. However it only returns the first material cert (M-Cert) found. Can anyone show me how to loop this code to have...

While viewing my database in form view I would like to code a button to enable me to open a new record and have all the fields of the active record copied into the fields of the new record, then all I would require to do would be to give the record a new number in the primary key field. Then I...

I have recently been shown how to code a button to find and display any document. I now need to search a number of folders. For example... The documents filenames will always start with a JobNo like 226488 and would be found in the folder named 226000-226500. However to cover any JobNo, I need...

The following code finds and opens a document Ok. However I need to add code to make it loop and search/open others when there is more than one document in the folder. At the moment the code just opens the first it finds. Each file in the folder has a common job number as the first part of its...

Can anyone help me with the syntax for copying a file found in one of many folders at the end of a path. FileCopy "\\Level-01\Level-02\Level-03\C10000-C10999\" + filename, "C:\Jobs Folder\+ filename FileCopy "\\Level-01\Level-02\Level-03\C11000-C11999\" + filename, "C:\Jobs Folder\+ filename...

Can anyone correct the code below to enable me to copy a known file which has variable characters added to the file name after the first 5 characters? e.g. Filename = C1234 but actual filename = "C1234 UT" or actual filename = "C1234 MP LP" I assume use of wildcard * or % is used but how is it...