Hi,
I am running Microsoft Access 2000 (9.0.3821 SR-1).
It is some time since I have done some programming in Access and that was in Access 97.
When I wanted to connect to a database I used the following code:
...
Dim MyDB As Database
Dim MyData As Recordset
...
Set MyDB =...
Hi,
I wrote a little application that reads file names from a database table where it is linked to a 'Manual Doc Code' in a specific sequence.
I want to use Word as the report writer to print these fiels in the sequence that they are linked.
With .doc files this works perfectly using...
This might look complex but try the following:
where Mid([Naam],(InStr(1,[Naam],"$")),1) <> "$"
replacing the field "Naam" with your fields
Good luck
Phlip
Hi,
I wrote a little application that reads file names from a database table where it is linked to a 'Manual Doc Code' in a specific sequence.
I want to use Word as the report writer to print these fiels in the sequence that they are linked.
With .doc files this works perfectly using...
Hi,
I did run this SQL
SELECT TTLJOB, TTLDATE
FROM ITS_TTLTIM_SA
WHERE TTLGEBPROG = "P" and TTLJOB = 10003;
and I've got only one record for that job number in the table.
PPP
Hi,
I am working with table (linked to ORACLE via ODBC) that has a 'jobnumber' field with many date records (each date for the job can have many time records)
As you can guess this is a time recording system. I want to find the record with the maximum date for a specific job in this table. I...
I am working with table (linked to ORACLE via ODBC) that has a 'jobnumber' field with many date records (each date for the job can have myn time records)
As you can guess this is a time recording system. I want to find the record with the maximum date for a specific job in this table. I am...
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.