A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need Help with Form Design



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2004, 03:57 AM
Eli
external usenet poster
 
Posts: n/a
Default Need Help with Form Design

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
  #2  
Old June 1st, 2004, 04:54 PM
Ragnar Midtskogen
external usenet poster
 
Posts: n/a
Default Need Help with Form Design

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


  #3  
Old June 1st, 2004, 11:51 PM
external usenet poster
 
Posts: n/a
Default Need Help with Form Design


-----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


.

I am going around to each computer for maintenance and
when i am there i will take down the information
  #4  
Old June 2nd, 2004, 12:31 AM
Ragnar Midtskogen
external usenet poster
 
Posts: n/a
Default Need Help with Form Design

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.