I found an example of a databse on the internet that does what I am trying
to achieve.  That is:
Add several records to a form, when a new form is created.
When I place the exact same code in my database it crashes on the line:

can anyone tell me how to use an inputbox for searching info in a database?
for example, user wants to search all employees living in new york. when he
clicks the command button, an inputbox will appear asking him to enter his
chosen city. what command can i use to do that? i ...

Has anyone here used Access to automate BO?  I'd like to open, refresh and
export a BO report through an Access module.  I haven't been able to get much
info about the BO object model or code samples.
So, how about it?  Anybody have any experience with with this?

Why does my E-mail screen keep popping up and interfering with my programs
while I'm using them.

L.S.
The intention of the following code is to lookup the artDescrip in the
contraceptive table, using the description (which is a combobox) from the
subform visits1. The main form is called "registration form".

I need to make sure  a form is closed before the
application exits no matter how Access is closed. Is there any place to put
BeforeApplicationExit? How can I address this
issue?

I am currently working on a database in which the results of an
extensive questionnaire will be stored. To facilitate adding or
removing questions later on, the form that has to be filled in is
dynamically generated.

I have a series of nested tabs on forms. I am using
Set ctl = Forms!systemForm!Page2
DoCmd.GoToControl ctl.name
which works fine but now i want to go to page22 on form peopleGrid within

Help!  How do I change the subform "Main subform" source object to "test1
subform"? programatically.  I can find code to change the record source, but
I actually want to change the source object instead.  
Thanks for your help.

Help!  Below is the code to automatically import all text files.  This code
works great if the files are in the same layout, but causes data shifting if
the fields change.  How do I modify the code to change it to update if the
file layout is different?  

Greetings everyone!  I have a query that gets the max field length number.  
If the field is null, then there is no value.  How do I update the null to a
zero?  Below is the code.  
SELECT Max(Len([fnm])) AS FNM1, Max(Len([lnm])) AS Lnm2 FROM uppercustomer;

I program in both Access 2000 and 2003 and I was creating a form and I would
like to find a way to disable the Mouse Scroll.  I have set the forms to not
diplay the scroll bars or the Navigation. I have coded command buttons to
give the user the ability to move from one record to ...

In one of my apps I write a cmd file which is written to disk and then I use
ShellWait to call it.  On my machine, it works fine, But on another machine,
when the line from ShellWait:
   ret& = CreateProcessA(0&, Pathname, 0&, 0&, 1&, _

How do I open a word document from Access with VBA coding???
Thanks

I have a table that includes several records.  Each record has an agent
number.  I want to export the table to a folder on the server.  However,
there should be a separate file for each agent group.  For example, all
records with agent number 12345 would be in one file called ...