I need to determine CMYK values from bitmaps. Is there a way in VB or Access
to do this?
The reason is that I need to determin the relative CMYK values.
Example: A square with the bottom half filled with black would have a black

I have an application that links tables to an ODBC source. The DSN
parameters are obtained from a custom .ini file. An incorrect DSN string
gives the user a 'friendly' connection error message that I would like to
supress in order to provide my own error message. This happens when ...

I have three Access Databases, say A, B and Main, in which data flows
between Main and A, Main and B.  Within A and B, there are macros that
trigger computation within the databases.  I need to call these macros
in A and B from Main database.

We a have a small office network of 3 users.
Each user has their own copy of an MS Access Front-End which is linked
via their own local ODBC connection to our server's MySQL database
(Linux Machine)

I am fairly new to doing more complex items in MS-Access.  My problem -
I have a one table that needs the Person Id  updated and two tables that
need the records that have the old Person Id  delete.  My code is below.
What I would really like to do is submit the code for all of the ...

I need to do a mail merge letter from my database. The letter will be addressed
to small companies and in the body of the letter I need to list employees of the
company. There will be from 1 to 15 employees. My database is all set up to
provide the names and addresses of the ...

I need to perform two queries in sequence on two identical access tables.
The source table is coming from a dataset returned by a web method and the
destination table is from a local access table. The queries are;
UPDATE [destTbl] INNER JOIN srcTbl ON [destTbl].entry_id = srcTbl ...

is there a possiblity to count the lines in a sub report?
Background: I have a form, where to put data, in this form there is a
fixed place, where I put the sub report. I know, that I can set the
properties to get the sub report always in the same size. But I do not

TABLES
CustomerTable CustomerTarrifTable TarrifTable   WarrantTable    
CustomerID(P) CustomerTarrifID(P) TarrifNo(P)    WarrantID(P)
BoatType      QuantityPurchased     ProductName    WarrantDate   

I want to populate a table based on a checkmark being inserted on a form.
Example, if the check mark is present, i want the customer number (which
exists on the form) to be inserted in another table.
Not too competent in vba but am making progress.  Not sure how to get the

Iam coding data access application with database object and recordset.
Here' s my code
'------------------------------------------------------------------
Private Function CreateRecordSet() As Boolean

I have a database that I would like to query for a specific date
range.
I want to create a report based on this query that will pull any
records from the last 7 days.

I have a table with quite a few fields wich saves al kind of activities on
has done on one day.
Most important to identify a unique record is the date and personID.
A person is only allowed to enter his activity data once per date.

I need help getting a report to do what I want.
I have an archive table that contains the date, day of week, different
types of work and the arrival time for each type of work. I also have
2 columns in another table for the time each type of work was due (as

I've got the code to search through a directory for word documents,
open the doc, search for specific text... but I'm trying to extract
data that immediately follows the selected highlighted text.  I can't
figure out the correct syntax to give me the text that follows the