Hi, I'm not sure if I'm in the right place, but I need a program (or to
write one) that will allow me to assign a specific color to a given
numerical value.  I have a numerical data set that I want to represent
by colored boxes--kind of like how meterologists show you the

I got problems when I want to make a MDE file. The app. got a lack of
memory.
Bart
Access 2003

Greets,
context: vb6/ado/.mdb/jet 4.0 (no access)/sql
beginning learner, first database, planning stages
(I think the underlying question here is whether to normalize or not to

I have created a form with a combo box that allow user to select a
certain employee name and when user select the name the report based on
query is generated.
I want to include an extra option in the combo box so that if user

I have created a new form that reads in data from some intermediate tables.
These intermediate tables are used to compile data for use in a report or
the new form I have made.
Having opened the new form with this intermediate data (it provides an

I do have a toggle and want have it another face when the button is
pressed. How to perform this is VB?
Can the same be performed with toggles?
Bart

Does anyone know whether there is a way to create folders inside the
right payne when you click on Tables or Queries or Forms or Reports
in the the Objects side.
I have alot of queries and forms that would be nice to put into folders

(sorry for the likely repost, but it is still not showing on my news server
and after that much typing, I don't want to lose it)
I am considering general error handling routines and have written a sample
function to look up an ID in a table.  The function returns True if it can

I have a database I am building that is for a police department. On the
report I need it to display the following information:
Date of Incident, Offense discription, Narrative, Offender/s, victim/s,
etc.

I've noticed the half dozen or so object libraries in the References list
for PaperPort and thought I would try to automate the PaperPort 9
application.  The goal is to click a button and initiate a scan of a
document into a pdf file, programmatically name the file, and move it to a

i have i problem such as getting the intercept point for my graph which
is made in MSgraph Access 2003. the lines in the graph is from tabel
and , i need some idea for some vba code to get the intercept point for
the lines.

Need some help to stop me going around in circles on this one....
Have a nested subform (subform2) which simulates a continuous form for the
record on the parent subform.
Subform2 has rows of either an option button plus two text fields or a

I don't know if it's possible but I need to create in a table as many
records as a number entered in a form. (Example: In a form I write 4
and it creates 4 new records in a table).
In each of those records I need to paste a code of 3 leters and the

         I was using a C# .Net dll from VBA  for a week . I make it
possible by setting the  option of  '  Register for COM  Interop '
under project setting to  '  TRUE '   and by using type library of my
dll as reference . But when I tried to use the same on another machine

I have a list box whose value I explicitly set to null in code.
Then when I include the list box in a query criteria it fails to match
but if I replace the criteria with 'null' then it matches fine.
So the code (cleaned up from that written by the query builder) looks