"Anggota Jemaat" and for SS member( Sabbath School Member/not baptized yet)
we do not assingn the number ( live it blank/zero).
Thi is the VBA to add the next number if we fill the member type as Hurch
member

I have a combo box which displays the employee names from a table. Users
select an entry to "reassign" a unit of work to another individual. There are
several employees with apostrophies in their name. The name appears without
the apostrophe in the combo box, so when work is ...

My colleagues and I have a problem that occurs while designing access forms
and it isn't helped by the fact that our applications have a lot of buttons
on their forms.
The best way I can describe the problem is to explain how to repeat the

I have a single master form that is set up kind of like a web
page in that it has frame areas. Heading, Company
Logo, Main Work area - which is a subform, and there is a tree menu.
Selecting nodes in the tree menu changes the subform and hence the

I am having a terrible time moving and re-sizing controls in "Design
View" using the new Access 2007 version.   In older versions of
Access, I could move controls independently of their labels and other
controls by clicking and dragging on a "handle" in the top left

I have been using code to alert user to changes that need to be made
to a record under certain conditions in Form Current.
CL_Type can be either Adult or Child.  The following *was* working
(along with other events and If statements in Form Current):

Access 2003
Example:
If IsNull(Forms!frmEditDispatch.articles) Then
the field "articles" is not actually on the form "frmEditDispatch" but a

Access 2003
search form  frmSearchDonors will have 1 field "txtSearchPhones"
it will also have one button that is meant to open a form with the donor
record containing that phone number in any one of its 3 Phone fields (Lets

Could someone please critique the following pice of code? The SQL was
copied directly from the query
Private Sub cmdDeSelect_Click()
   Dim strSQL As String

I changed my mouse and upgraded from IntelliMouse v4 to v5 or v6.
Scrolling in general works fine in forms and forms design but not in the
code window.
I think I came across this problem before some years back and went back

Access 2003
I have a small table with (among other fields) two check boxes one, if
checked, allows that record to be shown on a form. Once that record
has been used that check box is set to 0 while the other is set to 1

I have a data entry form where user input the data. Within the data fields,
I have field call Item, Side, sequence field where any combination of these 3
fields are unique. What I would like to achieve on the sequence field is
limit the selected based on selection of Item and ...

I have a small access database that I have created. I have one table with
three forms. There is a few duplicate data fields on the forms but not all. I
have the main form set to open the other forms based on choosing a checkbox.
What I need to do is automatically copy certain ...

I have a form based on two tables which are linked by a record#.  One table
is simple employee info first name, last name, id#, etc... the second table
is a bunch of checkboxes for different things relating to the employee.  My
issue is that if I enter only partial info in a new ...

When I create a msgbox can I have my own title instead of it saying
Microsoft Access?
Also - anyway of sizing it?
Thanks In Advance