I have a sub form that contain an amount field.
I have a Total amount field on a form that the subform is bound to. I'm
trying to add to the Total field each entrance of the amount field but with
no luck. only the LostFocus seems to do the trick but i don't think that the

Hi everyone, I recently upped my MS Access from 2000 to 2003. Previously I
put a lot of effort in some coding, which now stopped working by a runtime
error (2447) Illegal use of . (dot) or !
Any help is appreciated..

I have a main and subform. On the main form, I create a complex (depending
on my input after pressing a button) sql query.
Now I want to populate my subform with the result of the query. Also, when I
push mu button again (and the query is redefined), the subform should be

I’m entering uncharted waters as far as my knowledge goes – especially with
arrays.
Here’s what I have:
Master Table (contains Master# and other info)

I know how to concatenate a SQL string and make it the RowSource of a combo
box in VBA on the fly, but how would I pass just the Where clause from VBA to
an existing query. (This is because the query is used in more places than
just this row source.)

Access 2003.  Wanting to generate a VBA "black box" routine to remove spaces
from within text strings of varying lengths. There is no issue with leading
or trailing blank spaces. Think of it as removing all the blanks between
words in a sentence. Seems there might be a tool or ...

I am trying to find the most efficient way to look up values twice-removed
from the data used to perform the lookup.
Simple example:
Company table

Hi all. I have a question about how to setup some access rights to database
users. Here is the scenario: I have a form that uses a combo box with data
from a table. Also, many records in another table. My question is how do I
set some sort of a restriction, so that one user can ...

After creating a very simplistic database, I recently realized that using an
autonumber as a refence for records is not a good thing.  My database was
created to manage a filing system, so it is very important for it to be able
to number each record in the order that it is ...

How do you clear a list box with VBA code?  That is, if the user has
blackened in items, how do I clear them off so nothing is chosen?
Thanks,
Matt

Hello, i'm trying to change the encoding of a text file from unicode to UTF8
in a the Access module. can't figure out if there's an object & method would
allow me to do it, or if scripting would help - have been searching for days
on the net but couldn't find the answer. Please ...

I make a lot of use of the DLookup function to retrieve data back from the
tables, but wondered at what point it is more efficient to use a recordset
when retrieving many values back from the same table.
e.g. if I needed only 1 item back from table A, I would have thought that

I know this is probably a dumb question with a simple answer, but how do I
get VBA to recognize a long string (over the 1024-character limit for a line
in VBA) as a single string (e.g. when concatenating a long SQL statement).

I made a form that allows the user generate a report based off the category
that they pick. When they choose a category, the category number pops up. The
button that runs the report works fine when there is only one category number
thats assigned to a category.  I keep getting an ...

I want to have an MS Access app execute when a user opens it. My
understanding is that Autoexec is the method to execute a Sub or Function,
but how?