I need to use transactions to make sure data is consistent.  I have a
combo box that when changed to a new value updates a table.  I then
have a DoCmd.RunSQL statement following that in the same Sub.  I would
like for it for those two things to be wrapped up in one transaction,

My computer just hiccuped, so if this went through already, my
apologies.
I am attempting to have a User access a report in a separate
application based on the value from a combo box, but it fails.  Any

I have a table of appointments, how could I create a query to show the
appointments for the week ahead.
Thanks
Keith

I was wondering if you could help me.  Basically, I'm wanting to do a
sort of auto complete in an access text box, with the help of visual
basic, where the user will put in, for example, m, and that will change
to Mathematics; I know how to do this part, but I want to be able to do

I am trying to write a query that will allow a partial word search.
I know that if I have something along the lines of
SELECT TblName.Name, TblName.Category, TblName.Type,
TblName.Ingredients, TblName.Instructions

I was discussing a project today and a question came up about using a
transaction table.  I need to recreate an input form with many
different types of questions.  The following is one type of question:
3) How would you characterize the racial/ethnic composition of the

I need to update multiple tables from one form using a command button. The
info from the different text boxes should then go into the tables.
Can someone help me with some example code on how to do this.

How do I get a table to autpmatically enter the County name in the next
field when I enter the City name?
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups

Very simply, I need to be able to enumerate the objects in one ADP from
another *without* running any startup code or macros in the ADP whose
objects are being enumerated.  I know I can use automation to start
another instance of Access and open the second ADP and get at its

I do not know if this question is regarding table design, queries, or
programming.  Below, I have given a table design using Access 2003.
Fields 'Product' and 'Color' are primary keys and 'Active'
is a Boolean data type.  What I am trying to accomplish is having only

Is there a way to add fields to a table from a query?
I have a database with back end tables and if I make changes to the front
end that include adding extra fields to a table, I have to trust the user to
update the tables. Quite often this may just be the addition of a Yes/No

I have a formA and subformB
subformB is a continous form
with a txtTotal in form footer
=Sum([Total])

In my previous post, I wanted to ask if someone knows some examples of
the most current database server interfaces. I am getting confused if
ODBC, OLE, JDBC are considered as interfaces to the database servers. I
just wanted to have an idea on this topic. Thank you in advance for ...

      Select Case Me.OpenArgs
           Case "frmVehicleEntryForm"
               Forms![frmVehicleEntryForm]![OwnerChooserBox].Requery
           Case "frmEditTowedVehicleList"

I have a table (user)
ip, ssn, date,name
Each time the user does something, I record that information in the table.
I'd like get a list of the last 4 entries for distinct ssn.