Search results for query: *

Hi Everyone, I am developing an Access 2000 DB where the users need to update the data in a linked table (text file) by selecting the most current file on a network drive. The path of the most current file is not always the same, nor is the name. I have overcome this by copying the most...

Hi, I'm trying to develop a query that selects text from 4 tables (along with a date field associated with the text), and place the text within a one column of the resulting query and order by the associating date. The 4 tables are: COMMENTS(COMMENT, COMMENT_DATE) FC_STATUS(STATUS, DATE)...

Access Recordsets Hi, I am having trouble with an access recordset. It is querying a simple table of students, who belong to particular groups (SGROUPS). The query works fine when without the wildcard * chararcter and the LIKE clause. It returns nothing when they are in there when there is a...

I am trying to write a macro that copies the current Worksheet(s) in a Workbook, to another Workbook. So far I have to following: Workbooks(1).Worksheets("Monday").Copy Set NewSheet = Workbooks("Roster July 2002.xls").Worksheets.Add This seems to Copy the...

How would I go about ordering the data in a query based on the level of the technician? I.e. I have a field called STHST_CERTIFCODE which has the following type of technicians: ADVTECH APPRENTICE MASTERTECH SPECTECH TECHNICIAN I want to order them like so: MASTERTECH SPECTECH ADVTECH TECHNICIAN...

I wish to start an OCP path very soon (either Solution Developer or Application Developer track) and would like to hear some of your suggestions regarding which track is more beneficial and study material used, particularly for the Jdeveloper exam and the Forms exams. Also, the benefits...

I am trying to import data from an excel file to a access 2000 db. I try doing this by: File > Get External Data > Import... then I get the following error: An unexpected error occurred: I/O error 6 This error occurs before I can even select the excel file to import. I have tried doing this...

I get an error on this piece of code: Dim rs1 As ADODB.Recordset The error is: Microsoft VB compile error: "User-defined Type not defined" I 'inherited' this database from a co-worker that has left, but I think it might be some problem with the database options. Any help is much...

I am using ASP and a Access Database to view and store data on certain vehicles. How would I dynamically load the contents of two HTML select inputs from the database using JavaScript? The following example may make things a bit more clear: I want the first select input to determine the...