I have a simple system that connects to a remote SQL Server DB via ODBC
under Win XP Pro. When I try to update data in a table (even from simply
viewing the table) I get a Write Conflict Error, and canno save the changes.
There is no one else attached to the db..

A colleague was programming our Access database before I was asked to make a
few changes on it because we changed PCs.  On loading, it tries to locate
the .mdb & graphic files on a particular drive - \\mdb-filesrv\goodguys.
"mdb-filesrv" was the network name of the former PC which ...

Is there a way to prompt a user by using the find command?  I am trying to do
something similar to what User "Wolfman" posted on 11/25/2004, subject:
"Find".  However, the Combobox is not ideal to me, because I do not want to
allow the user to view the possible choices.  I just ...

I have a form which has Default View = "Datasheet", so it can display a table
(all rows) with only a few columns enabled.  It looks fine when I open by
double clicking on it.  But when I open it from the switchboard (OpenForm),
or using DoCmd.OpenForm in VB, it shows one row only ...

I am trying to use a combo box to select a specific record within a read
only form.
I use the wizard to create the combo and select the option to use it as a
search combo.

Is there a way to add data to an existing Excel SS? I have
a table of appointments that gets updated daily. Each new
appointment needs to be added to the SS in Red text and
the old appointments should be in black. They also would

I have two cbo boxes that I would like to have disabled on form load, but
when the user clicks a chk box, the after_update will enable the two
cboboxes. What would my code look like?
Thank you

My Platform is Access 2000
I have a Parent Form that has 3 SubForms (Form1, Form2, Form3) set at
Visible = NO. (Not visible on Parent Form)
I then have a ComboBox with 3 lookup fields (Field1, Field2, Field3) in the

I have a macro with conditions that vary the action depending on the number
of records in a subform.
Using a =Count([FieldName]) formula in the Subform field I have got this to
work but running the macro "on current" in the form, runs it before

I am creating a database to print different documents.  When going to print
I would like it to do 3 things:
1. Record what the current default printer is.
2. Change the default printer to a specific printer.

In access, i Have a control named Extra services, values 1,2,3
I need so that when Extra servceis = 1 or 3 to make my time = bold
I have to do this to several fields, but once i get one I should be able to
figure it out.. thanks guys.

Scenario:
SQL Server BackEnd
Access FrontEnd loaded on each client PC
I have some reports that rely on records being inserted into local tables

I have the following code  in the after update event  of  form
[F_FicheContrat] :
If Me!DateFin < Date = False Then
       CurrentDb.Execute "UPDATE T_Interimaires SET " _

I need to make my database work until certain date.
After that I need it to close, and doesn't work.
How can I do that?
Thanks

I am having trouble finding an answer on how to do this and I am a newby to
Access, and not well educated on database design.
My question is this: how do I make a small form that is a search box?
Specifically, I want to click on my switchboard "Find a Notice" and it pops