Create fields based on input?

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

Guest

Basically what I want to do is have a user enter a number into a field, and
then have that number of sets of fields appear for data entry. For example:

How many hard drives are present? "2"

[HDD1]
Size:
Serial Number:
Manufacturer:

[HDD2]
Size:
Serial Number:
Manufacturer:

and so forth, based on that input. Any ideas? Also, not sure if it
matters, but the form that I want to do this is a subform on a tab.

Thanks in advance,
Tara
 
Tara said:
Basically what I want to do is have a user enter a number into a
field, and then have that number of sets of fields appear for data
entry. For example:

How many hard drives are present? "2"

[HDD1]
Size:
Serial Number:
Manufacturer:

[HDD2]
Size:
Serial Number:
Manufacturer:
Click to expand...

This should be done in a subform using a table related to the main form
ID, MachineItsFromID, DeviceType, SerNum, Size, Manuf, DateInstalled etc.

Having separate fields will cause problems that can only be solved with a
lot of code.

Finding what machine has a device with serial number xxxxx-yyyyy is trivial
with a properly related table.

With your solution you will have to search through all the columns and may
not ever find out that the user gave you a serial number from a CD or floppy
drive.
 
I guess I should give a little more background on this so it makes more sense
what I am trying to do. The database I am creating is for internal use in my
office only. This puts the number of users currently at two. So, I am not
too worried about people entering the incorrect information. Also, the
database is, in essence, going to hold information about evidence in ongoing
computer investigations.

Say I have 2 HDDs in a particular case. I want to be able to type "2" into
a field and then have 2 sets of fields of requested information. I'm not
sure what the best interface format for that is, or the best way to go about
what I am trying to do. See below for a "sketch" of what I am talking about.

Any ideas would be greatly appreciated. BTW, I am pretty new to Access, so
specifics would be helpful.

Thanks,
Tara
Basically what I want to do is have a user enter a number into a
field, and then have that number of sets of fields appear for data
entry. For example:

How many hard drives are present? "2"

[HDD1]
Size:
Serial Number:
Manufacturer:

[HDD2]
Size:
Serial Number:
Manufacturer:
Click to expand...
Click to expand...
 
Tara said:
I guess I should give a little more background on this so it makes
more sense what I am trying to do. The database I am creating is for
internal use in my office only. This puts the number of users
currently at two. So, I am not too worried about people entering the
incorrect information. Also, the database is, in essence, going to
hold information about evidence in ongoing computer investigations.

Say I have 2 HDDs in a particular case. I want to be able to type
"2" into
a field and then have 2 sets of fields of requested information. I'm
not sure what the best interface format for that is, or the best way
to go about what I am trying to do. See below for a "sketch" of
what I am talking about.

Any ideas would be greatly appreciated. BTW, I am pretty new to
Access, so specifics would be helpful.
Click to expand...
Specifically, what you are trying to do is not a good idea in a relational
database and will require coding which might get complex. The coding
problems will not go away as you progress with the program and you will find
some types of reporting difficult as the needs may out strip your learning
curve.
It is bad design.
If you do it using the tools and suggestions found here and in Access help
it is a simple problem, well suited for somebody new to Access who is
willing to learn. In fact one of the templates supplied might well work.
 
Back
Top