Log sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm making a log sheet to enter Product, Date and Description. Is there a
way to make this to look like a grid with 3 columns and rows for entering
the information on. Something like this.
Product Date Description
___________l______________l__________
___________l______________l__________
___________l______________l__________

Thanks in advance.
Jane
 
Jane, looks like you need a simple form in data sheet view to do this. Have
you created the table in which to store this data?
 
Hello,

I'm making a log sheet to enter Product, Date and Description. Is there a
way to make this to look like a grid with 3 columns and rows for entering
the information on. Something like this.
Product Date Description
___________l______________l__________
___________l______________l__________
___________l______________l__________

Thanks in advance.
Jane
Click to expand...

A continous Form (based on a table with fields for ProductID, [Date]
and Description should work. Is the Description the desscription of
the product - i.e. when the person entering data selects a product
should they see that product's description appear? or is it something
that they should type in for each record that needs one?

Note that you should REALLY start your design with the Tables - not
with the data entry form. What tables do you have?

John W. Vinson[MVP]
 
Hello,
I have a table with Product ID, Date and Description in it. We will type
the information into the description. Thanks. Jane

John Vinson said:
Hello,

I'm making a log sheet to enter Product, Date and Description. Is there a
way to make this to look like a grid with 3 columns and rows for entering
the information on. Something like this.
Product Date Description
___________l______________l__________
___________l______________l__________
___________l______________l__________

Thanks in advance.
Jane
Click to expand...

A continous Form (based on a table with fields for ProductID, [Date]
and Description should work. Is the Description the desscription of
the product - i.e. when the person entering data selects a product
should they see that product's description appear? or is it something
that they should type in for each record that needs one?

Note that you should REALLY start your design with the Tables - not
with the data entry form. What tables do you have?

John W. Vinson[MVP]
Click to expand...
 
Hello,
I have a table with Product ID, Date and Description in it. We will type
the information into the description. Thanks. Jane
Click to expand...

Fine; a continuous Form based on the table - or, better, on a query
sorting the table by the date field - should work. If you have a table
of Products I'd suggest using a Combo Box to select the product
(storing the product ID, displaying a human-meaningful product name);
a textbox for the date, with default value Date() to automatically
fill in today's date; and a larger textbox for the description. Does
that work for you?

John W. Vinson[MVP]
 
John,

That sounds great. I will try that. If I decide to have the description
fill in when the product is entered how would I do that? Thank you very much.

Jane
 
John,

That sounds great. I will try that. If I decide to have the description
fill in when the product is entered how would I do that? Thank you very much.
Click to expand...

You'll need to tell me more about your tables. Is the description a
description of the product? or might you log the same product
repeatedly and have a different description each time? What are the
other fields in this table, if any - for that matter, what are you
"logging"? What real-life thing or event do the records in this table
represent? What's the structure of your Products table?

John W. Vinson[MVP]
 
Back
Top