I am designing (as a public service) a database for a client who wants a lot
of text boxes on a form to help him set up colleges class schedules. There
are 7 textboxes that go with each ComboBox.  I am using the ComboBox query to
autopopulate the TextBoxes. I have everything ...

Does anyone have an example of how to use the ALTER USER statement in code? I
want to use it to allow users to change their passwords when I deploy the
app. Currently I have everybody with the password "new", and at initial log
on I want to promt them to change their password.

I have a current post going for this but I think I may have exhausted my
expert and it's getting a bit confusing.
What I have is a Main Form.  In the detail is an option group (toggle
buttons) to go to the various tabs which each have a subform.  Each subform

I'm trying to find the last Date a transaction occured for a particular
customer and the DMax doesn't seem to be working.  Should I be using
something else?
Forms!Form6!Text2 = DMax("ChkDate", "tblChecks", "ChkCustomerID = " &

Scenario:    When adding a donor to DonorMaster table the table is updated; also
during this function I want to load, to each of the sub tables, the donor
number and the reference number. I do this by having setup a relationship
between tables (See below). Control Source for the Add ...

I want to be able to change and save the BackColor of an open form but when
the form is closed and re-opens, the Backcolor reverts back to what it was.
Is it possible to Save the new property value while the form is open?  (I
want to try and avoid storing the value in a table)

I have a database for problem reporting, with user-level security in place
(test version so far).  Each record involves four steps: Problem
Description, Response, Follow-up, and Final Approval.  I want to make sure
that only the person who wrote the Problem Description can edit ...

Below is my code. It simply can't run.
Private Sub cboDateExpired_BeforeUpdate(Cancel As Integer)
Dim date1, date2 As Date
date1 = Me!DateExpired

I am trying to update a date field on table tblApplications using the
code on command button btnGo as shown below. I think the procedure
runs the query  as expected but then JET engine says " you are about
to update 0 rows, Yes to accept or No to cancel"....

I have a continuious form that records sign in times for employees. My
problem arrises when an employee puts thier name in the control a new record
appears for the next person with the current time on it as I have it set to
Defalt Value =Now(). So 20 minuites later when another ...

I have run into problems in creating a records database for a scout group I
work with.
I have a form allowing me to select any number of people via a yes/no box.
The lists of people appear in a subform named subActiveMembers

Can anyone please help me to check the code below?
I execute in VBA and a error message display object required...
Dim SecondDate As Date
SecondDate = CDate(Me.cboDateExpired)

I have a subform with two combo boxes. The combo boxes have been set up so
that the selection in the first combo box limits the selection list of the
second combo box. These boxes seem to be working propoerly, but I would like
to make a small change and that is where I am having ...

I have a subform called "InvoiceDetailssubform" and a main form called
"invoices details"
in the subform there is a field Expenseitemamount
so to get total of this field ,i have places a text box in the footer of the

I'm having some trouble with a sql statement within my sub. For some
reason, it wants to reference CLPROPSTRTNMBER when I specifically
asked for CLPROPSTRTNMBR (which is the correct column name). The code
is below. I cannot figure out why it's trying to pull this reference.