Need Help with Form Design

  • Thread starter Thread starter Eli
  • Start date Start date
E

Eli

Hi all,

Look I admit it, I don't no where to start with creating
a Form. What I want is to have a database that i can
enter a form and type the name of a computer in my
network and the following information pops up in the form

- Hardware information - Motherboard, RAM, CPU
- Software information - OS, Applications, Utilities
- Location information - Location, User

I currently have setup one table containing all of these
and these are the heading in the table.

Computer, Motherboard, BIOS, RAM, Harddrive, Case, Video
Card, SOund Card, Network Card, Floppy Drive, CDROM,
Speaker, Monitor, Other Hardware, Serial Number,
Operating System, Office Suit, Internet Browser, Graphics
Tool, Zip Tool, Acrobat Reader, Macromedia, Other
Applications, User, Location

As you can see I don't know what i am doing, but
basically I want all this information to be viewable if i
enter a form and type the name of the computer in a text
box and hit enter all of this info should pop up.

Then i can print the page off and thats all i need it
for, that and a form for adding the above info into a
table from the form.

Isn't there a simple way to do this?

Please help, thanks in advance
Confused
 
The form design is trivial, it can be designed by using a form wizard.
The hard part is to get all the info you want. You would need to use some
Windows API functions. I am not even sure you can get all this info for
remote computers on a network.

Ragnar
 
-----Original Message-----
The form design is trivial, it can be designed by using a form wizard.
The hard part is to get all the info you want. You would need to use some
Windows API functions. I am not even sure you can get all this info for
remote computers on a network.

Ragnar


.
Click to expand...
I am going around to each computer for maintenance and
when i am there i will take down the information
 
In that case you are practically home free, just create a form with either
the Form Wizard or use Autoform and choose the layout, in either case you
just select the table you want to base the form on and Access will create
the form for you.
The Form Wizard lets you choose a layout, but it also lets you select the
table fields you want to appear on the form, in case you don't want to show
all of them. For example, if you have a key index field in the table that
just contains a unique number you probably don't want that on the form.
If you are not happy with the form you can easily modify it by dragging the
controls around, or you can scrap it and try again with a different layout.
With 30 fiields you might be best off with the columnar layout.

Ragnar
 
Back
Top