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  

Data Form from tables



 
 
Thread Tools Display Modes
  #1  
Old January 25th, 2010, 04:58 PM posted to microsoft.public.access.forms
K11ngy
external usenet poster
 
Posts: 66
Default Data Form from tables

Hi, very new to Access, I have project i am stuck on

I have designed 4 tables:

1. Hardware
2. Supplier
3. IT Technicians
4. Staff details

I think I have made correct Primary and foreigh keys as in

Hardware ID, Staff ID, IT Technicians ID and Supplier ID as primary keys and
foreign keys in relevant tables

I need to make another table that stores fault logs and a user form to input
this data. I have tried variuous methods, to no real avail.

I want the staff details to be at top so that when user types in the ID
there name and details appear and underneath they can type in what the exact
fault is they are reporting. I just cannot get the first bit to work and
very unsure on this

Any help would be appreciated

Thanks

Steve


  #2  
Old January 26th, 2010, 01:30 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Data Form from tables

Use a combo box to choose the user all fill in any details that are
necessary (although the StaffID should be sufficient to store. Use a
subform, if there are multiple entries, or use the same form if there's only
a single entry per instance.

There is a wizard that will build the combo box code for you.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"k11ngy" wrote in message
...
Hi, very new to Access, I have project i am stuck on

I have designed 4 tables:

1. Hardware
2. Supplier
3. IT Technicians
4. Staff details

I think I have made correct Primary and foreigh keys as in

Hardware ID, Staff ID, IT Technicians ID and Supplier ID as primary keys
and
foreign keys in relevant tables

I need to make another table that stores fault logs and a user form to
input
this data. I have tried variuous methods, to no real avail.

I want the staff details to be at top so that when user types in the ID
there name and details appear and underneath they can type in what the
exact
fault is they are reporting. I just cannot get the first bit to work and
very unsure on this

Any help would be appreciated

Thanks

Steve




 




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 11:55 AM.


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