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...

One way around this problem is to append each record into a temporary table, and have each text attribute in one column as required, along with the date associated. I was hoping that it could be done with a select statement though, as there would be a lot of text being appended and deleted to a...

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...

Thanks GeekGirlau, That's exactly what I was after! [2thumbsup]

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...

Thanks a lot Kyle that worked great! [2thumbsup] I didn’t want to add another column to the table because of data redundancy and the data is uploaded daily from an extract.

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...

Macsman, I don't think the error is because of the excel file formatting. The problem I am experiencing is that I cant select the excel file I want to import. i.e., after I click Import from the File menu (File > Get External Data > Import...) I receive the error: An unexpected error...

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...

gearhead, I am trying to do somthing on the same lines. I have 2 HTML select inputs, where the contents of the 2nd select depends on the choice of the 1st select input. Currently the contents of the 2nd select is in a Access database, i was wondering if it were possible to dynamically load the...

chassid, I would try what paul suggested, that seems about right. You could also try the following: Do you have control of the page that the variable is passed from? I think that the forms method has been set to GET, i.e: METHOD="GET", or it may not have a been set at all. Setting it...

ChouCh, I checked out that site. Thats what i am after without the refreshing. Im not sure what you mean about the hidden frames though. Sort of similar to: http://www.mycareer.com.au My ASP code so far is: The user enters the Vehicle ID, VIN, from a prior form vin =...

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...