Is there an addin that I can use to rearrange the sort order of a small array
of fields such as the screen for setting the Sorting and Grouping in design
view of a report or the tab order in form design view?  
If there is no addin does anybody have sample code I can use.

I use access 97.  Sometimes when I use a breakpoint on a line of code then
press F9 to uncheck it.  It will still stop there without a breakpoint when I
run the code.  This wouldn't be so bad, but even after I close it and send it
to users it will stop on them at this previous ...

I'm trying to have the cursor be positioned at the beginning of a combo box
when the user clicks on it with the mouse, regardless of where the mouse
pointer is in the box when clicked.  So far I've tried Me.Combo.SelStart=0 in
the OnEnter, GotFocus, and OnClick events, but ...

I have 2 Forms with the same field fields but each actually reference their
own table and data (there is a reason for this format).
I generated code under the General Module as well created a Class to house
code that is needed for both form.

I need some help from the group.  I have a table with a field that contains
the warranty expiration date for each item.  I would like to display in a
list box All those items whose warranty will expire over the next 30 days.
I need help in developing the function I would put in the ...

When I add a new record, most of my calculated fields are showing up as
#errors; however, if I add the minimal information to the record and close
the form.  Once I reopend the form and go to the record all the calculations
are correct.

i have a 3 simple tables, one which stores transaction information, the other
2 are simply for the type of transaction and the categories that each
transaction is. the main table called "trasactions" is the basis for a form
called "transactions".

Hello.  This is mainly a general question regarding doing an adp project
rather then the mdb.  The boss would like to use the sql2005/express for the
tables and A2k for the front end.  I rarely have done a project so I am
wondering if anyone has any suggestions for a good ...

I have certain data that is dynamic and I have stored it in an excel
file that I have linked to a table in  access. This works fine for me.
However the only glitch is that when I have to transfer my application
from one PC to another or one location to another I need to refresh the

I have a data base where tools can be used to more than one job.
Data are organized in two tables:
tblTools with fields ToolID (auto), ToolName, Supplier, Shared (Y,N) and
tblJobs with JobID (auto), fkToolID (related), JobInfo, StartDate, EndDate

I have the following:
Table:  tblCompanyInformation
Field within the table:  CompanyName (allowed 100 characters)
Field Type:  Combo Box

I have a form which I included and option for users to "Exit Access". I
have put a code behind this to prompt the user that they actually want
to close Access but the code is not working properly. When I choose the
option "no" it closes Access. This is not what I want. I only want

Hi,
I have lengthy vba function which works perfectly fine when run from the
code viewer. I have a macro which launches this function (using  Runcode),
which again works perfectly when run by itself.

I hope someone here can help me.  Basically I'm trying to use bitblt on
a picture that's being shown (using the excellent Picturebox class from
Stephen Lebans site) on my Access form.
What I'm trying to achieve is this: I've successfuly loaded the

I have a form which is set to display no records on load until a name is
selected from a combo box.  
I have now built in a wildcard parameter query to help the user find the
correct name for a record based on any fragment of any name.  This process