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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
forms using two tables
I have created a form using form wizard and info from two tables. However
the form will not accept either a new record or amendment to an existing record. I can however amend either of the two tables in table format. Can anyone tell me what the problem is? I am using Office 2002 although I note the database says 2000 |
#2
|
|||
|
|||
The only way to be able to use 2 tables at once in a form is to join them
using a query. If you've done that, is the query updatable? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Splinter" wrote in message ... I have created a form using form wizard and info from two tables. However the form will not accept either a new record or amendment to an existing record. I can however amend either of the two tables in table format. Can anyone tell me what the problem is? I am using Office 2002 although I note the database says 2000 |
#3
|
|||
|
|||
Have raised the query and used form wizard for the form. Edit is set to yes
but I still can'e input, is there something else I need to do? "Douglas J. Steele" wrote: The only way to be able to use 2 tables at once in a form is to join them using a query. If you've done that, is the query updatable? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Splinter" wrote in message ... I have created a form using form wizard and info from two tables. However the form will not accept either a new record or amendment to an existing record. I can however amend either of the two tables in table format. Can anyone tell me what the problem is? I am using Office 2002 although I note the database says 2000 |
#4
|
|||
|
|||
My question was "If you open the query, can you make updates in it?", and
you haven't answered that question. See http://msdn.microsoft.com/library/en...DataQueryS.asp for details on what makes a query updatable or not. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Splinter" wrote in message ... Have raised the query and used form wizard for the form. Edit is set to yes but I still can'e input, is there something else I need to do? "Douglas J. Steele" wrote: The only way to be able to use 2 tables at once in a form is to join them using a query. If you've done that, is the query updatable? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Splinter" wrote in message ... I have created a form using form wizard and info from two tables. However the form will not accept either a new record or amendment to an existing record. I can however amend either of the two tables in table format. Can anyone tell me what the problem is? I am using Office 2002 although I note the database says 2000 |
#5
|
|||
|
|||
forms using two tables
Hello Doug,
I am in need of inserting into two tables using one form with Access 2002. The form has 8 fields. All 8 are needed for Tbl1 but only a select 3 are required for Tbl2. Based on your statement, is Expression Builder the place I would create the SQL join? Additionally, should I posit this as an "After Update" Event? Although new to Access, I am comfortable with SQL. Where can I get more information regarding how to accomplish this? Any help or redirection is appreciated. Thanks, --Paul "Douglas J. Steele" wrote: The only way to be able to use 2 tables at once in a form is to join them using a query. If you've done that, is the query updatable? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Splinter" wrote in message ... I have created a form using form wizard and info from two tables. However the form will not accept either a new record or amendment to an existing record. I can however amend either of the two tables in table format. Can anyone tell me what the problem is? I am using Office 2002 although I note the database says 2000 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
query problem with linked SQL tables when importing to new mdb file | Keith G Hicks | Running & Setting Up Queries | 2 | March 22nd, 2005 09:44 PM |
Creating Forms and linking to Other Tables | Daniel9684 | Using Forms | 2 | January 20th, 2005 10:57 AM |
Tables and forms | BusterMcT | Using Forms | 3 | December 23rd, 2004 11:47 PM |
Transfering tables, queries, forms and reports | jerryjo | New Users | 5 | December 2nd, 2004 04:09 PM |
Passing Variables or Database Parameters to forms and tables... | R Schlageter | New Users | 1 | May 12th, 2004 10:10 PM |