I have a functioning Access 2003 database with an ImageControl which loads
and displays jpg images stored in a directory. Data and associated jpg files
change every month.
Currently, to display the image I have to manually rename each picture in

Could any one can explain me the following, which I am unable to understand :
If rs.BOF = False Then
rs.MoveFirst
**What does .BOF stands for

I read the thread by TJ from 3/18/2005 but I didn't find the solution.
I'm experiencing the same problem with linked table in DAO.
When rollback is executed the changes in linked tables does not rollback.
Please help ,my data is getting messy.

Hallo there
I'm trying to determine what my screen TwipsPerPixelX (horixontal) and
TwipsPerPixelY (vertical) are using MS Access 2003 VBA.
I understand that the code in VB is as follows:

In an Access Database Project, Im having trouble getting a View to query data
based off of a value from a form. My ultimate goal is to run a report off of
this View. For example if Form1 FieldLocation = 256, I want the View to find
all items in Location 256. Below is the View I ...

I cannot figure out why I keep getting an Error 13 Type Mismatch on "Set rst
= db.OpenRecordset("Purchases")". This code structure has always worked
before in programming datablases. I get this same error on other recordsets
that I have tried to create in this database. Is there ...

After a repartition and format, I installed XP SP2 clean.  Then I installed
Office 2000 plus the service pack and all updates.
Then I opened an application I wrote some time ago and get this error message
that I didn't use to get.  A simple Set db = CodeDb() statement triggers it, ...

I'm looking for a few good beta testers for this product before it's
released to the public.  Your copy will be free.  Pricing to the public is to
be determined.  Please send email to ZZDoesItAThotpop.com.
Do you support a number of different Access applications? Do your

I got a memo text box and text boxes
text boxes= [Address],[City],[Country]
In code,
[Memo] = [Address] & [City] & [Country]

Please help!
I am trying to accomplish 2 distinct counts for two fields in 1 query.  Is
this possible? I would appreciate the SQL view accomplishing this.
I currently run 2 queries,

At the end of this message I have listed a Sub routine that Access 2003
automatically generated in the AfterUpdate event of a combo box. This Sub
syncs the combo box to the Form when the combo box changes.
I want understand how this code works so I can make changes if needed. I

it seems that instead of creating a schema.ini file a programmer created an
export specification table.  I don't know a lot about anything to do with
access and I am having problems with my exporting function.  My question what
numbers are assigned to data types? Example is 12 - ...

Is there a way to find out the user's name and then place their M
Document folder location in a var for use later on
I had used a routine a long time ago but I think it was only fo
Novell.

I've been looking through the MS KBase and trawling through pages of Google
but can't find any helpful information on how to read from an XML document on
the web. I'm using Access 2002 on Windows XP.
Has anyone got an example, or can point me to one, of how this is done? Even

I have a table like this
tbl_WorkDetails
 WorkDate
 WorkProject