I have a field that was once a required field.  I eventually decided not to
make it required (to make a long story short).  This is what I would like to
do instead:
We have a checkbox on our Main form labelled "Completed".  We check this

I am au fait with getting a response if a value/text is missing in a field,
but how about a BeforeUpdate event checking nearly 50 fields?
So, instead of 50 instances of If IsNull(me.text1) Then...
is there any quicker way of checking and reporting back the fields that are

I've referred to a combo box's primary column in a query before
([Forms]![FormName]![ComboBoxControl]) but not with a column other than the
primary one.  What is the syntax?  E.g., I want to refer to column 7 but
these syntaxes are failing in one way or another:

I have been using the following code to convert all text to upper case. It
works in all my text boxes except one.
Private Sub Name_AfterUpdate()
Name = StrConv(Name, vbUpperCase)

I am extremely green with coding.  I have a form/subform that I need the user
to be able to click on the Find Button and have a Search Form open (done)
where they can type in all or part of any number of fields (18 search fields)
and a list of available records will appear in ...

I am trying to come up with some code to select a report date.  I would like
the calculate the dates for the current week, or current year, last year,
last month, ect.  Any ideas would be really great.
Thanks,

The following actually creates a query but with nothing in it, even in cases
where I am sure there are patients with "DDate" in the moth specified by my
attempted restriction. That is strSQL ends up as:
SELECT * FROM tblPatients WHERE DDate >= 4/1/2005 AND DDate <= 4/30/2005;

Hello,
I am trying to set the DisplayControl property on a field using DAOin
C#.  I've found lots of sample code for VB and am trying to adapt it
for use in C#.

I need to be able to build a SQL string dynamically to pass to a querydef.  
The string will be based on values chosen from a listbox control and/or other
controls on a form.  Any help would be greatly appreciated. Still learning.

I've been using form reference  "Forms!Form_Name!Field_Name"
I need to replace Field_Name with variable containing filed name.
Is it possible
AvP

I do have a problem. I have a form with a few subforms, and some of those
subforms do also contain subforms. The point is that I need to be able of
making copy of the main record, and all the information contained in the
subforms and its subforms. As first I would like to know if ...

I have a form based on a query.  On this form is a drop down to lookup
companyname on a master table that is different from the query.  The query
updates my main table, but the drop down of companyname is not populating
the table.

I have a form opening including two subforms. When opening the masterform,
the two subforms are invisible. I need to show the subform for a new record
with a button click. Any helpful hint?
jokobe

I have a password routine that works.  I have a table of Userid, UserName,
User password.
The password if successful will open an edit form.  How can I get the edit
form to populate with the User id from the password routine.  Below is my

i am trying to setup a couple of msgbox routines to check on 2 different items.
ITEM 1
- using the following text boxes on form [Input Data form].
[Uptime]         [Downtime]