MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Tables in User Forms

  Asked By: Phil    Date: Sep 12    Category: MS Office    Views: 702

I am trying to create a user form is in two parts. First part is
effectively a header consisting of basic details of a job. (order no.
Client , name, time contraints etc) and each entry will be unique.

The second part will ideally be a table to allocate resources against
weeks, with resource names down the left side selected by check boxes,
and week end dates, produced by the dates in the first part across the
top. The table will be populated manually and the data transferred to
a second database.

I also want to be able to retrieve and edit the records on a similar

As I am writing this, I am thinking should I be in Access??

Any help or comments would be appreciated



1 Answer Found

Answer #1    Answered By: Reginald Thomas     Answered On: Sep 12

It's not the complexity of the form  that should answer this question, it's
the shape of the data.

It looks as though you are talking about a series of job  master records,
each with multiple resource  records. This immediately sounds "database" to
me. Trying to store this sort of data  in Excel is definitely non-trivial,
while it is bread and butter to a database.

You can create  your forms  in Access, or you can do them in Excel and access
the Access database  from Excel.

(Or you can do the lot in Excel if you wish.)

Didn't find what you were looking for? Find more on Tables in User Forms Or get search suggestion and latest updates.