Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Access 2007 forms wizard

I have all my tables ready and relationships created tried the form wizard used it to add field from multiple tables to create a form then when I try to open form to try it I get an error "the wizard is unable to open your form in form view or datasheet view possibly because another user has a source table open in exclusive mode" But there is no one else in Access but me!

Any ideas?

Posted by on

  • 1 more comment 
  • montasser Aug 18, 2008

    My data base was working very good, but suddenly every time i try to create a new form i got the following message

    "the wizard unable to create form"




  • LisaGA Oct 08, 2008

    I'm having this problem with reports. I have a report with several subreports. When trying to create a fourth subreport I got the "unable to create..." error.

  • shwethakunda Nov 05, 2008

    My problem is that I have created the tables in the MS Access 2003, and now the Access is upgraded to 2007 then when I'm trying to apply 'create a form with the wizard' am getting the error as 'unable to create your form' this's kinda very urgent..could anyone please post a solution asap.

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

If you run a repair install of office 2003

Posted on Jan 20, 2009

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Can u plz mail me tha easiest way to use Ms Access, like Creating relationship, with the table, creating form, query etc.


In general you initiate this process by pressing the "Relationships" button on the MS Access toolbar. It is the button with three small boxes arranged in a triangle shape.
rowell_randy_0.jpg

When it first comes up it will give you the option to add tables. You can add any set of tables including the possibility of adding one table more than once (you would do this if you wanted to create a relationship between fields in the same table).

Once you see the tables you're interested in, you simply drag the field from one table over a field in another table. The fields should be those that will define the relationship. Once done, you should see an Edit Relationships window. You can get back to the Edit Relationships window later by double clicking the line in the relationships window.
rowell_randy_1.jpg

MS Access does a good job of figuring out the relationship type. For example, if you match a field in one table, that is not a key, with a primary key in another table, Access will make this a Many-to-One relationship.

This can become a very deep subject. Hope this at least gets you in the right direction.

Dec 18, 2010 | Microsoft Computers & Internet

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 Computers & Internet

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

1 Answer

Hi, Need to create multiple running auto numbers in one table in one field, can anyone help?, am using access2000.


you can add page #'s in reports, insert, page #
you can't add auto #'s in the table without just adding the # in one field for each one
Access is a database program, the report option is where the page or file # is entered
I hope this helps

Apr 08, 2009 | Microsoft Access 2000 Step by Step...

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

2 Answers

Wizard unable to create form


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.

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

1 Answer

Calculations in Adobe 8.0


Are you using live cycle (Part of Adobe 8)
On the RAW form - select from main bar - Window, Script Editor

Your Addition or Subtraction will be :
Field 1 + Field 2 or Filed 1 - Field 2
For division, change this to Field1 / Field2
For multiplication, Field1 * Field2

I have a PDF (Created in Livecycle that calculate standard deviation in tabular format) - currently working on the graphical representation

Aug 13, 2008 | Computers & Internet

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 Computers & Internet

1 Answer

How to create program in delphi


i wants to create form for data input
with the condition

Mar 13, 2008 | Computers & Internet

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

851 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2929 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18413 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...