I would like to have a button on a form that closes the database, and maybe
even Access if that's possible.  I know you can do it from the switchboard,
but would like to do it from a form.  Any help would be appreciated

I have an input text box where the user can enter text.  On the after update
I guess of that field, I want to go through what they entered and replace
certain characters with a space.  For instance replace all apostrophy's with
spaces, so      Steve's  becomes    Steve s

After years of using VBA, Im really getting sick of the basic "Item not
found in collection ", when coding recordset collections.    Is there any way
to build a better mouse trap to detect which "item' it is referring to.  
Sometimes, I have to use resume on next and in this case ...

Not sure how much info to give, I'll be as brief as I can to start with.
A2002, sp3.  Database is also 2002.
I use the MDE that I created, no errors.
Another user uses same mde, receives error when attempting to update a

I have 81 boxes each containning a single char.
each has a Private Sub A1_Enter()          A1 to I9
how do i loop through each private sub and also
i need to get the name into a variable ie updated     box_Updated = "A1"

I am trying to run a sql qry in a macro with the RUNSQL command.
I am trying to run a select command but it keeps failing. can anyone help?
SELECT serialnumber FROM devices WHERE ipaddress=ESN

Need help with DLookup in forms beforeupdate
I have a table called tblStoreOrders with a key field name [Store] ( a
numeric field)
My form name is frmStoreOrders with a combo box call "Store" (This has

Good morning:  
I have a problem due to my  lack  of knowledge, that consists of the
following: I have two forms (MP and OT) and I want to pass data of the form
MP for the form OT, starting from button in the form MP. What is that turns

I have a list box that I am allowing multiple selections on.  I need to capture
columns 0 and 4 from the list of what is selected.  Does any one know how to
do that.  On the code below it errors out after running through one selection,
I get invalid use of null?

Hi;
For some reasons i have to enable DB window for my users and so all tables
in mde file are accessible.I have just one table named [MonthlyHistoryTBL]
that deleting its rows is very important for me.The AllowDeletion property

The scenario:
A user is entering phone numbers on a form.
I don't know how many phone numbers the user will want to enter.
I want to be able to have one textbox for the phone number and a button next

We have appr 1000 numbered (1 - 1000) boxes. I made a table with box number
the first field (auto numbered).  I use this field in a relationship with a
contents table. (More than one contents to a single box).
I need to control the deletion access somehow. (for my users, I'm scared

We are setting up a database for change flow management.  This system will
have sections for each functional area (ie: Technology, Administrative
Support, Communications, etc.).  This system will have a report for this "ID"
(Interface Document).  What we are trying to achieve is ...

I'm trying to set up a function that will be used for several controls
on several forms - and will be called from an Access macro.
The function is in a general VBA module and I need to pass it a
reference to the form, the control (usually a listbox) and an integer.

I have a report based on a table & query that has some 10K records in it.
The report lays out just like I would want it to, with grouping and sorting
and layout, etc.
Herein lies my problem. There are a couple additional fields where the user