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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.