I have an idea of what I have to do, but I am a bit confused as to how to
approach this correctly:
I have a BE database and a FE database.  In the BE database I created a macro
to execute a function that will Transfer the updates from AS400 file to

I've tried Open, Load, Activate and Current events but cannot get my frmHiddenForm to hide on startup.  Me.Visible = False does work; it works from the Resize event.  Will you help me out of my ignorance?

I am probably missing something simple here, but I am trying to create a new
table based on the name a user inputs in a text box on a form. That part is
fine, but I can't figure out how to create the new table in the backend (a
different .mdb where I store all of the tables). ...

Hi. I checked the reponses from earlier questions but I have DAO in my
references, so I don't think that's my difficulty here. I have the following
code in a module"
   Set DB = CurrentDb

I have a date field call Recon Due. Every month i need to be checkin which
recons are due for the month. But i would like the field to turn a different
color 2 weeks before is due. For example if i have one due on 7/25/2005 i
would like for that field to turn Blue and when it's ...

How can I surpress the message you get when record not found in the Limit to
list from within the Combobox...?
This is not an error message but one built in to Access.
I want to tell the user that they need to enter this custoemr into another

I am using Access 2k and I want to add one hour to a timevalue. Thank you for
any assistance you can provide.

Hi again,
Gaaa!  So, I'm comparing two date fields (SQL) and for some reason Access seems
to think 7/1/1999 comes after 6/30/2000.  I've run into this occasionally before
and just found other ways to do what I wanted but this time I absolutely have to

I have an orders form based on a query of two tables.  The form is similar to
the Northwind orders form.  I want to generate an orderID number by counting
the record in one of the underlying tables and incrementing it by one.  The
number msut appear in the control on the form and ...

I have a table named Design_spec. The field is Status_Icon. There are three
images: green, yellow, and red arrows with visible set to false.
I need to create a loop that looks at Status_icon field, and if the field
value says green, then image15.visible = true, and so on for each ...

If I set the .Sorted property for a treeView to TRUE and then add a new
node, with the new node automatically be placed in the correct sort order?

I have a series of macros that I want to convert to a VBA module.  The first
action in the macro is TransferDatabase (Import an AS400 table to access
table.)  How do I do this in VBA?  I want to write to a log file as I go
along to keep track of what is going on? Also, use error ...

I had a user open a table through the database window at the same time they
were editing it in a subform. It seems to have caused an error in a field in
the table which was resolvable only by erasing the entry and recreating it.
Otherwise, even just mouse-overing it would cause an ...

I need to reset all of my option buttons on a form to FALSE, when the user
clicks a button. I cannot find the syntax for this anywhere. Can you please
give me an example.
Thanks for your help,

I'm building an updater program with several forms and reports to be
transferred from the Updater program to the working copies of a program used
by
multiple users.  I've built the updater using the TransferDatabase method.