UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Whats the best way to have a user enter data into a table?    
 
   
RCman
post Jan 18 2007, 02:43 PM
Post #1

UtterAccess Enthusiast
Posts: 69
Just wondering what your opinions where on how the user should enter information into a table without actually going into the table view? Thanks.
Go to the top of the page
 
+
NoahP
post Jan 18 2007, 02:51 PM
Post #2

Retired Moderator
Posts: 10,493
From: Lexington/Louisville KY USA
The short answer is a bound Form.
Go to the top of the page
 
+
RCman
post Jan 18 2007, 02:57 PM
Post #3

UtterAccess Enthusiast
Posts: 69
I forgot to explain this but the data on the form needs to be from two different tables. But when i create a form from a query that includes both tables and try to enter new information with the form it tells me that is can't find a certain field. For example an ID field. If its a new ID that is not already in the Database it will not insert it into the table. Does that make sense?
Go to the top of the page
 
+
DougY
post Jan 18 2007, 03:30 PM
Post #4

Utterly Abby-Normal
Posts: 9,756
From: Seattle, WA [USA]
Are the tables related?
Is the query updateable?
Go to the top of the page
 
+
Reyno
post Jan 18 2007, 03:31 PM
Post #5

New Member
Posts: 8
From: Washington, DC
So many questions to ask...

Are your tables related?
Have you thought of a sub-form?
Is the ID an autonumber field? On both tables?

Can you provide a little more detail on your tables?
Go to the top of the page
 
+
RCman
post Jan 18 2007, 03:46 PM
Post #6

UtterAccess Enthusiast
Posts: 69
Here is the database with the two tables in it. I have put a made up record in there to show you how the tables are related.
Attached File(s)
Attached File  DB.zip ( 274.74K ) Number of downloads: 4
 
Go to the top of the page
 
+
HiTechCoach
post Jan 18 2007, 04:08 PM
Post #7

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
See the attached.

I added some primary keys that are autonumber and updated your insert appt form.

Is this what you want?

Edited by: HiTechCoach on Thu Jan 18 16:14:56 EST 2007.
Attached File(s)
Attached File  DB_HiTechCoach.zip ( 220.01K ) Number of downloads: 7
 
Go to the top of the page
 
+
RCman
post Jan 18 2007, 04:47 PM
Post #8

UtterAccess Enthusiast
Posts: 69
Cool Thanks.
Go to the top of the page
 
+
HiTechCoach
post Jan 18 2007, 10:35 PM
Post #9

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
You're welcome!

Glad we could assist.

Good luck on your project ...

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/uarulez2.gif)
Go to the top of the page
 
+
« Next Oldest · Access Q and A · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 08:32 PM