PC Datasheet helped me with some code some days ago for which I'm very
grateful. I wanted a message to appear if the user didn't enter data into a
control on a form. Here is the code
Dim MsgStr As String

I have a form where I put in customer's information.  I also have a
table of zip codes and their corresponding towns and states.  What I
want to do is make the for to where when the user enters the zip code,
the townand state automatically appear in their respective boxes.

Hello, All.
First let me say: I've gotten lots of good information in these discussion
groups. I've been working with Access for all of 3 months and in general it
seems that everybody follows a similar learning curve. So lots of my

I have a form that about 30 people use to enter data on a daily basis.  I
wanted to offer color options via simple buttons, like a bright, a soft etc.  
I have this so far:
   Me.Section(0).BackColor = vbBlue

I am outputting the contents of memo fields to a RTF file to email, and i
have just noticed that Access seems to be truncating odd words at end of
text ( at least that  is where we have noticed it).
Understand that this might be an Access 'featurette'

I have a Form ("JobFormA") and a Subform ("JobFormB")
JobFormA is based on Table "JobTabA" and JobFormB is based on Table "JobTabB".
In the subform I have a field "Ino", which is numeric type, in that the user
enters the RowNumber manually for every record.

I have an unbound form that is used to input parameters for a query. On the
form I have a Cancel button in the event the user changes their mind. The
code on the Onclick property is
Private Sub cmdcancel_Click()

Can you help me with this.  Below is some code that I got from somewhere
(apologies but I can't remember where now), which I've tried to adapt to do
what I want.
I'm trying up update a column of figures within Excel from a COLUMN of

on a special textfield i would like the user to be able to just press
'return' in order to set a command button the default one.
_____________________________
Private Sub txtX_KeyDown(KeyCode As Integer, Shift As Integer)

Why is this function not listed in the Built-In Function list in Office 2003?
Or am I missing something?
Mary

Hi
Is there a way, i can do the following.
I would like to select a field in a combox and then
related field in the child table would display on the

I have written a function called FormIsOpen to test whether a form is
currently open and put it in a module. The function code is as follows:
Function FormIsOpen(FormName As String) As Boolean
Dim AnyForm As Form

I have the follwing code:
Private Sub TypeofMedication_NotInList(NewData As String, Response As Integer)
Dim ctl As Control
   ' Return Control object that points to combo box.

I have a form "SubjectA" and a subform in it "SubjectB"
Form "SubjectA" field are :
FormNo
Customer

In order to adapt the correct format for a date in a SQL code,
I set as 'date function'
strBegin = Format(strBegindatum, "MM-dd-yyyy")
strEinde = Format(strEinddatum, "MM-dd-yyyy")