I want to check if my form supports transactions. Where do i find this
transaction property?

Hi Group
Is it possible to create Master-Child links between report(Part Types) and subreports(Orders, Inventory)(two in number). Only a single field(Part No) is common between them, but I need to generate report based on two criteria i.e on Part No and Date Range(Start and End ...

I'm running simple code behind a form button. I issue four separate
Docmd.transferspreadsheet commands that export a queries to excel
spreadsheets.  The transfers occur, but then Access freezes up and I have to
quit and come back in.  Does anyone have any idea why Access would ...

My table resides in a SQL database:  It has two fields:
1.  NameID   - KEY     2. Name
I want the user to have the ability to add new names in an Access form and
disallow any names that already exist. SQL does not give me the ability to

Problem:
I have several events that copy data to and from the server - updating
native tables. This may take anywhere from 5 seconds to maybe 1 minute. Is
there a easy way to let the user no what is going on. Something like a

I have vb function that in some lavel it opens a form
I would like afterword to continue the vb code after i call the function
without causing the form to look like dialog
Is there a way to do this?

Re: MS Access 97. Sometimes in a form the record will change after using the
scroll wheel on a mouse. Can the scrolling wheel be deactivated? What can be
done to prevent the form from jumping from one record to the next when using
the scroll wheel?

Any ideas on this one? I want to find the max size of a field in a table, so
say:
SELECT Max(tablename.field) AS MaxNo FROM tablename
and then I want to get the value of MaxNo.

I have a list box with an OnClick Event where I do not want to use the
OnDblClick.  The problem is that if I hit the down or up arrow it will
process the OnClick Event also.  Is there a way to keep the OnClick event
from processing when the down or up arrow is hit.

Using Access 2002 for a music database, there is 1 field for track length.
Its format is Short Time.
I would like to total track length time for the recording, which I thought I
could achieve using the DSum() function but that does not work

I'm working with a continuous form and I'd like the down arrow to
automatically move the user to the next record.  Is there a way other than
using the KeyDown, etc. events to do this?
TIA,

Been stuck on this one for a long time now.
(Please do not confuse "Edit Mode" in the question below with AllowEdit)
Once a text control gets focus, is there any way from code to tell what mode
it is in (Navigation or Edit)?

How do I launch an executable from Access code?

Hello group. I have searched high and low for this answer, including
searching these groups.  I have a form that I update with a cmd button that
starts a append table query.  I am refreshing my forms to show the update
too.  I have just two fields; date and total.  When I run my cmd ...

Hi. I'm trying to streamline my not-so-pretty code, and
actully make it work.  I'm checking to make sure that
certain fields are completed before updating the record.  
Here, I've shown 2 conditions I'm checking for (although