Question about Microsoft Office Professional 2007 Full Version for PC

2 Answers

Wizard unable to create form

I'm using Access 2003. I have a relationship set up and I want to create a new form in form wizard using the two related tables. I've created this form before in the past and it has worked. But it is not working this time. My students and I are getting the error message "wizard unable to create form". What's the problem?

Posted by on

  • cody-m901 Nov 10, 2008

    The relationship works

  • Anonymous Dec 01, 2008

    I have the same problem and it has nothign to do with relationships because I am using jsut one table

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

I had this problem and it was because a computer class was installing multiple kinds of access on one computer. they wanted to teach all of them, but are now screwing them all up. ha.

Posted on Aug 05, 2010

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    New Friend:

    An expert that has 1 follower.

  • Expert
  • 144 Answers

Check the relationships for errors.

Posted on Nov 10, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I have DataBase in MS Access But I want connect it to my HTML Page for Add, Edit, Save date in access through HTML Page-


Under the pages tab in the Database window is a wizard that will walk you through creating the page. You can then copy the code or tweak it as you need to. If you do this and want to continue to mange using forms however, you may want to split your database. that means load all the forms in one file and link them to the tables in another. There is a tool to do this automatically under TOOLS > Database Utilities > Database Splitter.

Mar 08, 2010 | Microsoft Office Standard for PC

1 Answer

Application and example of relationship in access


Relationships

After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

Having met the criteria above, follow these steps for creating relationships between tables.
  1. In the database window view, at the top, click on Tools ---> Relationships
  2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
  3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
    relationshipdrag.jpg
  4. Select Enforce Referential Integrity
    refintegrity.jpg
    • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
    • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
  5. Click Create and Save the Relationship

Apr 09, 2009 | Microsoft Business & Productivity Software

1 Answer

Data From Table Auto Fill


You need to create 2 tables. Create one table with just the Center Number, County and Center fields, using the Center Number as the primary key, lets call this table Center. Then create the other table with all the other fields you need, lets just call it the Main table for now.
Then create a relationship between the Center table and the Main table using the Center Number for the relationship. The relationship should be a One-to-Many from the Main to teh Center table. When creating the form, you take the fields from both tables. When you input the Center Number, the County and Center should be automatically filled in.

Apr 08, 2009 | Microsoft Office Access 2003 (077-02871)...

2 Answers

Hi all i want to launch a form when i click the data base file in MS access 2003 (the form is created inside the mdb file of access)


hi,

on MS Access 2003:
goto Tools Menu --> Startup --> select your form for "display form/page" dropdown
uncheck the "display database window checkbox and display status bar checkbox

Hope this helps.

Thanks.

Apr 01, 2009 | Microsoft Access 2003 for PC

3 Answers

Problem opening Access Database-upgrade from Access 2003 to 2007


It seems that you have your Database(.mdb) file is created in Office 2003.... thats why you are unable to open it in 2007.... I faced the same problem.... then I came back to 2003 in order to use our database......

Mar 25, 2009 | Enfocus PitStop Professional 08 Full...

1 Answer

No available fields in form wizard


If you select the correct table from the drop down, the fields should be shown in the box. or keep the table open and try creating form. or create a blank form and on the right side you will get tables and fields, you can just drag and drop required fields

Feb 10, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Nothing happens when I click form wizard?????


You might cancel the security wizards option during your 1st time click of "Form Wizards" of More Forms menu. To solve this problem follow this steps.
  1. In Access 2007, click the Microsoft Office Button, and then click Access Options (the office 2007 logo on your left top area of access 2007 or the Circle button on your top)
  2. Click Trust Center.
  3. Click Trust Center Settings.
  4. Click Trusted Locations.
  5. Click Add new location.
  6. In the Microsoft Office Trusted Location dialog box then click Browse.
  7. In the Browse dialog box, locate and select the folder that contains the Access database, and then click OK.

Nov 18, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Access 2007 forms wizard


If you run a repair install of office 2003

Jun 04, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

How we can create Forms & queries in access


For forms, open a data table in view mode, while there locate the forms setup wizard. For your first try just answer the questions the best you can for the wizard. When there are no more questions to answer wizard will create a form for you. From what you learn doing that you may get enough hints to make a form from scratch. Just keep in mind you always build a form from the fields in a table.
Now for the Query, start out the same way and use the wizard. Query to most folks means ask a question and get an answer. In access query is a way to present sub sets of data or ways to modify data in the fields of your tables.

Jun 03, 2008 | Microsoft Business & Productivity Software

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

1,620 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...