I have the .mde file, whenever I open a form from that .mde, the second user
might not be able to open it again. when they ran it, they gonna have this
message:
The database has been placed in a state by user 'Admin' on machine 'CD123'

Is it possible to get a common dialog for deleting?
I am looking for the one with the paper flying across the msgbox into the
recycle bin.  Just like the one used for Windows.
Thanks

I have a subform which has a combo box in which data is entered as a project
number. Currently, this works as intended.
Once a project is completed, I add a close date to the Projects table.
I wish to be able to only see Active project numbers during data entry and

Can anyone please help?
I was creating a new database importing from another when
everything locked up. I am using Access 2000 and the only
way I could do anything was to Ctrl+Alt+Dlt. When I

I get an error message on the .Add LINE ("only user-defined types defined in
public object modules can be coerced to or from a variant or passed to
late-bound functions")
   Dim myPriority As typPriority   'In module CustomTypes

Hello!!
I have to set (by code) the control source of a textbox and I use the
following code:
   myTextBox.ControlSource = "IIf(1=1;'True';False')

I have a dropdown box with the values from 1-5 and I want to show textboxes
accourding to the value given in the dropdown! e.g. The value selected is 3
and I have Unit1; Unit2; Unit3 textboxes displayed and Unit4 and Unit5
hidden. How do I do that? Without VBA if possible. :/

I have to show outstanding quantities of deliveries for orders. There is no
problem if there was a partial delivery: outstanding=ordered-delivered. In
case of orders where there was no delivery at all, the field delivered
contains no value i.e. null. Accordingly the field ...

I have simple access database, I have two forms...first form creates a
criteria for data to be displayed on second form. i.e. based on selections
the recordsource for the second form is created and passed after opening the
form in the form of a sql statement select item1, item2, ...

I want to be able to close 1 form and open another form that displays the
result of the first form, but  I have no idea how to do it! I tried various
options in VB but with no joy.

I have some controls in a form locked because changing them is uncommon (the
name fields in a record) and it's sort of easy to accidently edit them. I
have a little button the user can hit if they really want to be able to edit
them but this is off by default.

I have two forms (Form1 and Form2)> Form1 has 7
comboboxes and I want to open Form2 using any combination
of the comboboxes. The problem is that if any one of the
comboboxes has not been selected and its current value is

Is there a way to determine by code what record is currently the uppermost
visible record in a continuous form?
Me.SelTop return the selected record.
But I need the user to select a record and the vba code

I have create a form for inputing data and within  that form I have a button
for printing a sheet which details the input data. When I select "print" the
input data doesn't appear in the respective fields. Close the record and go
back in and print its ok. How can I commit the ...

Ttable 1 is updated when a button is clicked on my form and Table 2 is
updated from the sub form when the same button is clicked.
What I would like to do is have the autonumber field which is the primary
key in the 1st table to copy into my 2nd table once a query is run to update