Hello Comm
I have a Form in MS Access. I use this Form to enter data in my in my
related data base. The key field is CodSig
On the other hand, I have a file in the path C:\Survey\Projs\BlqA.apr, which

Hi All,
I am trying to write this code and i am in need of help.
In my UPDATE form I have a checkbox on each row.  When an old document is
updated with a new revision then this is the user's process:

Is there a way to get the name of a column from a listbox?
What I tried was
strColName= Nz(Me.ListBox.Column(3).Name , "")
with no results.

I have a command button in a subform.  The subform is set to continuous.  I
have this in the OnClick Event Procedure:
DoCmd.SetWarnings False
DoCmd.RunSQL ("DELETE * FROM dbo_sds_dir_route WHERE RouteID = forms!rm_route!

I have the following code on a button on a form:
DoCmd.RunSQL "update tblMember set HealProjectFormSigned = " &
chbHealProjectFormSigned & ", DateProjectFormSigned = " &
CDate(txtDateProjectFormSigned) & _

I trying to gather the amount of time a person is on a phone call in minute
or seconds, I want to be able to start a call and end call and have the
difference in min/sec but if the user has to come back to it a start it again
for some reason , I want the min/sec to accumulate . ...

What is the difference?
The .Text , does it do or mean something
Thanks
DS

I have a combo box that is bound.  User needs to pick value to begin creating
a new record.  If the bypass this combo box and try to enter other vaules,
error is generated that they can not create record because of value required
by combo box.  I have tired on exit, etc coding to ...

I am trying to create some code that will confirm that the user entered a
valid date. The date must be today or in the future. Below is the code I
thought would work. It doesn't... Can anyone give me some help with the
proper syntax.

I run a query where the data pops up as #name? when there is no data,
is there away to convert this to show as 0 or blank when there is no
data? I run a crosstab query that populates data into months, someones
have no data and reflect #name?

Is it possible to have an if statement in a case, and if a condition is meet
then it runs the suggested case?
Thanks
DS

Is there a way to enter a quantity of records equal to a number in a
text box?
For instance,
Let's say I have a:

I have a record set of data. If I want to update parts of that data,
and keep the orginal record how would I go about doing so? Example
Item# 123456
Desc: Cookies

Access97
I have been using a crosstab query from the design view and want to
change it to code.
The SQL derived from the design view is: ( INTO statement added):

Am opening the same form (PtsForm) from a command button on two different
forms (MasterForm and EditForm). Would like to set a value based on which
form opened PtsForm. Tried using screen.activeform but with no luck. Is there
a way to reference the previous form?