Is there a way that, when using a single or continuous form which
allows additions and edits, I can detect when I am entering a new
record (eg moved on to *) rather than editing an existing one?
In general, while wanting edits to be allowed, I want to be able to

I designed a small app and I wanted to do a BrowseFolder (see
http://www.mvps.org/access/api/api0002.htm), basically do a file open
diaglog and select a directory/folder.  The problem is that you can't
specify the starting folder.

Hi - I'm trying to create a datafeed from a Microsoft Access database
but I am having a problem due to my lack of experience.
I have to populate a field with a delivery cost but this is not held
on the database.

I have table A and record in it where field f1 has value "KUKU #1".
SELECT * FROM A1 WHERE f1 like 'KUKU #*' DOESN'T return this record.
SELECT * FROM A1 WHERE f1 like 'KUKU *#*' DOES return this record.
What is the problem?

I am trying to create a report that displays balance impacting
inventory transactions.  I can easily pull the current on-hand balance
in one query and the transaction history in another query.  However, I
am struggling with putting these 2 queries together for a report that

On a button event, I call a VB subroutine.
The subroutine takes some time, it is importing from excel.
I have a progressbar that works while the subroutine is looping.
Before the loop I write the excel worksheet name to an unbounded text

Is it possible to change the appearance/color of certain items inside a
listbox? To indicate if some items are active.
Example
Listbox:

I did a test once using a looping variable, first dimmed as Integer,
then as Long. I found the Integer was quicker at looping. I knew this to
be true back in the 16 bit days where the CPU's (80286) word size was 16
bits same as an integer.

For my thesis I'm using access to analyze news-articles. I would like
to calculate readability score. But I don't know how.
I have a very simple word count already, and I also have an
approximation of whole sentences (number of periods "."). If this group

I have designed a database that has several forms.  The forms include a
Warranty Registration for and Warranty Claim form.  If I were on the warranty
registration form for a particular product, and the serial number of that
product were shown in a text box, I want to be able to ...

I have a report which prints data from a parent table and two child
tables (Contract and Kosten). Because it is a bit long, I suppress some
fields which are often empty, based on methods found in the archive for
this group: allowing can-shrink on the field itself and the following

I have a client who is requesting the following:
Description:
-database should be a runtime version of MS Access so that it would not be
necessary for the user to have any Microsoft products in order to operate

I have a query that looks like this:
PatientID      LastVisit      LastMed      LastVaccine
1001           1/1/2004       3/1/2004     10/1/2004
1002           10/1/2005      3/1/2004     10/1/2004

I have a front end database file linked to a back end database file.
Periodically (every few months?), a form name frmStallSvcContract which
is based on a query comes up without data. The fields are present but
there is not any data shown. The data shows up in the underlying query.

I want to create an excel document from data in access.
each data has to have its own specific cell place in excel.
Is there a option available to make this work?, or is VBA the answer?