I have a form for entering information about jobs. On this
form is a subform for entering radioactive dose amount
recieved while performing the related job and another
subform that displays the current total dose for all jobs.

Hi
I have the following variable
dim test as variant
test="test_control"

BlankContext:  Access 2002
I enter some data into a field in a sub-form which is displaying a record
from an underlying query.  Then without exiting the field, I click on a
command button to save the record.  The result is an error message that the

My main form has two subforms. I am trying to add values from controls on
the two subforms into a control on the main form. Here is the expression I'm
using:
=Nz([Sections].[Form]![SectionTotal],0)+Nz([Labs].[Form]![LabTotal],0)

The question is should it work to use a function variable like I do for
WHERE statements, it goes and gets the variable, and the query opens, but is
not sorted.
Function lstSortOrder() As String

I have a main form with a subform embedded that lists percentages for each
main form record. The total of all the percentages in the subform records
for each main record MUST equal 100%.
I have put a footer in the subform that totals the percentage fields. No

I have huge mdb application on access
This application can be compiled
But when i try to create mde file i get the error: microsoft access 2000
could not create mde file

When I take the Form_Error Event in an Accessform to display errormessages, I
get only the error-no. 3146: "ODBC-Call ..." Is there a way to display
errormessages from SQLServer such as Trigger-Errors, Index-Errors, etc.. ?
(p.e. an stored procedure call functions with a ...

I am looking to incorporate a distributable spell checker into my a2k app.
The one I have chosen is SpellEx, they have an ocx and a dll version of
their spelling engine. I would be interested in any opinions regarding
preferences. Is there any reason/advantage to choosing one ...

Hello group,
I have the following code that is giving me error number 91. (i am trying to
count records in a list box with this code); I have the read the ms access
help on it, but it doesnt make sense to me. I have tried adding a break

Can anyone tell me how I can create a folder programmatically, with a name
generated from the contents of a field?
Thanks.

Why Access truncates the field that I have on a report to 255 characters?
even if I've set the property CanGrow = True
The field is attached to the report's recordsource which itself made of a
query. and the query displays the full text (more than 255char)

I have a subform that I always use. It is in datasheet format. The first
column is combobox CATEGORY.  The Pull Down SHOWS "A","B","C","D","E","F"
I usually enter two records for "A", two more with "B", and two more with "D".
Sometimes I use "C", "E", or "F".

Having looked at the nothwind sample database re orders I want to create a
similar event such that when a company is selected from a dropdown the
address is filled in automatically.  I have created 2 Tables add_master &
invoice and two forms add_master_ip and invoice_ip.  On the ...

I have a folder I want to BackUp this folder each Friday. Copy the files of
the folder from the source to destination , only the files that the date is
different.
I don't know if I have to use FileIO