Is there a way to build a string and execute the command to initialize
fields on a from within a loop, something like below? I thought the
eval command might work but doesnt seem to.
arry(1) = "Local"

Hello everyone :)
I have a problem with some code and I cannot find the problem :(
The code I use is from Allen Brown and its purpose it to log errors in a
table.

I have a form with locked fields. In order to select individual records for
194 countries I use a combo box. To update this form I use another form with
unlocked fields which is opened with a command button with a Macro behind it.
I also use the follwing expression to filter this ...

How can I get this statement to only save the pID value in the field that the
combobox points to:
SELECT [persons.ptitle] & " " & [persons.pname] & " " & [persons.pSurname],
Persons.pID AS Expr1 FROM Persons;

I have two date fields. ExpenseStartDate, ExpenseEndDate.
when I enter the Start Date , the same date will be copied to the enddate.
and If for example I enter Start as 15nov06, and end is 14nov06 , a message
box will show "invalid Date" ,Cancel=true.

Is there a way to "zoom" at a report form during the design mode.  I am
designing a report with a lot of text.  I want to enlarge the view during the
design for alignment and convenience.

I have a main form and several subforms (tab control named NEC, HISTO and BLD
CHEM). The subform BLD CHEM also have a subform (tab control named RBC and
SE).  I created a print preview icon on the main form. I entered the code:
Select Case Me.TabCtl23.Pages(Me.TabCtl23).Name

I have a form - formA with a command button to open another form - FromB.
FromB contains a subform. When FromB opens I would like the subform of FromB
to open a new record with the same information entered by user from the
formA.

I am opening a dialog form to get some information. Then closing the dialog
form when done.
The problem I am having is that the sometimes I push the command button to
open the form it runs through the if is loaded section without giving me the

I have a form (frmMain) and subform (sfrmSub), both are bound to the
appropriate tables, and they are linked on the key field "OrderID" (subform
control is named Subform).  In the main form I have a combo box (bound to a
query) and button that I would like to use to have the user ...

Hi there, i have a button on my form which when clicked creats 5 new folders
in a new directory. I was wondering how i would go about copying two files
from a diorectory and putting them in the newly created folder as well each
time the button is pressed, thanks! WK

For some reason, none of my On Error GoTo statements are working this
morning.  Instead of going to the error handler, a dialog pops up asking me
if I want to end or debug.  All had been working fine previously .  Any ideas?

I have a very bizarre error.  The values for the New_Male_Sub, etc won't set
to the field that I am assigning it to.  I run through the code and it stay
zero.  It does set if I add a breakpoint for the line where I assign it.  
Huh?   It makes no sense.  What am I doing wrong, any ...

When I open my form I want it to open and the next available blank entry, I
do not want it to open on the first entry in my table, that is what it is
doing now.
Please let me know what propety to set to do this

My code worked before, but now has strange message. The error message is:
'ActiveX component can't create object'
My code is below:
Private Sub cmdExport_Click()