I have a database that has forms, queries displaying the information. I want
to use the Table Analyzer on the database. will I need to make any changes to
the forms or will the wizard take care of that.

I have a "Deposit Detail" report which pulls data from the "Deposit detail"
table based on the
Settlement date which is entered in a "Choose Settlement date for report"
form.

I have a database that has forms, queries displaying the information. I want
to use the Table Analyzer on the database. will I need to make any changes to
the forms or will the wizard take care of that.

I had created a form with combo boxes.  Then I had the bright idea to
alphabetize the entries by changing the properties of the form and now the
combo box displays NAME#.  I realize that this has something to do with the
Control Source but it remains in the underlying table for ...

I have a form New Hires (based on table New Hires) with a subform Dependents
(based on table Dependents). Table New Hires has been populated with new
employee information (name, address, SSN, etc ...). Table Dependents is empty
and awaiting entry through subform Dependents.

I am trying to create an image database in ms access ( so if I type
into the form foot, a picture of a foot is displayed in a window). I
have the table created, I need help linking the words to the images to
the window.

I'm trying to figure out what's missing from my code.  After adding a record,
if its not already in the combo box, I need to update my form and subform to
show the new record and related records (in the subform).  The form is
programmed to automatically add a client if the name is ...

If I put a button on a form, choose misc, run query, I get a list of
queries that does not include any delete queries.
Why is that?  It is easy enough to get around, but why?

On Nov 9 1999, 1:00 am, "-oWc-" <ewo...@hotmail.com> wrote:

I've tried figuring this out for a while with no luck.
I have a form called "frm_Credits", this is based on the "tbl_Credits"
table.  
This form has a subform called "frm_Credits_Contin" based on the query

I have designed a simple database but am strugling with the most
important part of it.
I have a database of service calls on vehicles. I import a list of not
working vehicles onto a table. Then I have a form, where I need to

I have a main form that contains data that I need to be automatically populated into a subform. The formula I've tried is:
Private Sub JobNum_Enter()
   Me.OrderRelNum = Form.OrderJobLink_Frm.SalesOrderNum.Column(2)
End Sub

Is there a way to make a form default to a new record, but still allow
users to go back and edit existing records?
Thanks,
- Joel

Can someone tell me how the customers list in the northwind db was created?  
I'm trying to replicate it but I cant figure it out.  Is is a split form?  if
so, how did they hide the form fields and only show the data sheet view?  
Also, how did they do the total line at the bottom?

Good morning all,
I have a main form (one) with a continuous subform (many). I need to be able
to add an option box to filter the main form to show:
a. All records