I am trying to make some code work and I get the following Visual Basic error:
Run-Time Error 3734
Database has been placed in a state by user "Admin" On Machine "Computer"
that prevents it from being opened or locked.

Ive want to make sure all the fields on a form are filled in so iv created a
function to go through the fields passed as parameters and check to see if
they are "" or not (im using the Nz function to evaluate all nulls to "" so i
can pass them as parameters).

I have a form with a subform on it. On the subform I have totals on the form
footer. I have a subprocedure on the main form and the subform that checks
the totals on the sub form against field values on the main form changing
the subform totals textbox background colour to green if ...

Is it possible to put a search bar on form that will find multiple records.
For example; find all the people who live in a city named Fremont. When I use
the binocular search in Access it only lists one record at a time. I would
like to see all the records that match a certain ...

I would like to use error raising as a means to pass back a clue to the
caller that they handed me invalid data, or that I had some other kind of
problem in handling their request.
I must have the wrong book, because all it talks about is how to handle

I am wondering if someone has a good idea for an approach of "transferring
data" from form to form.
Here's what I have:
- Main form with 10 texboxes (with visible property).

My native language isn't English, so I'd like to appologise in advance for
any spelling mistakes I've made.
I created a form wich modifies the appearance of certain controls depending
on the value of one field.

How to; in an append query, convert a Date Data type with format ddmmyy
(090505) to a Number Data type field  in another table without typical date
syntax eg 09/05/2005. Just a number 090505.
Its for an Inventory number which i wish to append (join) to an Autonumber

i've design a payroll program and one of my tables - employees, need a
pictures for each employees. what should i do to save pictures to the
tables during runtime? what controls should i use? and what's the code?
thanks a lot for your help...

The relationship in my database is:
Employees Profile Table: One  --- to Many:   Applications Table
My customer wants the report to show the Employee Profile with applications
if applications exisit OR the Profile alone.

I have a form (frm_RECEIPTS) which records a cash receipts transaction. The
subform (sbfrm_RECDETAILS) lists invoices paid. Both forms linked by TRANS_NO.
I have a combo box (cbo_DEBTOR) on frm_RECEIPTS, which controls a combo box
(cbo_REF) on the subform using the following code ...

Hi.  I'm using Access 2000 and I'm having trouble trying to create some vba
code that will allow me to save the data in a query to a csv file (comma
separated text).  I used the acCmdImport command to import the data file
originally.  However, I don't know how to export it ...

what would make the frame around a form in design mode disappear?  I am
unable to select the form, right mouse click and select properties for the
form.  I have tried reloading Access.  I have tried rebooting.  Any
suggestions?

I am setting up a patient information db at work and was wondering if this is
a possible option:
The key field is the patientID, and as I start to key in the number, if the
patient already exists on the system can I have their details appear on the

I enter the procedures and module on Article ID 209871: "How to create
password protected Form of Report" in the Northwind Sample and I received the
error on the above subject.  I also used the same codes in my Form and it
gave the same error.