my application is an Access 2000 front-end connected to a SQL 2000 database
back-end
My problem is when two or more users are editing the same record at the same
time, the first person who exits the record gets their changes saved,

Have Office XP-Home. Service Pack 3 update requires a CD with Microsoft front
page. Don't have.

How can I read the record number box value on the navigation bar on a form?

I want to be able to update a Microsoft Access table with data relating to
word documents.  Each document has a custom property called SOP Number, i
want to be able to drag this property data out of each document and populate
an access table.  I also want to be able to pull out ...

hey there all.
Been using access for my project at school and I need the system to work out
the day of the week for me, given a date stored in a variable. Found
something with access though:

still another question on references...it seems they are my nightmare...
I'm developing a database on Access2003.
Once delivered to the users it will be mostly run on pc with Access2000. I'm
saving the file in Access2000 format, but... here starts my doubt:

First Excuse my poor english
Here is the code :
********************************************
Option Compare Database

Hi all, I have a mdb and a mde file.  I need to use vba on the MDB to code
the mde as a reference to the mdb.  Is this possible and example.  Thanks in
advance.

Group:
I want to write code that will delete a record from the table named
MasterData if the Name field is blank. I have been trying the following code
but it doesn't work. What am I missing?

Hello Access Programming Community.
NWO here sending this Q on behalf of a colleague...
When a database table is updated using the VBA connection object “execute
method” the related tables are updated immediately but objects such list,

I got my Access 2000 project completed and converted to a MDE on my
development machine.  A buddy wanted to see how it worked, so I sent him a
copy of the MDE and BBOOOOMMM - failed on load.  He's using Access 2002, so
we figured that the MDB had to be converted to a MDE under ...

is anyone finding a problem with importxml?
I wrote this code:
function f1()
Application.ExportXML acExportTable, "sites", , "schema-sites.xml"

Can anyone point me in the direction of a resource for converting standard
ASCII text into binary?
I am using Access2003. I already have VBA routines for converting decimal
numbers in binary, now I want to convert text (for very simple encryption

I'm creating some custom menu bars and, for the life of me, I cannot figure
out how to show the list of open objects as is done on the built-in Window
menu. Also, how does one recreate the Horizontal and Vertical Space menu
items that appear when designing forms and reports. I find ...

I have a table indexed (unique) on date.  My users enter a date on a form.  I
need to determine if that date exists in my table before proceding.  
Can someone help?  Thanks in advance.