In a form, how to have inserted a logo that has a transparant
backgroundond? I inserted such a logo but the background is white.
Bart
(v 2003)

DCount in a query
How can i sum up all the fields in the query? My query consists of the
table products.The first field is Productid, the second is ProductName.
The next fields are the quantities available in the different

I want to do exactly the same sort of control size/visibility/position
manipulation for a main "on screen display" form and multiple reports.
I've no problem with this and have done it many times for individual
forms and reports or multiple forsm or reports as long as they are in ...

How to set the color of the selection bar and the selected text in a
list box?
Bart
(v 2003)

I've a database that is about 11mb, 117,000 records, about 15 fields.
When I run simple queries on the table, the database crashes
I've never seen anything like this before, any  ideas?
This can't be good....

           <HHC5013: Error: URL reference in the TOC cannot be
resolved:"Link.htm"
          < The following files were not compiled:
I get this error every time I open an existing HTML Help Workshop project,

I want to populate an array with values from an ado recordset
(multiple rows)
I use the absolute position of the cursor in the recordset to define
the row of my array to be populated.  I have a workaround for lack of

I have a form where I have turned off the default navigation buttons. I
then created my own. This works fine. The only questions that I have is on
the default navigation buttons it shows total records. How can I show this?
I have a text box that shows the current record using:

I'm having a few problems with a shared access 97 db.  I have the
database split with the tables on the server and everything else in
"client" front ends with links to the tables, e.g.
\\10.31.42.10\db\mydb.mdb but the whoever opens their front end first

I have downloaded the code described in Microsoft article Q154078.  I
am trying to send raw ZPL (zebra barcode printer) code from Microsoft
access.  It works just fine if I hard code the actual data in the
string being sent to the printer.  However, if I prompt the user for

i'm deciding whether to create a database program in VB6 or MS access, with
VB for applications running in the background. i just wanted some opinions,
as to which one would be better, and wat would be some
advnatges/disadvantges of doing it in vb6 over ms access??

Does anyone know of a way I can write a script that imports a table
from a particular .mde file? I don't seen any obvious way to do it as a
macro. Any suggestions if it can be done as a macro or as a written
module?

I'm stumped on this one.
I have a report that shows production calculations for a user-selected
period divided up into weeks.  Currently, I just use
format([MyField],"ww") to get the calendar week for the purposes of

I have an ID text field that is composed of two alphabetical letters
and the rest are numbers. This field is also a primary key. In this
same table, I want to separate this field into two fields. Then make
these two new fields primary keys. The first just contains the two

My situation is as follows:
A terminated employee is preventing my client from getting their data.
An MS Access 2000 database, split into FE & BE.
The FE is a compiled (MDE) file with no source code available.