I want to do some maintenance on a backend-database during the night.
The workstations are logged on this database with their front-end. Is it
possible to log them out to make a comapct and repair of the backend
database?

i have a form-form1. inside i have a combobox-combo0. whenever user selects a value from within the combobox, it is displayed in the textbox also there on the form-text2.now i have a query in access itself based on 2 tables in my db.
select a.col1
from a,b
where a.name=b.name

I have a continuous form with a combo box and hidden text box.  The form also
uses a query to populate this form.  The hidden text box is populated with
PointsPossible.  The combo box uses a query as follows.
SELECT tblPointsValueDropdown.PointsValue

I have three tables/forms. Table 1 - tbldemographics w/ MedicalRecord as PK.
Table 2-tblDeviceInfo w/ DeviceID (Auto) as PK and MedicalRecord as FK. Table
3 - tbl3MoFU is a 3 month follow-up to the device, 3MoFUID (auto) is PK and
DeviceID is FK.

I have a main form that holds student information. I also have a subform
that holds the class information that the student has or is taking. In that
subform, I have a drop down combo that drops down names of teachers.
I  also have an add teacher command button on the main form ...

i have one master form and five subforms..
in master form, i have one combo box to choose which subform u want to load
and display...
first thing i want to unload if any subform is open and then load the new

I am trying to create a function that need to return a date but getting the
error 13 type mismatch in my select :
Public Function ActivationDate(ActDateNotice As Date, IdBranch As Integer)
As Date

Is there a way to maximize the preview window when using the OpenReport
"Rpt", acpreview command?
The current window does not have Minimize or Maximize buttons and the user
would like to expand the preview window.  Maybe there is a way to force the

problem:
my subform in sheet view stay the same, each time when displaying, the
columnwidth is not changed as I did at the last time. I think, the reason
is, Subform is an instance of a form, it can't "remember" the columnwidth

I'm attempting to set the focus to a control on a subform if one of the
fields is blank.  The field name to set focus to is stored in the variable
FirstError.  The code I'm trying to use is:
   If Check = False Then

I have a parameter for a report, which, if it is included as a field in the
report - causes the summary not to SUM correctly.
I put the parameter in a textbox on a form
so that I could send criteria for that field without actually selecting it.

I am a new access user and need your helps.
I have two tables: City (primary key: city name) and Branch (primary key:
city name + branch number).
Say I have 2 fields (among others) in a form: City and Branch Offices. When

Hi there. Using A02 on XP. I couldn't figure out how to
describe this one.  I have a mainform where we key in
checks received and assign them for processing. When you
key in the contract number a subform is peopled with the

I'm used to developing C++ code with Visual Studio and had a little ADO
programming in VB before, but now a friend has asked me to modify an
existing database. Several checkboxes need to be placed on a form that when
checked, update a field in a particular record in a different ...

I'm looping through a list of files to compress one at a time.  I'm getting
an error when a database has a password.  I need to skip over that one, but
I'm having trouble trapping the error.  I have an OnERR statement, but it
throws a Run-time error: 3031.  Any suggestions?