I have a form (form1) that is controlled by table1 (Orders), which launches
another form (form2) controlled by table2 (Items) - upon completion of a
record in form2 (and closing of form2), which adds a record to table2, I
would also like it to add a record to a table3 (shipments) ...

Which is better to store temporary values?  Dim or an Unbound Textbox.
Is one faster?  Is one more stable?  Can you have several Dims?  How
many Dims is too many?  Any downsides to one or the other?
Any info appreciated.

On my continous form I have a textbox (znaam) in the form-heading. On the
"change"-event, I look in my recordset for a match with the text I type ,
and then I try to go to that record on my form.
This works fine as long as I do not type a space. When I do that(as in "De

If I do a calculation between two fields and the answer ends up to be
negative how do I make the negative number equal 0.

I have been using an alpha-numeric PO system at work and have recently been
asked to create a database to automate a great deal of our system. We are a
small company(less than 100 employees, 1 inventory person, me!), and I am
trying to learn Access as fast as possible. Is there ...

Does anyone know how to print (or save to file) all of the VBA code in a
single Microsoft Access.  I know I can print all code from each individual
object, but with 105 forms and 75 reports plus all the modules, I figure
there has to be an easier way!

I have a routine which cycles through records from a table and, for each
record, temporarily opens a form which does some processing on that record.
Then, it closes that form and repeats the whole procedure for the next
record.

I have a cmdButton that goes out to a directory, looks for a .pdf file that
matches a field in my database.  If it finds it,  it opens the file, if not
it returns a msgbox saying no document found.  Is there a way to change the
color of the button so blue means there is a ...

Using code how can I bring an open form in front of other forms?
Thanks in advance.

I've got a db where I've split users and notes. I did this so I can
have large memo fields (more than 65000 characters). Now I would like
to read (from a query (that works fine)) the values of all memo fields
for that user and show them in a form text field. Is there also a

have a large report (+/-300 pp) where the field for each item in the
Group Header is shaded grey.
When the report is generated, I would like to be able to
programmatically change the data item field shading to other colors

Hello--
We built a FrontPage 2K3 Web site that includes a form.  We used the FP2K3
database feature to create an Access 2K3 single table database connected to
the form.  Additionally, we created two .ASP data results pages where we

I have a table that looks like so -
Contract # | Stage 1 | Stage 2 | Stage 3 | Stage 4| ...............
----------------|-------------|--------------|-------------|------------|
45234255  |  8/8/06  |  8/24/06 | 8/31/06 |  9/7/06  | ................

I want to remove the ( ) around the area codes and the dash between the
prefix & number

I have some VB code that works fine when my table has records but gives an
error when my table is empty.
The form has a tabbed control which has some subforms.
When I hit the 'create new record' button', the code sets the subform